Exam 4: Effective Charts
Exam 2: Formatting, functions, and Formulas100 Questions
Exam 3: Cell References, named Ranges, and Functions102 Questions
Exam 4: Effective Charts98 Questions
Exam 5: Complex Conditional and Retrieval Functions100 Questions
Exam 6: Analyze Data Using Tables100 Questions
Exam 7: Multiple Worksheets workbooks and Templates100 Questions
Exam 8: Refine an Excel Application100 Questions
Exam 9: Organize, import, export, and Cleanse Data Sets100 Questions
Exam 10: Data Tables, scenario Manager, and Solver101 Questions
Exam 11: Loan Amortization, investment Analysis, and Asset Depreciation100 Questions
Exam 12: Business Statistics and Regression Analysis103 Questions
Exam 13: Excels Data Model, Power-pivot, and Power View96 Questions
Exam 14: Visual Basic for Applications99 Questions
Exam 15: Appendix:efficient Interaction With a Touch Screen67 Questions
Exam 16: The Common Features of Microsoft Office81 Questions
Select questions type
The Recommend Charts feature is located on the INSERT tab on the Ribbon.
(True/False)
4.9/5
(80)
To view additional information or modify labels,you would click the ________ conceptual tab.
(Multiple Choice)
4.8/5
(85)
If you wanted to see if there is relationship between the miles per hour over the speed limit recorded on a ticket and the amount of the resulting fine,you would use a(n)________ chart.
(Short Answer)
4.9/5
(83)
You can add chart and axes titles on the Chart Tools Format tab or with the Chart Elements button.
(True/False)
4.9/5
(77)
To display the Move Chart dialog box,you click Move Chart in the ________.
(Multiple Choice)
4.9/5
(73)
To examine the relationship between two numeric variables,you would use a scatter chart.
(True/False)
4.9/5
(82)
A(n)________ chart is displayed vertically and is useful for comparing categorized data sets.
(Short Answer)
4.8/5
(71)
A common enhancement for a line chart is the addition of color,weight,and marker size.
(True/False)
4.7/5
(86)
________ gridlines are displayed at each of the designated label values.
(Short Answer)
4.8/5
(75)
The related data values used in creating a chart are called ________.
(Multiple Choice)
4.8/5
(76)
A(n)________ chart highlights regions showing growth over time or for categories and is a variation of a line chart.
(Short Answer)
4.9/5
(72)
After inserting a shape into a graph,you can enter text in the shape.
(True/False)
4.9/5
(77)
Which of the following is NOT one of the CHART TOOLS contextual tabs?
(Multiple Choice)
4.9/5
(74)
To activate the Chart Tools contextual tab,you double-click the chart border.
(True/False)
4.8/5
(80)
When creating a chart from data in a worksheet,the data series is surrounded by a(n)________ border.
(Short Answer)
4.8/5
(80)
A scatter chart is displayed vertically and is useful for comparing categorized data sets.
(True/False)
4.7/5
(70)
A(n)________ chart stacks a series of colored layers and can be used to see trends over a period of time.
(Short Answer)
4.8/5
(75)
Showing 61 - 80 of 98
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)