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

1
When we describe, or define, the categories of information we collect in an Excel worksheet, what type of table are we creating?
A)Categorization
B)Classification
C)Explanation
D)List definition
2
If you wished to limit what you would see on an Excel worksheet, what data function would you use?
A)Sort
B)Filter
C)Conditional format
D)Data analysis
3
If you wished to hide all rows in a worksheet except those that meet some criteria, what data function would you use?
A)Sort
B)Query
C)Custom filter
D)Table
4
If you wished to highlight, not hide, some information in a worksheet because it met some criteria, what Excel tool would you use?
A)Table
B)Format
C)Conditional Format
D)Filter
5
What Excel tool allows you to create quickly and automatically summary data from a large data set?
A)Conditional formatting
B)Sorting
C)Pivot tables
D)Field lists
6
What Excel tool allows you to create aggregate and statistical data from a large data set?
A)Conditional formatting
B)Sorting
C)Pivot tables
D)Field lists
7
What stops Excel from including a range of cells in the current analysis?
A)An encounter with a blank cell
B)The stop function
C)An encounter with a new calculation
D)A table restriction
8
What is a list definition table?
A)A single worksheet within a workbook.
B)An itemized listing of the rows within a workbook.
C)The identity of the list's developer and its users.
D)A list of the columns and their descriptions that exist in a workbook.
9
What Excel tool allows you to create smaller lists from a large list?
A)AutoFilter
B)List
C)AutoList
D)Table
10
Which of the following is a good habit to get into when creating a worksheet?
A)Placing titles for columns in the first row of data
B)Using conditional formatting to spot spelling errors
C)Inserting comments in each cell to define that data or type of data
D)Grouping records according to some classification





To learn more about the book this website supports, please visit its Information Center.
(c)2008 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Notice.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


Haag MIS 7eOnline Learning Center

Home > Module D (CD) > Multiple Choice Quiz