excel 7

Where are Totals calculations placed when added using the Quick Analysis feature? Beginning at cell A1 Adjacent to the data range On the last row visible on the screen On a new worksheet

Adjacent to the data range

What happens if multiple conditional formatting rules are applied to the same cell? All rules are applied in order, formatting the cell with every rule. None of the rules are evaluated, and the cell is left unformatted. Only the first rule is applied, and the cell is formatted accordingly. Only the last rule is applied, and the cell is formatted accordingly.

All rules are applied in order, formatting the cell with every rule.

You can disable the Quick Analysis feature from the ________________________ window.

excel option

Which chart element displays details about a data series and/or individual data points? Axes Chart Title Data Labels Data Titles Trendline

Data Labels

A _______________________________ is a row or column of numbers in a worksheet that are plotted in a chart.

Data Series

Which chart element displays a grid of the chart's underlying data? Data Label Data Table Legend Trendline

Data Table

Which of the following terms describes a grid at the bottom of a chart that displays the values represented in the chart? Axes Data Label Data Table Legend

Data Table

Visual elements that do not contain any information should be marked as _____________________________.

Decorative

Which of the following values can be indicated using conditional formatting? Average Values Duplicate Values High or Low Values Projected values based on the data

Duplicate Values, High or Low Values

Where can you access Chart Styles? As a button to the right of a selected chart. In the Chart Tools Design tab in the ribbon. ( In the Chart Tools Format tab in the ribbon. In the Data tab of the ribbon. On the context menu after selecting a chart. No answer text provided.

As a button to the right of a selected chart. In the Chart Tools Design tab in the ribbon. (

Which of the following best describes the role of Alt Text? Allow data to be translated into different languages. Assists users with a screen reader who are accessing the workbook. Enables users to input text quickly. Provides additional information for a chart's legend.

Assists users with a screen reader who are accessing the workbook.

A Microsoft Excel chart can contain the following titles: Axis title(s) ( Chart title(s) Data title(s) Legend title(s)

Axis title(s) ( Chart title(s)

How can you find the name of a predefined chart layout? By hovering over a selection in the gallery By opening Chart Elements By opening the Format task pane By viewing the workbook properties

By hovering over a selection in the gallery

What does the Switch Row/Column button do? Change the orientation of axes in a chart. Paste row data into a column. Rearrange data in a range of cells. Toggle Axis Titles off and on

Change the orientation of axes in a chart.

A Microsoft Excel chart is made up of multiple ________________________ which can be added, removed, and modified to customize the chart.

Chart Elements

A ___________________________ rearranges chart elements but does not alter their appearance.

Chart Layout

Which of the following statements is true of Quick Analysis charts? The list of chart types can be customized in the Options window. Only a few of the most popular chart types are available. Generated charts cannot be customized. Chart type choices vary depending on the selection.

Chart type choices vary depending on the selection.

How does Excel determine what data to use when creating a chart? It uses all data on the current worksheet. It uses all data in the current workbook. It uses only the selected cells. It uses the selected cell and all adjacent cells.

It uses only the selected cells.

A ______________________________ is an arrangement of chart elements within a chart.

Layout

Which features can be used to remove conditional formatting? Clear Rules Color Scales Data Bars Manage Rules New Rule

Manage Rules

Which of the following options can you use to emphasize data points on a sparkline? Callouts Data Labels Gridlines Markers

Markers

To remove a chart from the current worksheet and place it on a newly created worksheet, use the _______________________________ dialog box.

Move Chart

Which of the following can be done with the Move Chart dialog box? Make a duplicate copy of a chart. Move a chart to an existing worksheet Move a chart to a PowerPoint presentation. Move a chart to a new worksheet.

Move a chart to an existing worksheet, Move a chart to a new worksheet.

What is the preferred length of Alt Text? A few words One or two paragraphs One or two sentences

One or two sentences

Which of the following options best describes the role of the Quick Analysis feature? Analyze data and generate a text-based report Forecast or project future value Quickly generate totals and visualizations Quickly generate new values based on existing data

Quickly generate totals and visualizations

If you want Microsoft Excel to suggest a chart for your data, use the __________________________ feature.

Recommended Chart

What is the effect of marking a graphic element as "decorative"? Data is disconnected from the chart so that it does not update. Screen readers will notify users that it doesn't contain information. The object is locked and cannot be altered. The object becomes part of the workbook's template.

Screen readers will notify users that it doesn't contain information.

The ____________________________ button allows you exclude some data from a chart.

Select Data

How can you access the Quick Analysis tool? Navigate to the Data tab on the ribbon. Right-click or access the context menu on a chart or sparkline. Select a range of cells. Select Conditional Formatting from the Home tab on the ribbon.

Select a range of cells.

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

Select an entirely new range of data.

Use a predefined _________________________ to quickly modify settings related to the appearance of sparklines.

Style or Quick Style

Which of the following options allow you to modify chart elements? The Chart Elements task pane The Chart Tools Ribbon The Data tab on the Ribbon The Format task pane The Page Layout tab on the

The Chart Tools Ribbon, The Format task pane

Which of the following are NOT changed when you select a style? The fonts used in text elements The position of elements Shadows and glows

The position of elements

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 can only be applied to a chart once. They must be created by the user.

They arrange the position of chart elements.

Which of the following explanations are reasons to switch the rows and columns on a chart? To change to a different chart type. To check if you prefer to orient the chart differently. To correct a column chart only rendering one column. To correct a pie chart that is only displaying a category name. ( To move the chart to a different worksheet.

To check if you prefer to orient the chart differently, To correct a pie chart that is only displaying a category name. (

A _____________________________ indicates the general pattern of a data series.

Trendline

To modify an individual sparkline, you must first ______________________ it. Clear Detach Select Ungroup

Ungroup

The ___________________________ chart type emphasizes the difference between positive and negative values in the data series.

Win/Loss

Conditional formatting uses a condition to determine a cell's. Appearance Location Size Value

appearance

Conditional formatting with the _________________________ option will shade every selected cell based on how its value compares to the average.

Color Scales

Excel offers predefined _____________________________ for charts rather than forcing you to pick individual colors.

Color Schemes

Which of the following conditional formatting rules is the best option for emphasizing the variance between values in a data range? Bottom 10 items Color scales Duplicate values Top 10%

Color scales

Which of the following options are types of conditional formatting? Color scales Data bars Highlight cells rules Pie charts SmartArt Tables

Color scales, Data bars, Highlight cells rules

What are the different chart types for sparklines? Bar Column Line Pie Win/Loss

Column Line Win/Loss

Which of the following can you add using Quick Analysis? A chart A color scale A predefined color scheme A trendline

A chart, color sca;e, trendline

Which of the following terms refers to a row or column of data in a worksheet that is plotted in a chart? A data series Axis Data Label Data Table

A data series

Which data arrangement is ideal for a pie chart? Any number of rows and columns; however, data must be in a table. A single cell of conditionally formatted data. A single row or column of data. Multiple rows and columns of data.

A single row or column of data.

____________________________ make a chart easier to read by providing regularly spaced reference lines for comparison.

Gridlines

By default, related sparklines are managed together in a ________________________.

Group

Which of the following options is used to emphasize the largest value in a data series? First point Low point Last point High point

High point

3 Signs is an option for the _______________________________ conditional formatting rule. Color Scales Data Bars Icon sets Highlight between

Icon sets

You can indicate positive, negative, or neutral values with icons by using

Icon sets

You added data to the worksheet after the chart was created. Why might you need to add more data to a chart? 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 didn't select all the data when you created the chart. You want to switch the rows and columns in the chart.

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

Which of the following cannot be added using Quick Analysis? Averages Charts Cell Styles Conditional Formatting Sparklines

cell styles