PT-II Examination -- IX (IT)

                                   Class IX (IT)- PT-II Examination-2020
Instructions:-
A. This Question paper contains following two COMPULSORY parts:-
      i)PART 1-OBJECTIVE-(Ques no 1 to 20)- 20 Marks, (No Negative Marking)
      ii)PART 2- SUBJECTIVE -(Ques no 21 to 30)-20 Marks
B. Part 1 - Objective must be attempt in form of online quiz, Tick correct options of ques 1 to 20 and finally click 
     on submit button. Once a quiz has been submitted then you can not change your answers.
C. Part 2- Subjective is in format of pen paper test. You have to write answers in here or in notebook and scan 
     the answer by mobile after writing in notebook and upload file in one PDF format in "show your work" 
     questions.

0

Name of Student

0

Roll No. of Student

0

Class and Sec of Student

PART-A (Objective section)

1

Q:-1 A function should start with __________________

1

Q:-2 Which of the following technique can be used to allow only data value in cell ?

1

Q:-3 What is the name of mechanism to arrange the data in a particular order ?

1

Q:-4 Which of the following type of package does Calc refer to ?

1

Q:-5 How many axes does charts in Calc have ?

1

Q:-6 A cell is a combination of ________________________.

1

Q:-7 $A1$B2 is an example of ____________________.

1

Q.8 Which of the following is an extension of a worksheet created in Calc ?

1

Q:-9 We can replace multiple occurences of a word using which of the following facilities of Calc ?

1

Q:-10 Which of the following option is used to print a chart ?

1

Q:-11 The column immediately next to column "Z" is __

1

Q:-12 Numbers entered into a cell are automatically ___________ aligned.

1

Q:-13 The spreadsheet feature used to continue the series is called as ______________.

1

Q:-14 How can one calculate the total of values entered in a worksheet column of ?

1

Q:-15 In _____________ referencing, the reference changes rows and columns automatically when it is copied to a new cell.

1

Q:-16 The numerical data consisting of only numbers are called ____________.

1

Q:-17 A block of adjacent cells in a worksheet which is highlighted or selected is called ________________

1

Q:-18 ________________________ search the function from the list of available functions.

1

Q:-19 Which of following is not an example of a spreadsheet softwares?

1

Q:-20 ______________ is the any text entered by using a keyboard.

PART-B (Subjective section)
From Question no. 21 to 24 attempt any 3 questions.

2

Q. 21 Aadya is working on a spreadsheet. Help her with the solutions for the following :
(a) Identify the following symbol/toolbar and mention its use: $
(b) Renaming a worksheet from sheet1 to Cost Sheet.

2

Q. 22 Mention any four parts of LibreOffice Calc.

2

Q. 23 What are the steps to
(i) insert a colum left to the position of the cursor
(ii) insert a row right to the position of the cursor

2

Q.24: - Give any two uses of the fill handle.

From Question no. 25 to 28 attempt any 3 questions.

3

Q. 25 Consider the following data :
a) Write the formula to find the sum of all subjects of Kerry and Risha.
b) Write the formula to find the average of marks of John.
c) Write the formula to find total marks in science by all the students.

3

Q. 26 Give the syntax and example of any three mathematical functions in spreadsheet.

3

Q. 27 What are the three types of referencing in LibreOffice Calc.

3

Q. 28 Mention and explain three different types of data that can be entered in a worksheet.

From Question no. 29 to 30 attempt any 1 question.

5

Q. 29 Write steps for the following:

5

PT-II Examination -- IX (IT)

Name of Student

Roll No. of Student

Class and Sec of Student

Q:-1 A function should start with __________________

Q:-2 Which of the following technique can be used to allow only data value in cell ?

Q:-3 What is the name of mechanism to arrange the data in a particular order ?

Q:-4 Which of the following type of package does Calc refer to ?

Q:-5 How many axes does charts in Calc have ?

Q:-6 A cell is a combination of ________________________.

Q:-7 $A1$B2 is an example of ____________________.

Q.8 Which of the following is an extension of a worksheet created in Calc ?

Q:-9 We can replace multiple occurences of a word using which of the following facilities of Calc ?

Q:-10 Which of the following option is used to print a chart ?

Q:-11 The column immediately next to column "Z" is __

Q:-12 Numbers entered into a cell are automatically ___________ aligned.

Q:-13 The spreadsheet feature used to continue the series is called as ______________.

Q:-14 How can one calculate the total of values entered in a worksheet column of ?

Q:-15 In _____________ referencing, the reference changes rows and columns automatically when it is copied to a new cell.

Q:-16 The numerical data consisting of only numbers are called ____________.

