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

1
Which of the following is a function you can use to help make a decision?
A)AutoFilter
B)Conditional formatting
C)Pivot table
D)All of the above
2
What is the intersection of a row and a column?
A)Cell
B)Database
C)AutoFormat
D)Block
3
Which of the following is not a characteristic of a list in spreadsheet software?
A)Each column has only one type of information
B)The first row in the list contains the labels or column headings
C)The list does not contain any blank rows
D)None of the above
4
What is a collection of information arranged in columns and rows where each column displays one type of information is called?
A)Pivot table
B)Hierarchical database
C)List
D)Spreadsheet
5
Which of the following do you need to have before you can use a pivot table?
A)Spreadsheet
B)List
C)Filter
D)Table
6
Which of the following helps you quickly create a view of partial lists of information?
A)AutoFilter
B)Conditional formatting
C)Pivot table
D)Query feature
7
What can you use more than one of when using the AutoFilter function?
A)Column
B)Row
C)Table
D)Constraint
8
Which function would you use if you wanted to scroll through an entire list of customers and have all purchases greater than $10 highlighted?
A)AutoFilter function
B)Custom AutoFilter function
C)Pivot table
D)Conditional formatting
9
Which of the following maintains the view of the entire list of information but highlights key pieces of information that you may be looking for?
A)AutoFilter
B)Conditional formatting
C)Pivot table
D)Column freeze
10
Which of the following helps you quickly aggregate or summarize information by dimension?
A)AutoFilter
B)Conditional formatting
C)Pivot table
D)AutoSum





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


Management Information SystemsOnline Learning Center

Home > XLM D > Multiple Choice Quiz