Exam 3: Charts
Exam 1: Introduction to Excel100 Questions
Exam 2: Formulas and Functions100 Questions
Exam 3: Charts100 Questions
Exam 4: Datasets and Tables100 Questions
Exam 5: Subtotals, Pivot-tables, and Pivot-charts100 Questions
Exam 6: What-If Analysis100 Questions
Exam 7: Specialized Functions100 Questions
Exam 8: Statistical Functions100 Questions
Exam 9: Multiple-Sheet Workbook Management98 Questions
Exam 10: Imports, xml, and Power Add-Ins95 Questions
Exam 11: Collaboration and Workbook Distribution96 Questions
Exam 12: Templates, styles, and Macros97 Questions
Exam 13: Office 2016 Common Features100 Questions
Select questions type
Match the following terms with their description:
Correct Answer:
Premises:
Responses:
(Matching)
4.9/5
(31)
If you are not sure which chart type to pick,it may be helpful to click ________ Charts in the Chart group.
(Short Answer)
4.8/5
(34)
The Chart Styles gallery displays style options for the selected chart only.
(True/False)
4.9/5
(34)
To switch to a different chart type after the chart has been created you use the Switch Chart Type tool.
(True/False)
4.8/5
(36)
What does Excel not determine about the value axis when you create a chart?
(Multiple Choice)
4.8/5
(33)
What chart type represents data as spokes going from the center to the outer edge of the chart?
(Multiple Choice)
4.8/5
(33)
A 100% stacked column chart is similar to what other chart in that it converts values to percentages?
(Multiple Choice)
4.9/5
(37)
Which chart type is best when you want to chart two unrelated data types?
(Multiple Choice)
4.9/5
(42)
To select nonadjacent ranges press and hold the ________ key while selecting the nonadjacent ranges.
(Short Answer)
4.9/5
(35)
As long as you pick the correct chart you can mix numeric value systems,such as dollars and number of units sold.
(True/False)
4.8/5
(43)
As a general rule,Pie charts should be limited to how many slices?
(Multiple Choice)
4.8/5
(35)
It is good practice to delete any blank rows or columns before creating a chart.
(True/False)
4.9/5
(36)
A chart style effects the formatting of the chart itself,but not the chart data.
(True/False)
4.9/5
(28)
In a pie chart which of the following is a good reason for using category data labels rather than the legend?
(Multiple Choice)
4.7/5
(38)
In a(n)________ column chart data appears as side by side columns.
(Short Answer)
4.9/5
(38)
If you wanted to show trends over set periods of time,you probably want to use a(n)________ chart.
(Short Answer)
4.8/5
(38)
Showing 21 - 40 of 100
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)