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