Page 305 - Trackpad IT-402_Class-IX
P. 305
Exercise
Solved
SECTION A (Objective Type Questions)
A. Choose the correct option.
1. Which of the following technique can be used to allow only date value in cell? [NCERT]
a. Data formatting b. Data sorting
c. Data filtering d. Data validation
2. An intersection of a row and column is called a .
a. Worksheet b. Cell
c. Spreadsheet d. Cell range
3. in a spreadsheet is used for entering and editing a formula.
a. Status bar b. Menu bar
c. Standard toolbar d. Formula bar
4. What is the name of mechanism to arrange the data in a particular order? [NCERT]
a. Sorting b. Searching
c. Filtering d. Validating
5. is used to insert functions through an interactive step-by-step process.
a. Function Wizard b. Formula bar
c. Name box d. Function button
6. Absolute referencing is used to .
a. Fix the address of row b. Fix the address of a column
c. Fix the address of both row and column d. All of these
7. The symbol used for absolute referencing is .
a. & b. $
c. # d. @
8. Whenever a formula is copied to some other cell, .
a. the cell address in a formula changes with respect to the location.
b. the cell address in a formula remains the same.
c. the answer of the cell remains the same.
d. the formula cannot be copied.
9. Which of the following tool is available on the Standard toolbar?
a. Bold b. Font name
b. Cell alignment d. Print
10. The formatting of a cell can be changed by using .
a. Format Page b. Format Cell
c. Format sheet d. Format file
11. A continuous selection of cells is known as .
a. Cell address b. Cell Range
c. Cell d. Cell reference
12. What shall be the output of =6*4-(11-3)/2^3?
a. 26 b. 35
c. 15 d. 23
Electronic Spreadsheet 305

