1. | What function offers you the possibility to view different results depending on the entered condition? |
A. |
B. |
C. |
2. | When a worksheet is printed, the grid lines that surround the cells are printable by default. |
A. |
B. |
3. | You can rotate a 3D chart in only two directions: horizontally along the x-axis and vertically along the y-axis. |
A. |
B. |
4. | Pressing ENTER moves the selection one cell to the right by default. |
A. |
B. |
5. | In an IF Function the required arguments are ____________ |
A. |
B. |
C. |
D. |
6. | 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. |
7. | 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. |
8. | When creating an Excel workbook, you should avoid using ______ text and background together, since this is the most common form of color blindness. |
A. |
B. |
C. |
D. |
9. | Graphics objects on a chart are used to |
A. |
B. |
C. |
D. |
10. | __________________ is the vertical part of the spreadsheet. |
A. |
B. |
C. |
11. | 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. |
12. | A Function is? |
A. |
B. |
C. |
13. | After writing the formula you have to press _____________________ key from the keyboard to see the answer. |
A. |
B. |
C. |
D. |
14. | What is a Chart? |
A. |
B. |
C. |
15. | Ctrl+B key makes the shortcut for making font in selected cell bold. |
A. |
B. |
16. | Which number formatting style adds the dollar signs and commas to values? |
A. |
B. |
C. |
D. |
17. | 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. |
18. | The cell labeled F5 refers to |
A. |
B. |
C. |
D. |
19. | You can press ___________ to move between open Workbook |
A. |
B. |
C. |
D. |
20. | If you press _____, the cell accepts your typing as its contents but the focus stays in the same cell. |
A. |
B. |
C. |
D. |
21. | You can create maximum one Excel table in a worksheet |
A. |
B. |
22. | You can use the drag and drop method to |
A. |
B. |
C. |
D. |
23. | If you insert a new row at the top of the table, the new row becomes the header row and is formatted with the table style. |
A. |
B. |
24. | You can have results of any database table into Excel Worksheet, and by one click you can refresh the results? |
A. |
B. |
25. | What feature enables you to adjust or solve the value in a cell to reach a desired outcome/result? |
A. |
B. |
C. |
D. |
26. | 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. |
27. | What does the LEN() function do? |
A. |
B. |
C. |
D. |
28. | What is a Workbook? |
A. |
B. |
C. |
29. | The simplest and most convenient way to add a record to a table is to enter the data in the first blank row. |
A. |
B. |
30. | When a formula is written in a cell. It appears in the the active cell in which it is being written and in the __________________ bar as well. |
A. |
B. |
C. |