1. To add an outline border in Excel, use the shortcut:
2. The shortcut key to perform an AutoSum in Excel is:
3. CTRL + D shortcut key in Excel will:
4. CTRL + R shortcut key in Excel will:
5. Which fill series type in Excel is used for sequential numbers?
6. In the Fill Series dialog box, which is a valid date unit?
7. The command "Edit Fill Across Worksheet" is active only:
8. To remove only formatting done in a range, you must:
9. To arrange data so that it is easier to analyze, use:
10. To arrange data in ascending and descending order, use:
11. Which tool is used to extract a subset of data?
12. To arrange and summarize complicated data, use:
13. In the Pivot Table Field List, which area calculates the aggregates of columns?
14. The keystroke to select the entire pivot table record is:
15. The option to make it easy to sort, filter, or format data within a sheet is:
16. In Table Style formats, which option alternates columns in different colors?
17. In Table Style formats, which option alternates rows in different colors?
18. A reason to choose a chart or graph is:
19. The shortcut key to insert a chart sheet is:
20. The shortcut key used to create a default chart is:
21. To insert a new chart, use the shortcut:
22. F11 creates a:
23. A chart that displays only the chart and not the worksheet cells is called a:
24. A chart can be displayed inside:
25. The box that appears on the right side of the chart by default is the:
26. The item that contains the name of its individual record inside a chart is the:
27. To compare relative values from different categories to the whole, use a:
28. A chart that shows nominal data series, such as country or gender, is a:
29. A chart that is best if there is only one series of data is a:
30. To move one slice of a pie chart away from the pie, creating an exploded effect, use a:
31. A rectangular area that labels the marked or symbol used in a chart is called the:
32. Categories are typically organized along the horizontal axis and values along the vertical axis in:
33. The chart that is useful for showing data changes over a period of time is a:
34. The chart used for magnitude comparison of values (determines whether the object is larger or smaller) is a:
35. The number of steps to complete the Chart Wizard is:
36. To track the progress of the stock market on a daily basis, which type of chart would you use?
37. To show the temperature variations of each hour, use a:
38. A graphic object used in a chart to emphasize the data is called a:
39. Related data points that are plotted in a chart are called a: