MASTERING EXCEL CHARTS - FINAL EXAM
Which tool do you use to change the overall appearance of a chart with one click?
Chart Styles
Filters
Select Data
Shape Effects
A company has a LINE CHART with a level TRENDLINE over a six month period. Identify what this chart should visually convey to the company.
Doesn't convey much
It's a good sign - everything is normal. Keep doing the same actions
Time to hire more staff
It's a bad sign - the company is probably losing money so find out how to make it go steadily up
Which chart could you use to show a visual of a running total?
Clustered column chart
Waterfall chart
Pie of Pie chart
Bar chart
Which tool lets you modify what data is shown in the chart?
Filters
AutoSum Formula
Switch Row/Column
Shape Styles
Which of the following can customize/modify a COLUMN, BAR, LINE, and PIE chart.
CHART STYLE options in the DESIGN tab
QUICK LAYOUT options in the DESIGN tab
The CHART ELEMENTS button in the DESIGN tab
All of the above
When using Recommended Charts, what action should you take if none of the charts represent your data well?
Exit out of Excel
Click on the ALL CHARTS tab to find a workable chart
Use one of the Recommended Charts anyway
Go to the Format Tab
When composing custom chart styles, how does one save a template?
Control + Click on the chart
Design tab; Change Chart Type; Templates
Right-click on the chart; Save as Template
Control + T
How do you use ERROR BARS in a chart?
To graphically see how much a statistic deviates from the normal
To spot mistakes
To show label info
To show progress
When copying a chart to Word, PowerPoint, or Outlook, identify the correct steps to make the chart update dynamically.
Right-click in Word, PowerPoint or Outlook and choose the PASTE options that include links
Right-click in Word, PowerPoint or Outlook and choose the PASTE Photo of Chart option
Click FORMAT PAINTER, click on the chart, then select a field in the OFFICE application
You cannot dynamically link charts
Identify a CHART ELEMENT from the options below.
Gridlines
Error Bars
Axes
Up-Down Bars
All of the Above
When composing a chart, how do you link a CHART TITLE to the raw data?
You cannot link a chart title to raw data
Highlight the chart title in the data, CONTROL CLICK the CHART TITLE
Select the CHART TITLE, type an EQUALS SIGN (=) in the FUN
Select the CHART TITLE, type a PLUS SIGN (+) in the FUN
Which chart element helps you analyze your data and show where things are going?
Trendlines
Gridlines
Error Bars
Data Table
Identify the chart that has a similar fun
Bubble Chart
Sunburst Chart
Waterfall Chart
Pareto Chart
GANTT charts are very useful but are not included as a standard Excel chart. When constructing a GANTT chart, what chart type do you start with and modify?
Line chart
Waterfall chart
100% Stacked Column chart
Stacked-Bar chart
Identify the type of chart that is a mini-chart, placed within one cell.
Sparkline
Waterfall
Sunburst
Histogram
When using the 11 different chart elements, what modifications are available in the FORMAT PANE?
FILL and BORDER options
SHADOW, GLOW, and other effects
ALIGNMENT options
All of the above
Which charts would you recommend if someone needed to show a breakout of data and frequency of distribution?
Pie of Pie and Bar of Pie charts
Histogram and Pareto charts
XY and Bubble charts
Pie and Doughnut charts
Identify the sub-chart type that compares the percentage that each value contributes to the total.
100% Stacked Chart
3D Stacked Chart
Stacked Chart
All of the above
When printing a chart for a presentation, what would you recommend doing if a portion of the chart was cut off in the print preview?
Close out the PRINT PREVIEW, press Control P and try again
Make sure the chart is in landscape orientation, and change the SCALING option to FIT SHEET ON ONE PAGE
Print the chart on two sheets of paper, cut and glue pieces together
Select PRINT ENTIRE WORKBOOK from the the printer settings
Identify the correct way to change/modify data sources in a chart.
Select the chart, INSERT tab, LINK
Right-click on the chart, ASSIGN MACROS
Select the chart, click the DESIGN tab, then SELECT DATA SOURCE, and modify what to show or not show in the chart
Select the chart, FORMAT tab, FORMAT SELECTION
{"name":"MASTERING EXCEL CHARTS - FINAL EXAM", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Basics of Tax Course, What is your full name?, What color is an orange?","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}