1. | Once you hide a row, it remains hidden as long as the workbook is active. |
A. |
B. |
2. | When a worksheet is printed, the grid lines that surround the cells are printed by default. |
A. |
B. |
3. | A(n) ________ function is conditional. |
4. | You can rotate cell contents in Excel so that they appear at any angle or orientation. |
A. |
B. |
5. | After you merge a range into a single cell, you can't realign its content. |
A. |
B. |
6. | In "SUM(number1 [,number2 ,number3 ...])" number 1, number 2, and number 3 may be numbers or __________. |
A. |
B. |
C. |
D. |
7. | Formatting changes only the appearance of data- it does not affect the data itself. |
A. |
B. |
8. | To enter a mixed reference, type $ after either the row or column reference. |
A. |
B. |
9. | All functions have arguments. |
A. |
B. |
10. | If a formula contains several functions, Excel starts with the outermost function and then moves inward. |
A. |
B. |
11. | As you begin to type a function name within a formula into a cell, a list of functions that begin with the letters you typed appears. |
A. |
B. |
12. | FUNCTION(argument1,argument2, ...) is ________. |
A. |
B. |
C. |
D. |
13. | In the following formula: =IF(A1="YES","DONE","RESTART"), what happens if A1="NO"? |
A. |
B. |
C. |
D. |
14. | The ____ button is equivalent to using the sum button. |
A. |
B. |
C. |
D. |
15. | The numbers, text, or cell references used by the function to return a value are |
A. |
B. |
C. |
D. |
16. | In "SUM(number1 [,number2 ,number3 ...])", number 2 and number 3 are ________ |
17. | What uses vertical rectangles to compare values across categories. |
18. | Excel has a built in format to display 4 digit year values, so you do not need to create on. |
A. |
B. |
19. | What displays values in different categories; column chart on its side. |
20. | What is a range of values that is plotted as a single unit on the chart. |
21. | This compares relative values of different categories to the whole; similar to the pie chart except that it can display multiple sets of data. |
22. | This compares a collection of values from several different data sets. |
23. | Pie charts are most effective with ___________ or fewer slices. |
24. | This is a collection of one or more data series. |
25. | This compares three sets of values in a 3D chart. |
26. | This compares value from different categories; often used to show trends and changes over time. |
27. | A "mixed reference" locks one part of the cell reference while the other part can change. |
A. |
B. |
28. | One challenge of nesting functions is to make sure that you include all of the parentheses. |
A. |
B. |
29. | In excel, charts do not remain linked or connected to their data sources if they appear in different worksheets. |
A. |
B. |
30. | You can rotate a 3D chart in only two directions: horizontally along the x-axis and vertically along the y-axis. |
A. |
B. |
31. | Although 3D Charts are visually attractive, they can obscure the relationship between the values in the chart by making it difficult to see which slice is larger. |
A. |
B. |
32. | In pie charts with legends, it's best to make the slice colors as similar as possible. |
A. |
B. |