WorksheetsExcel Tutorials 18-25 Review
Total questions: 30
Worksheet time: 15mins
In order to use a chart _________, you'll need to understand how different charts are used.
slideshow
effectively
The _______ identifies which data series each color on the chart represents.
legend
vertical axis
horizontal axis
Title
Excel allows you to add chart elements—such as chart titles, _______, and data labels—to make your chart easier to read.
data tables
error bars
gridlines
legends
You can also use the chart formatting _______ _______ to quickly add chart elements, change the chart style, and filter the chart data.
style elements
shortcut buttons
filter data
quick layout
If you're not sure which type of chart to use, the _______ _______ command will suggest several different charts based on the source data.
Recommended Charts
Chart Types
Layout Style
To edit a chart, go to the _________ tab.
Home
Layout
View
Design
The _______ axis (also known as the _______ axis) is the _______ part of the chart. The _______ axis measures the value of the columns.
horizontal, y, horizontal, y
vertical, y, vertical, y
horizontal, X, horizontal, X
vertical, x, vertical, x
The _______ axis (also known as the _______ axis) is the _______ part of the chart. The horizontal axis identifies the categories in the chart.
Vertical, y, Vertical, y
Horizontal, x, Horizontal, x
horizontal, y, horizontal, y
Vertical, x, Vertical, x
Similar to charts and sparklines, conditional formatting provides another way to visualize data and make _________ easier to understand.
workbooks
worksheets
formatting
charts
Conditional formatting allows you to automatically apply formatting—such as ________, icons, and data bars—to one or more cells based on the cell value.
layout
worksheets
color
rules
You can apply multiple conditional formatting rules to a cell range or worksheets, allowing you to visualize different _______ and patterns in your data.
trends
layouts
colors
styles
True/False Color Scales are horizontal bars added to each cell, much like a bar graph.
True
False
_______ _______ add a specific icon to each cell based on its value.
icon bars
icon sets
icon styles
icon colors
Click Manage Rules to edit or delete _______ rules. This is especially useful if you've applied multiple rules to a worksheet.
individual
simple
complex
clear
In the Green-Yellow-Red color scale, the highest values are _______, the average values are yellow, and the lowest values are _______.
green, red
red, green
Excel has several predefined styles—or _______—you can use to quickly apply conditional formatting to your data.
templates
conditions
presets
When you turn on the Track Changes feature, every cell you edit will be highlighted with a unique _________ and indicator.
color
format
border
highlight
You cannot use track changes if your workbook includes a _______. To remove a _______, select it, click the Design tab, then click Convert to Range.
table
range
list
border
When you turn on Track Changes, your workbook will be shared _______.
again
acceptably
automatically
You can also view changes on a new worksheet, sometimes called the _______ _______ history.
highlight changes
track changes
old value
list changes
Tracked changes are really just _______ changes.
temporary
suggested
old
new
Turning off Track Changes will _______ any tracked changes in your workbook. All changes will be __________ automatically.
remove, deleted
ignore, deleted
delete, deleted
remove, accepted
While often used in combination with Track Changes, you don't necessarily need to have Track Changes turned on to use _______.
formatting
comments
styles
Sometimes you may want to add a comment to provide feedback instead of editing the _______ of a cell.
changes
history
content
border
Tables include________ by default.
styles
headers
filtering
Excel can organize data into _________, allowing you to easily show and hide different sections of your worksheet.
ranges
filters
groups
subtotals
You can also summarize different groups using the ___________ command and create an outline for your worksheet.
table
subtotal
outline
design
The _________ command could help to calculate the cost of office supplies by type from a large inventory order.
groups
outline
subtotal
organize
When you create subtotals, your worksheet it is divided into different ________.
levels
categories
colors
sizes
To remove all groups without deleting the subtotals, click the Ungroup command drop-down arrow, then choose Clear _________.
count
all
command
outline
