1. | On a line chart, the x-axis is known as the |
2. | You would ____ a table if you wanted to display only data that matched specific criteria. |
3. | You can select an element of a chart to format by using the chart’s element box. |
A. |
B. |
4. | Changing a value in a cell to see what effect it has on values in other cells that are calculated using the value is said to be doing |
5. | An excel formula begins with which symbol? |
6. | A pie chart should be limited to no more than seven categories |
A. |
B. |
7. | Anything a user types into a cell is known as a |
8. | When the user changes a value in a cell, Excel automatically recalculates. |
A. |
B. |
9. | .A menu that is context sensitive displays options related to the current task. |
A. |
B. |
10. | On a line chart, the y-axis is known as |
11. | The values that an Excel function uses to perform operations are called |
12. | A predefined formula is called a |
13. | If a value is changed in in a cell, Excel recalculates all formulas that reference that cell. |
A. |
B. |
14. | Excel does not have a spell checker |
A. |
B. |
15. | Number values are often called labels |
A. |
B. |
16. | A ______is formatted as a pattern of uniformly spaced horizontal rows and vertical columns |
17. | The small black square in the lower right corner of a selected cell is called a |
18. | If you want to chart trends over time use a |
19. | The spacing between the tick marks is determined by the |
20. | The Excel operator for greater than or equal to is said to be |
21. | A gallery of text styles that can be used to apply decorative effects to text is called a |
22. | Goal Seek is an example of a |
23. | An image that appears to have length, depth and width is said to be |
24. | Each pie slice displayed on a pie chart is an example of a |
25. | Values are compared using a ___ operator |
26. | An Excel worksheet is made up of one or more workbooks. |
A. |
B. |
27. | The____allows the user to enter or edit he value or formula contained in the active cell. |
28. | Excel’s ____ function retreats the date and time from the computer’s calendar and clock. |
29. | An excel document is called a |
30. | To ___ a table means to arrange all of the data in a specific order. |
31. | Cell contents are either values or formulas |
A. |
B. |
32. | Two or more cells that Excel treats as a single unit is called a |
33. | A ___ _______ shows the relationship of each part of the data to the whole. |
34. | The ___ function adds all of the numbers in a range of cells |
35. | By including worksheets in a _____ you can enter or edit data on them simultaneously. |
36. | The ____is outlined in black and is ready to accept data. |
37. | The _____ function counts the number of cells within a range that meets a certain criteria. |
38. | Arithmetic operators are used to perform basic mathematical operations in Excel. |
A. |
B. |