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

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 FUNCTION BAR, click on the title in the data, and press ENTER

Select the CHART TITLE, type a PLUS SIGN (+) in the FUNCTION BAR, click on the title in the data, and press ENTER

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 function to a TREEMAP chart and is ideal for displaying hierarchical data.

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

MASTERING EXCEL CHARTS - FINAL EXAM

More Quizzes