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
Care must be taken when adding or removing chart elements,since the position of other elements may change.
(True/False)
4.8/5
(70)
You can remove a chart element by selecting it and then pressing Delete.
(True/False)
4.8/5
(80)
To place an object such as a rectangle or circle into a chart,you click ________ in the Illustrations group on the INSERT tab.
(Multiple Choice)
4.7/5
(78)
The graphic components that are overlaid onto data in worksheet cells are called ________.
(Short Answer)
4.8/5
(86)
If a change is made to a worksheet,you have to make the corresponding change to the connected chart.
(True/False)
4.9/5
(82)
________ gridlines are the lines between designated label values.
(Short Answer)
4.8/5
(78)
________ is the graphical presentation of data focusing on qualitative understanding.
(Short Answer)
5.0/5
(90)
To change the style of a chart,you would click the ________ conceptual tab.
(Short Answer)
4.7/5
(67)
A scatter chart is a variation of a stacked line chart emphasizing the amount of change over time.
(True/False)
4.7/5
(85)
A(n)________ chart displays two different types of data using multiple chart types in a single chart.
(Short Answer)
4.8/5
(84)
Actions performed in the Chart Formatting Control can be performed through the Chart Tools contextual tab on the Ribbon.
(True/False)
4.8/5
(95)
Chart layouts focus on location of components,whereas styles focus more on the color coordination and effects of the components.
(True/False)
4.9/5
(79)
Clicking
allows single-click access to formatting,formulas,and sparklines.
(True/False)
4.9/5
(72)
A(n)________ is a line that uses current data to display the progress or general direction of the data.
(Multiple Choice)
4.9/5
(78)
If you wanted to compare the percentages of students in a class that received A's,that received B's,that received C's,and so on,you would use a ________ chart.
(Multiple Choice)
4.8/5
(84)
In the worksheet above,the red arrow is pointing at a ________.
(Multiple Choice)
4.9/5
(87)
PNG,JPEG,and GIF are examples of file extensions used for ________ files.
(Multiple Choice)
4.9/5
(77)
Showing 81 - 98 of 98
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)