1. | Which of Excel’s ribbon tabs is shown in the figure below? |
A. |
B. |
C. |
D. |
2. | Which function converts miles to kilometers, kilograms to pounds, and so on? |
A. |
B. |
C. |
D. |
3. | You can press ___________ to move between open Workbook |
A. |
B. |
C. |
D. |
4. | Which formula can add the all numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell? |
A. |
B. |
C. |
5. | In an IF Function the required arguments are ____________ |
A. |
B. |
C. |
D. |
6. | Which of the following functions is correctly written? |
A. |
B. |
C. |
D. |
7. | Two common wildcard characters that Excel recognizes are |
A. |
B. |
C. |
D. |
8. | To select several cells or ranges that are not touching each other, you would _____ while selecting |
A. |
B. |
C. |
9. | The name of the active cell appeares in the -----------------------. |
A. |
B. |
C. |
10. | Reference to the above image of Command Group "Alignment" which of the following tabs consist it: |
A. |
B. |
C. |
11. | Except for the ______________ function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result |
A. |
B. |
C. |
D. |
12. | What feature enables you to adjust or solve the value in a cell to reach a desired outcome/result? |
A. |
B. |
C. |
D. |
13. | _____________ is the horizontal part of the spreadsheet. |
A. |
B. |
C. |
14. | What term describes explanatory text attached to a cell |
A. |
B. |
C. |
D. |
15. | The function arguments dialog box tells you how to use functions. |
A. |
B. |
16. | Which function does not exist in Excel's function library? |
A. |
B. |
C. |
D. |
17. | Once you hide a row, it remains hidden as long as the workbook is active. |
A. |
B. |
18. | =FUNCTION(argument1,argument2, ...) Is ________. |
A. |
B. |
C. |
D. |
19. | Which of the following is the correct syntax for the COUNTIF function? |
A. |
B. |
C. |
D. |
E. |
20. | In the following formula: =IF(A1="YES","DONE","RESTART"), what happens if A1="NO"? |
A. |
B. |
C. |
D. |
21. | How would you print formulas? |
A. |
B. |
C. |
22. | After Excel displays an existing entry in the column that matches the characters you type, press the ______ key to accept the entry. |
A. |
B. |
C. |
D. |
23. | The divide symbol is |
A. |
B. |
C. |
D. |
24. | Pie charts are most effective with ___________ or fewer slices. |
A. |
B. |
C. |
25. | An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons. |
A. |
B. |
26. | Which number formatting style adds the dollar signs and commas to values? |
A. |
B. |
C. |
D. |
27. | A Function is? |
A. |
B. |
C. |
28. | Which Excel 2007 feature can be used to keep user desired rows or columns visible at all times when scrolling around the sheet? |
A. |
B. |
C. |
D. |
29. | The "Go To" dialogue appears when you press the _____________ key from keyboard. |
A. |
B. |
C. |
30. | Which of the following keys/key can be used to check spelling and grammar? |
A. |
B. |
C. |
D. |