Page 233 - CA 165 ver 1.0 Class 9
P. 233
i. In cells F4, what is the formula needed to calculate the cost of dinner plates? [1]
a. =ROUND(D4;E4) b. =MOD(D4:E4)
c. =PRODUCT(D4;E4) d. =POWER(DR;E5)
ii. In cell F11, what is the formula that computes the total amount? [1]
a. =SUM(F4;F10) b. =SUM(F4:F10)
c. =COUNT(F4:F10) d. =SUM(D4=D10)
iii. What is the formula to find out the item that costs the minimum out of all the items [1]
mentioned?
a. =MIN(D4:D10) b. =MIN(E4:E10)
c. =MIN(D4;D10) d. =MIN(F4:F10)
iv. What is the formula to find out the most costly item in the list? [1]
a. =MAX(D4:D10) b. =MAX(D4;D10)
c. =MAX(F4:F10) d. =MAX(F4;F10)
v. What is the data type for the field ‘Items purchased’? [1]
a. Numeric b. Alphanumeric
c. Date/Time d. Formula
vi. Which of the following commands is used to merge two or more cells? [1]
a. Format Merge Cells b. Tools Merge Cells
c. Edit Merge Cells d. None of these
vii. Which of the following features is used to fill the numbers in the S. No. column
automatically? [1]
a. Series b. AutoFill
c. Fill d. All of these
PART–B
All questions are compulsory. In case of internal choices, attempt any one.
16. What is Cell Referencing? Discuss its different types giving suitable examples. [2]
17. Akashdeep has made a presentation for his new project. The content is ready but he does not have
enough time to design the slides for presentation. Name the feature which will help him to create a
professional presentation without devoting much time. [2]
18. What is a presentation? What are the various ways in which we can add multimedia features in a
presentation? [2]
19. What formula should be contained in the cell C2 to calculate Temp in Fahrenheit?
Sample Question Paper 231

