Excel Standard 7 Review

Front

How can you find the name of a predefined chart layout?

Back

By hovering over a selection in the gallery

Front

Which of the following statements is true about predefined chart layouts?
Options:
They arrange the position of chart elements.
They can only be applied to column charts.
They must be created by the user.
They can only be applied to a chart once.

Back

They can only be applied to a chart once.

Front

In a chart, which element is responsible for displaying specific details about a data series or individual data points?

Back

Data labels

Front

In the context of data visualization, what is the term for the grid located at the bottom of a chart that shows the numerical values represented in the chart?

Back

Data table

Front

What does the Switch Row/Column button do?

Back

Change the orientation of axes in a chart.

Front

The Select Data Source dialog box allows you to do which of the following?
Options:
Delete data from a selection.
Select an entirely new range of data.
Select what color is used for each data series on the chart.
Change to a new type of chart.

Back

Select an entirely new range of data.

Front

What are some valid reasons for switching the rows and columns in a chart?

Back

To correct a pie chart that is only displaying a category name.

Front

After creating a chart, you added more data to the worksheet. Why is it important to update the chart with this new data?

Back

You added data to the worksheet after the chart was created.

Front

In the context of spreadsheet software, what term is used to describe a row or column of data that is represented visually in a chart?

Back

Data series

Front

In Excel, what is the primary purpose of using comments within a cell?

Back

To provide additional information or context about a cell's content.