1. ___ is the keyboard shortcut for opening the Excel Formula Window.
(1) Shift + F3 (2) Shift + F1
(3) Ctrl + F3 (4) Ctrl + F1
(4) Ctrl + F1 + 1
2. Cells in Excel can be referred in ____ways.
(1) 2 (2) 3
(3) 4 (4) 5
(5) 6
3. Which of the following is the advantage of using a spreadsheet?
(1) Calculation can be done automatically
(2)Changing data automatically updates calculations
(3) More flexibility
(4) All the above
(5) None of these
4. On an excel sheet the active cell is indicated by:
(1) a dark wide border (2) a dotted border
(3) a blinking border (4) All the above
(5) None of these
5. To move the previous work sheet, we press:
(1) Alt + PgUp (2) Ctrl + PgUp
(3) Ctrl + PgDn (4) Shift + Tab
(5) None of these
6. If you press ____, the cell accepts your typing as its contents.
(1) Enter (2) Ctrl + Enter
(3) Tab (4) Insert
(5) None of these
7. Which of the following displays buttons for changing text style, alignment and size?
(1) Standard tool bar (2) Status bar
(3) Drawing tool bar (4) Formulating tool bar
(5) None of these
8. All formula in Excel starts with__.
(1) % (2) +
(3) = (4) &
(5) None of these
9. To add two cells (A1 and A2) together you use which of the formula?
(1) = A1+ A2 (2) = Add (A1 + A2)
(3) = together (A1:A2) (4) A1 + A2
(5) None of these
10. Find the correct set of three types of data found on a spreadsheet.
(1) Data, words, numbers
(2) Equation, data, numbers
(3) Words, numbers, labels
(4) Number, formulas, labels
(5) None of these
Answers:
1. (1) 2. (2) 3.(4) 4. (1) 5. (2)
6. (1) 7.(4) 8. (3) 9.(1) 10. (4)
No comments:
Post a Comment