1. | Which of Excel’s ribbon tabs is shown in the figure below? |
A. |
B. |
C. |
D. |
2. | Using the autosum button will place in the selected cell _____. |
A. |
B. |
C. |
D. |
3. | To add two cells (A1 and A2) together you use the following formula |
A. |
B. |
C. |
D. |
4. | What key should be used to edit the content of a cell? |
A. |
B. |
C. |
5. | What does SUMIFS function do? |
A. |
B. |
C. |
D. |
6. | A function inside another function is called a _____________ function. |
A. |
B. |
C. |
D. |
7. | Which is not an advantage of using computerized spreadsheets? |
A. |
B. |
C. |
D. |
8. | When using a databar, changing the value of one cell in the range will not affect the barsize of all the other cells. |
A. |
B. |
9. | What is the short key to enter the current date in a cell? |
A. |
B. |
C. |
D. |
10. | __________________ is the vertical part of the spreadsheet. |
A. |
B. |
C. |
11. | The name of the active cell appeares in the -----------------------. |
A. |
B. |
C. |
12. | Although 3D Charts are visually attractive, they can obscure the relationship between the values in the chart by making it difficult to see when slice is larger. |
A. |
B. |
13. | One person in the office is working on Excel 97, another in Excel 2000 and you are working in Excel 2007. How would you save it in order for other users can open and edit the file? |
A. |
B. |
C. |
D. |
14. | You can create maximum one Excel table in a worksheet |
A. |
B. |
15. | Which of the Excel 2007 ribbon tab allow you to check spelling, add a comment, or protect your workbook? |
A. |
B. |
C. |
D. |
16. | In Excel, charts do not remain linked or connected to the data sources if they appear in different worksheets. |
A. |
B. |
17. | Rows are identified by a _______________________ |
A. |
B. |
C. |
18. | You can modify an exisiting chart? |
A. |
B. |
19. | You can select the current Row by pressing |
A. |
B. |
C. |
D. |
20. | The ___________ allows you to use Excel to change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values. |
A. |
B. |
21. | What would be the effect of the formula shown below in an Excel spreadsheet assuming cells A1 & A2 contain numbers? =A1^A2 |
A. |
B. |
C. |
D. |
22. | Which of the following keys/key can be used to check spelling and grammar? |
A. |
B. |
C. |
D. |
23. | If you have data that runs across five columns, from column A to column E, one way to center a title across the top of the data would be to: |
A. |
B. |
C. |
D. |
24. | You can use the drag and drop method to |
A. |
B. |
C. |
D. |
25. | Which of the following formulas would find the sum of the cells in column J between rows 1 and 8 in an Excel spreadsheet? |
A. |
B. |
C. |
D. |
26. | The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is _____. |
A. |
B. |
C. |
D. |
27. | In the following formula: =IF(A1="YES","DONE","RESTART"), what happens if A1="NO"? |
A. |
B. |
C. |
D. |
28. | The _________________ displays the name of the sheets in the workbook. |
A. |
B. |
C. |
29. | The "Go To" dialogue appears when you press the _____________ key from keyboard. |
A. |
B. |
C. |
30. | Pressing ENTER moves the selection one cell to the right by default. |
A. |
B. |