Q:-17 A block of adjacent cells in a worksheet which is highlighted or selected is called ________________

Q:-18 ________________________ search the function from the list of available functions.

Q:-19 Which of following is not an example of a spreadsheet softwares?

Q:-20 ______________ is the any text entered by using a keyboard.

Q. 21 Aadya is working on a spreadsheet. Help her with the solutions for the following :(a) Identify the following symbol/toolbar and mention its use: $(b) Renaming a worksheet from sheet1 to Cost Sheet.

Q. 22 Mention any four parts of LibreOffice Calc.

Q. 23 What are the steps to (i) insert a colum left to the position of the cursor(ii) insert a row right to the position of the cursor

Q.24: - Give any two uses of the fill handle.

Q. 25 Consider the following data :a) Write the formula to find the sum of all subjects of Kerry and Risha.b) Write the formula to find the average of marks of John.c) Write the formula to find total marks in science by all the students.

Q. 26 Give the syntax and example of any three mathematical functions in spreadsheet.

Q. 27 What are the three types of referencing in LibreOffice Calc.

Q. 28 Mention and explain three different types of data that can be entered in a worksheet.

Q. 29 Write steps for the following:

Q. 30 Write the steps to insert a chart in Calc.

Name of Student

Roll No. of Student

Class and Sec of Student

Q:-1 A function should start with __________________

Q:-2 Which of the following technique can be used to allow only data value in cell ?

Q:-3 What is the name of mechanism to arrange the data in a particular order ?

Q:-4 Which of the following type of package does Calc refer to ?

Q:-5 How many axes does charts in Calc have ?

Q:-6 A cell is a combination of ________________________.

Q:-7 $A1$B2 is an example of ____________________.

Q.8 Which of the following is an extension of a worksheet created in Calc ?

Q:-9 We can replace multiple occurences of a word using which of the following facilities of Calc ?

Q:-10 Which of the following option is used to print a chart ?

Q:-11 The column immediately next to column "Z" is __

Q:-12 Numbers entered into a cell are automatically ___________ aligned.

Q:-13 The spreadsheet feature used to continue the series is called as ______________.

Q:-14 How can one calculate the total of values entered in a worksheet column of ?

Q:-15 In _____________ referencing, the reference changes rows and columns automatically when it is copied to a new cell.

Q:-16 The numerical data consisting of only numbers are called ____________.

Q:-17 A block of adjacent cells in a worksheet which is highlighted or selected is called ________________

Q:-18 ________________________ search the function from the list of available functions.

Q:-19 Which of following is not an example of a spreadsheet softwares?

Q:-20 ______________ is the any text entered by using a keyboard.

Q. 21 Aadya is working on a spreadsheet. Help her with the solutions for the following :(a) Identify the following symbol/toolbar and mention its use: $(b) Renaming a worksheet from sheet1 to Cost Sheet.

Q. 22 Mention any four parts of LibreOffice Calc.

Q. 23 What are the steps to (i) insert a colum left to the position of the cursor(ii) insert a row right to the position of the cursor

Q.24: - Give any two uses of the fill handle.

Q. 25 Consider the following data :a) Write the formula to find the sum of all subjects of Kerry and Risha.b) Write the formula to find the average of marks of John.c) Write the formula to find total marks in science by all the students.

Q. 26 Give the syntax and example of any three mathematical functions in spreadsheet.

Q. 27 What are the three types of referencing in LibreOffice Calc.

Q. 28 Mention and explain three different types of data that can be entered in a worksheet.

Q. 29 Write steps for the following:

Q. 30 Write the steps to insert a chart in Calc.

Q. 21 Aadya is working on a spreadsheet. Help her with the solutions for the following :
(a) Identify the following symbol/toolbar and mention its use: $
(b) Renaming a worksheet from sheet1 to Cost Sheet.

Q. 23 What are the steps to
(i) insert a colum left to the position of the cursor
(ii) insert a row right to the position of the cursor

Q. 25 Consider the following data :
a) Write the formula to find the sum of all subjects of Kerry and Risha.
b) Write the formula to find the average of marks of John.
c) Write the formula to find total marks in science by all the students.

Q. 21 Aadya is working on a spreadsheet. Help her with the solutions for the following :
(a) Identify the following symbol/toolbar and mention its use: $
(b) Renaming a worksheet from sheet1 to Cost Sheet.

Q. 23 What are the steps to
(i) insert a colum left to the position of the cursor
(ii) insert a row right to the position of the cursor

Q. 25 Consider the following data :
a) Write the formula to find the sum of all subjects of Kerry and Risha.
b) Write the formula to find the average of marks of John.
c) Write the formula to find total marks in science by all the students.