Excel Quiz 5

Charts can be found by clicking the _____ tab on the ribbon.

• Automate

• Data

• Inquire

• Insert

While a chart is selected, click the _____ button on the Design contextual tab and then select _____ to place it on its own worksheet.

• Change Chart Type; All Charts

• Change Chart Type; Existing Sheet

• Move Chart; New Sheet

• Move Chart; Object In

To change the data ranges that a chart refers to, click the _____ button on the ribbon.

• Change Chart Type

• Quick Layout

• Select Data

• Switch Row/Column

The Switch Row/Column button works only on charts with multiple _____.

• cells

• columns

• series

• rows

Pie charts have three types of chart elements:  the chart title, a _____, and _____.

• color; numbers

• legend; data labels

• symbol; words

• row; columns

When exported, charts are most often interpreted as images.  Therefore, it is important to assign _____ to charts to accommodate screen readers.

• alphabets

• alternative text

• Arabic numbers

• symbols

To add alternative text to a chart, _____ the chart and then click _____.

• left-click; Chart Elements

• left-click; Chart Styles

• right-click; Assign Macro

• right-click; View Alt Text