Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)

1
In a data table, each column represents a field.
A)True
B)False
2
A hyperlink can be used to link to Web content only.
A)True
B)False
3
When a sort is done on more than one column or field, it is called a multilevel sort.
A)True
B)False
4
A filter is a restriction you place on records in the table to quickly isolate and display a subset of records.
A)True
B)False
5
A PivotTable report is an interactive chart that can be used to view and rearrange data.
A)True
B)False
6
In a table, each row contains a _____, which is all the information about one person, thing, or place.
A)Field
B)Column
C)Table
D)Record
7
Hyperlinks store information about their linked location as
A)IRC’s
B)XML’s
C)URL’s
D)HTM’s
8
A single sort operation can be based on up to _____ columns or fields of data.
A)2
B)3
C)4
D)5
9
_____ data has two functions: to collapse and expand rows or columns.
A)Sorting
B)Filtering
C)Outling
D)Grouping
10
The default calculation on a subtotal is what?
A)SUM
B)COUNT
C)MAX
D)MIN







Microsoft Office 2007 SeriesOnline Learning Center

Home > Excel > Lab 6: Creating Lists and Web > Multiple Choice Quiz