NEW
Font size
S
M
L
XL
WorksheetsExcel Tables Basics
Total questions: 15
Worksheet time: 8mins
Name
Class
Date
1.
This tool has a criteria range separate from the actual data.
a)
AutoFilter
b)
Sort
c)
Structured reference
d)
Advanced Filter
2.
Text files that use a special character, such as a comma, to separate fields.
a)
Delimited
b)
Field
c)
Record
d)
Sorting
3.
What is data that originated in another program or format?
a)
Internal data
b)
Outside data
c)
Source data
d)
External data
4.
What is a column of data called?
a)
Record
b)
Field
c)
Field Name
d)
Structured reference
5.
What is the title found in the header row called?
a)
Title
b)
Header name
c)
Field name
d)
Structured reference
6.
Which command recognizes a pattern and duplicates it?
a)
PivotTable
b)
Pattern fill
c)
Duplicate fill
d)
Flash fill
7.
The row that contains the descriptive titles or labels for each column is called the ____________ row.
a)
Title
b)
Field
c)
Label
d)
Header
8.
A row of data is called a ________________.
a)
field
b)
record
c)
row
d)
column
9.
What automatically inserts summary rows for data that are arranged in related groups?
a)
Group
b)
Outline
c)
Subtotal command
d)
PivotTable
10.
A ____________ contains basic data, no formatting, and uses a special character to separate data in columns and rows.
a)
Word file
b)
text file
c)
Access file
d)
Excel file
11.
Ascending order is largest to smallest is the same as sorting alphabetically and Newest to Oldest.
a)
True
b)
False
12.
What tool applies formatting to cells only when the cells meet some criteria?
a)
Special formatting
b)
Criteria formatting
c)
Conditional formatting
d)
Specific formatting
13.
Which tool is used to only show data that meets specific criteria and hides the rest of the data?
a)
Hide
b)
Sort
c)
Filter
d)
AutoFilter
14.
A fill color, horizontal bar or icon within a cell where specified data is indicated is called _______________.
a)
Data specification
b)
Structured reference
c)
Data visualization
d)
Criteria range
15.
Based on the table above, which function generates the value in the cell C5?
a)
COLUMNTOTAL
b)
SUM
c)
COUNT
d)
AMOUNT
e)
VAR
Reset
