NEW
Font size
S
M
L
XL
WorksheetsData Quiz
Total questions: 20
Worksheet time: 15mins
Name
Class
Date
1.
One way to make sure the header row always displays when scrolling the worksheet is to
a)
Freeze the Row
b)
Split the worksheet
2.
How can you reorganize a worksheet?
a)
Sort the data
b)
Freeze the rows or columns
3.
What can be used to narrow down the data in your worksheet?
a)
Filter
b)
Sort
4.
To ungroup data, all that is necessary is click the Ungroup command.
a)
True
b)
False
5.
The Subtotal command allows you to automatically create groups and use common functions like _____, _______, and ________ to help summarize your data.
a)
Sum, COUNT, and AVERAGE
b)
Freeze, Sort, Filter
6.
What must be done before subtotaling data?
a)
Ensure the data is correctly sorted.
b)
Ensure the data is correctly filtered
7.
Using the subtotal command creates a(n) _______ for the worksheet.
a)
Group
b)
Outline
8.
Data in your worksheet can be formatted as a table.
a)
True
b)
False
9.
Charts allow you to illustrate your workbook data
a)
Graphically
b)
Visually
10.
In order to use charts effectively, you'll need to understand how different charts are used.
a)
True
b)
False
11.
The _______ axis is also known as the _______ axis.
a)
Vertical, y
b)
Horizontal, y
12.
The y axis identifies the ________ in the chart.
a)
Categories
b)
Value
13.
Excel allows you to add chart _______ such as chart titles, legends, and data labels—to make your chart easier to read.
a)
elements
b)
axis points
14.
When you create subtotals, your worksheet it is divided into different ______.
a)
Levels
b)
Worksheets
15.
You can also use the chart formatting _______ _______ to quickly add chart elements, change the chart style, and filter the chart data.
a)
Shortcut Buttons
b)
Callout Buttons
16.
Tables include ______ by default.
a)
Filtering
b)
Sorting
17.
If you need to fit more content into your table, Excel allows you to modify the table size by including ______ rows and columns.
a)
additional
b)
multiple
18.
Click and drag the _____________ of the table to create additional rows or columns.
a)
Bottom-Right Corner
b)
Fill Handle
19.
To Create a table for the following data select the following range
a)
A2:D9
b)
A1:D9
20.
The six options are that can be turned on and off for tables are: Header Row, _____ Row, Banded Rows, First Column, Last Column, and Banded Columns.
a)
Total
b)
Filter
Reset
