Page 327 - TP_IT_V1.0_C9_flipbpookl
P. 327
3. Which of the following is used to insert functions through interactive step-by-step processes?
a. Function Wizard b. Formula bar
c. Name box d. Function button
4. The absolute referencing is used to.
a. Fix the address of a row b. Fix the address of a column
c. Fix the address of both row and column d. None of these
5. The symbol is used for representing the absolute referencing.
a. & b. $
c. # d. @
6. Which of the following is not available on the Formatting toolbar?
a. Bold b. Font Name
c. Font Color d. Print
7. The formatting of a cell can be changed by using dialog box.
a. Format Pages b. Format Cells
c. Format Sheets d. Format Files
8. What will be the output of =6*4-(11-3)/2^3?
a. 26 b. 35
c. 15 d. 23
9. Which of the following types of package does Calc refer to?
a. Spreadsheet b. Double sheet
c. Multi-sheet d. Cannot determine
10. Which of the following is an extension of a spreadsheet created in Calc?
a. .ods b. .odd
c. .xls d. .obj
11. If we move a cell containing a formula having reference to another cell in the sheet what will happen to the cell numbers
used in the formula?
a. The cell references will update to reflect the new location.
b. Only the row references will update to reflect the new location.
c. Only the column references will update to reflect the new location.
d. The cell references will not change.
12. A function should start with .
a. ‘=’ sign b. letter
c. number d. All of the these
13. Which of the following options is used to print a chart?
a. Insert → Char b. File → View
c. File → Print d. View → Chart
14. How many axes do charts in Calc typically have?
a. Two b. Three
c. Two or three d. Four
Ans. 1. b 2. d 3. a 4. c 5. b 6. d 7. b 8. d 9. a 10. a 11. a 12. a 13. c 14. a
B. Fill in the blanks.
1. A group of continuous cells selected with a mouse or a keyboard is known as a .
2. consists of tools used for the formatting of the spreadsheet, such as change of text colour, size, style etc.
3. represent the data in a pictorial form which is easy to read and understand.
4. / and ^ are examples of operators.
5. is the default chart type in the spreadsheet.
Electronic Spreadsheet 325

