Site MapHelpFeedbackLesson 02 Quiz
Lesson 02 Quiz
(See related pages)

1
As data is keyed in an Excel worksheet, in which of the following locations is it visible?
A)Formula bar
B)Status bar
C)Name box
D)Ribbon
2
Which of the following addresses is a valid cell range address in an Excel worksheet?
A)A1
B)A1-C4
C)A1:C4
D)C4:A1
3
Which of the following arithmetic operations is represented by an asterisk (*) in an Excel workbook?
A)Exponentiation
B)Addition
C)Subtraction
D)Multiplication
4
Which Excel chart type is good for depicting a single set of values?
A)Radar
B)Circle
C)Pie
D)Scatter
5
What two font categories are included in a document theme for an Excel workbook?
A)Labels and Values
B)Columns and Rows
C)Headings and Body
D)Header and Footer
6
Which group on the Home command tab includes commands for formatting how a date is displayed in an Excel worksheet?
A)Number
B)Font
C)Date
D)Styles
7
Which of the following steps completes a cell entry in an Excel worksheet and moves the pointer one cell to the right?
A)Pressing [Enter].
B)Pressing [Tab].
C)Pressing [Shift]+[Tab].
D)Pressing [Shift]+[Enter].
8
In an Excel worksheet, what does B3:D15 represent or indicate?
A)A division formula
B)A cell range
C)A cell format
D)A function
9
Which of the following Excel features displays a list of functions that begin with the letter that you key after an = sign?
A)Formula AutoComplete
B)Formula AutoSum
C)Formula AutoCalculate
D)Formula Preview
10
Which of the following categories best describes the two basic data types used in an Excel worksheet?
A)Labels and values
B)Words and digits
C)Names and numbers
D)Formulas and functions





To learn more about the book this website supports, please visit its Information Center.
(c)2011 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.


Hinkle, Microsoft2010 CompleteOnline Learning Center

Home > Excel > Lesson 02 Quiz