Excel Standard 7 Review

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

• Check the chart's data source for layout names.

• Look for layout names in the chart's legend.

• By viewing the workbook properties

• By hovering over a selection in the gallery

Which of the following statements is true about predefined chart layouts?

• 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.

In which of the following ways can you modify elements of a chart in a spreadsheet application?

Select all that apply

• The Format task pane

• The Page Layout tab on the Ribbon

• The Chart Tools Ribbon

• The Data tab on the Ribbon

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

• Data labels

• Chart title

• Axes

• Trendline

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?

• Axes

• Data table

• Data label

• Legend

What does the Switch Row/Column button do?

• Toggle Axis Titles off and on

• Change the orientation of axes in a chart.

• Rearrange data in a range of cells.

• Paste row data into a column.

The Select Data Source dialog box allows you to do which of the following?

• 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.

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

• To make the data less accessible.

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

• To increase the complexity of the chart.

• To follow a random pattern without reason.

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

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

• You want to add the chart to a PowerPoint presentation or Microsoft Word document.

• You want to move the chart to another worksheet.

• You want to switch the rows and columns in the chart.

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?

• Data tables

• Data labels

• Data chart

• Data series