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

1
A one-variable data table can contain one or more formulas, and each formula refers to one input cell.
A)True
B)False
2
Aggregate functions permit you to use worksheet tables as sources of information for formulas and calculations in other parts of the worksheet.
A)True
B)False
3
A form is a formatted worksheet with blank spaces that can be filled in online on an individual computer or on a network, or printed and completed on paper.
A)True
B)False
4
Arithmetic operators are symbols used in formulas that compare numbers in two or more cells or to a constant.
A)True
B)False
5
A cell containing a comment displays a red indicator triangle in the upper-right corner.
A)True
B)False
6
A _____ data table uses only one formula that refers to two different input cells, one column-oriented and one row-oriented.
A)Cross tab
B)Two-variable
C)Double
D)One-variable
7
The _____ function searches for a value in the leftmost column of a table.
A)VLOOKUP
B)QUERY
C)CROSSTAB
D)HLOOKUP
8
The default scope for a named range is what?
A)Application level
B)Local worksheet level
C)Global workbook level
D)Single directory level
9
Which of the following is not a logical operator?
A)=
B)>
C)>
D)+
10
A(n) _____ is a note attached to a cell that can be used to help clarify the meaning of the data, provide documentation, or ask a question.
A)Comment
B)Sticky
C)Directive
D)Name





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 Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


Microsoft Office 2007 SeriesOnline Learning Center

Home > Excel > Lab 5: Using Data Tables, Crea > Multiple Choice Quiz