Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel Tutorials 18-25 Review

Total questions: 30

Worksheet time: 15mins

Name
Class
Date
1.

In order to use a chart _________, you'll need to understand how different charts are used.

a)

slideshow

b)

effectively

2.

The _______ identifies which data series each color on the chart represents.

a)

legend

b)

vertical axis

c)

horizontal axis

d)

Title

3.

Excel allows you to add chart elements—such as chart titles, _______, and data labels—to make your chart easier to read.

a)

data tables

b)

error bars

c)

gridlines

d)

legends

4.

You can also use the chart formatting _______ _______ to quickly add chart elements, change the chart style, and filter the chart data.

a)

style elements

b)

shortcut buttons

c)

filter data

d)

quick layout

5.

If you're not sure which type of chart to use, the _______ _______ command will suggest several different charts based on the source data.

a)

Recommended Charts

b)

Chart Types

c)

Layout Style

6.

To edit a chart, go to the _________ tab.

a)

Home

b)

Layout

c)

View

d)

Design

7.

The _______ axis (also known as the _______ axis) is the _______ part of the chart. The _______ axis measures the value of the columns.

a)

horizontal, y, horizontal, y

b)

vertical, y, vertical, y

c)

horizontal, X, horizontal, X

d)

vertical, x, vertical, x

8.

The _______ axis (also known as the _______ axis) is the _______ part of the chart. The horizontal axis identifies the categories in the chart.

a)

Vertical, y, Vertical, y

b)

Horizontal, x, Horizontal, x

c)

horizontal, y, horizontal, y

d)

Vertical, x, Vertical, x

9.

Similar to charts and sparklines, conditional formatting provides another way to visualize data and make _________ easier to understand.

a)

workbooks

b)

worksheets

c)

formatting

d)

charts

10.

Conditional formatting allows you to automatically apply formatting—such as ________, icons, and data bars—to one or more cells based on the cell value.

a)

layout

b)

worksheets

c)

color

d)

rules

11.

You can apply multiple conditional formatting rules to a cell range or worksheets, allowing you to visualize different _______ and patterns in your data.

a)

trends

b)

layouts

c)

colors

d)

styles

12.

True/False Color Scales are horizontal bars added to each cell, much like a bar graph.

a)

True

b)

False

13.

_______ _______ add a specific icon to each cell based on its value.

a)

icon bars

b)

icon sets

c)

icon styles

d)

icon colors

14.

Click Manage Rules to edit or delete _______ rules. This is especially useful if you've applied multiple rules to a worksheet.

a)

individual

b)

simple

c)

complex

d)

clear

15.

In the Green-Yellow-Red color scale, the highest values are _______, the average values are yellow, and the lowest values are _______.

a)

green, red

b)

red, green

16.

Excel has several predefined styles—or _______—you can use to quickly apply conditional formatting to your data.

a)

templates

b)

conditions

c)

presets

17.

When you turn on the Track Changes feature, every cell you edit will be highlighted with a unique _________ and indicator.

a)

color

b)

format

c)

border

d)

highlight

18.

You cannot use track changes if your workbook includes a _______. To remove a _______, select it, click the Design tab, then click Convert to Range.

a)

table

b)

range

c)

list

d)

border

19.

When you turn on Track Changes, your workbook will be shared _______.

a)

again

b)

acceptably

c)

automatically

20.

You can also view changes on a new worksheet, sometimes called the _______ _______ history.

a)

highlight changes

b)

track changes

c)

old value

d)

list changes

21.

Tracked changes are really just _______ changes.

a)

temporary

b)

suggested

c)

old

d)

new

22.

Turning off Track Changes will _______ any tracked changes in your workbook. All changes will be __________ automatically.

a)

remove, deleted

b)

ignore, deleted

c)

delete, deleted

d)

remove, accepted

23.

While often used in combination with Track Changes, you don't necessarily need to have Track Changes turned on to use _______.

a)

formatting

b)

comments

c)

styles

24.

Sometimes you may want to add a comment to provide feedback instead of editing the _______ of a cell.

a)

changes

b)

history

c)

content

d)

border

25.

Tables include________ by default.

a)

styles

b)

headers

c)

filtering

26.

Excel can organize data into _________, allowing you to easily show and hide different sections of your worksheet.

a)

ranges

b)

filters

c)

groups

d)

subtotals

27.

You can also summarize different groups using the ___________ command and create an outline for your worksheet.

a)

table

b)

subtotal

c)

outline

d)

design

28.

The _________ command could help to calculate the cost of office supplies by type from a large inventory order.

a)

groups

b)

outline

c)

subtotal

d)

organize

29.

When you create subtotals, your worksheet it is divided into different ________.

a)

levels

b)

categories

c)

colors

d)

sizes

30.

To remove all groups without deleting the subtotals, click the Ungroup command drop-down arrow, then choose Clear _________.

a)

count

b)

all

c)

command

d)

outline