1. Which of the following is the advantage of using a spreadsheet?
1) Calculations can be done automatically
2) Changing data automatically updates calculations
3) More flexibility
4) All of the above
2. Which of the following shortcut keys is used to check spelling?
1) F1
2) F2
3) F7
4) F9
3. 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
4. To move to the previous worksheet, we press.
1) Alt + Pg UP
2) Ctrl + Pg UP
3) Ctrl + Pg Dn
4) Shift + Tab
5. An Excel Workbook is a collection of ________
1) Workbooks
2) Worksheets
3) Charts
4) Worksheets and charts
6. If you press ______, the cell accepts your typing as its contents.
1) Enter
2) Ctrl + Enter
3) Tab
4) Insert
7. Which of the following displays the buttons for changing text style, alignment and size?
1) Standard tool bar
2) Status bar
3) Drawing tool bar
4) Formatting tool bar
8. All formulas in Excel start with _______
1) %
2) +
3) =
4) _
9. To add two cells (A1 and A2) together you use which of the following formula?
1) = A1+A2
2) = Add (A1+A2)
3) = together (A1:A2)
4) A1 plus A2
10. Find the correct set three types of data found in a spreadsheet.
1) Data, Words, Numbers
2) Equations, Data, Numbers
3) Words, Numbers, Labels
4) Numbers, formulas, Labels
ANSWERS
[dropshadowbox align="none" effect="lifted-both" width="500px" height="" background_color="#ffffff" border_width="1" border_color="#dddddd" ]1.(4) 2.(3) 3.(1) 4.(4) 5.(4) 6.(1) 7.(4) 8.(3) 9.(1) 10.(4)[/dropshadowbox]
Posts
Comment Policy : We invite you to comment on our posts, as long as they are respectful, to the point and approving. We do not perform pre-moderation of comments. However, in order to keep this site clean and useful, we reserve the right to remove any comment that is not in accordance with our Comment Policy.