NEW OXFORD SCHOOL - CBSE
Doddathimmasandra, Sarjapura(P), Anekal(T) - 562 125
Affiliated to CBSE New Delhi, Affiliation No. 830703
PERIODIC TEST - 3 November- 2024-25
GRADE: IX SUB: Information Technology
Marks: 30
I Answer the given 5 questions (1 x 5=5 Marks)
i. Which of the following is/are mathematical operators? 1
(a) Addition (b) Subtraction (c) Multiplication (d) All of these
ii $A$6 is an example of 1
(a) Relative referencing (b) Absolute referencing
(c) Mixed referencing (d) None of these
iii If we move a cell containing a formula having reference to another cell in the 1
worksheet what will happen to the cell numbers used in the formula?
(a) The cell row and columns are changed at the destination.
(b) The cell row change at the destination.
(c) The cell columns are changed at the destination.
(d) No change will scour.
iv A function should start with 1
(a) '=' sign (b) alphabets (c) numbers (d) All of these
v How many axes do charts in Calc have? 1
(a) Two (b) Three (c) Two or three (d) Four
II Answer the given 5 questions (1 x 5= 5 Marks)
i. A cell range starting from the first row, the first column to the fourth row and fifth 1
column can be represented as
(a) [A1 : E4] (b) [A0: E3] (c) [E4: A1] (d) [E3: A0]
ii. A cell range always has the _______ symbol between the cell references. 1
(a) ; (semicolon) (b) . (full stop) (c) , (comma) (d) : (colon)
iii. Identify the mode, where we can modify in the structure of table? 1
a. Datasheet view b. Structure view c. Design view d. All of the above
iv. _________ Clause can be used with the SELECT statement in SQL to specify which 1
rows to retrieve from the table.
(a) WHERE (b) GROUP (c) SAME (d) SIMILAR
v. __________ Store data in a single table which is suitable to store less amount of Data. 1
a. Flat File b. Relational c. Mini File d. Single File
1
III Answer the given 5 questions (1 x 5= 5 Marks)
i. Based on the given table answer the following questions: 2
i) Write the formula to calculate the sum of cell B1
to B5 and display the result in cell B7.
ii) Write the formula to calculate the average of cell
B1 to B5 and display the result in cell B8.
iii) Write the formula to find the largest no. from
cell B1 to B5 and display the result in cell B9.
iv) Write the formula to find the smallest no. from
cell B1 to B5 and display the result in cell B10.
v) Write the formula to count the no. of elements in cell B1 to B5 and display the result
in cell B11.
IV Answer any 3 out of the given 4 questions (3 x 2= 6 Marks)
i. Give one difference between MAX () and MIN (). 2
ii. What is the difference between spreadsheet and worksheet? 2
iii. What is an active cell? How to delete the contents of an active cell? 2
iv. Explain the advantages of drawing a chart in Calc. 2
V Answer any 3 out of the given 4 questions (3 x 3= 9 Marks)
i. Name and example of any three statistical functions in spreadsheet. 3
ii. Explain in one line each the various types of charts 3
iii. Name and example of any three mathematical functions in spreadsheet. 3
iv. Name the types of cell references. Explain them. 3
