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

1
Which of following Excel formulas is the correct representation of a formula that is to be entered in cell C5?
A)+B6+B15
B)=B6+B15
C)*B6+B15
D)&B6+B15
2
Which of the following commands both belong to the conditional format group for an Excel worksheet?
A)Mixed cell styles and absolute cell references
B)Order of preference and math operators
C)Backgrounds and foregrounds
D)Data bars and highlight cells rules
3
Which of the following cell references is an example of a mixed reference in an Excel worksheet?
A)B1
B)$B$1
C)$B1
D)AB1
4
Which of the following arithmetic operators will be calculated first if all of them are used in the same Excel formula?
A)< (lesser than)
B)> (greater than)
C)/ (division)
D)^ (exponentiation)
5
Which of the following is a reason to display Excel formulas in a worksheet instead of the formula results?
A)They provided documentation of the work.
B)They fit in narrow columns.
C)They rotate in and out of view as the worksheet is scrolled.
D)They cannot be deleted.
6
What type of Excel formula would be best suited to calculating a percentage result for a business problem?
A)Addition
B)Concatenation
C)Division
D)Exponentiation
7
Which of the following definitions is correct for a whole number in an Excel worksheet?
A)A value without a dollar sign
B)A value with two decimal positions
C)A value with no decimal positions
D)A value with a zero
8
How could the Excel formula =B3*B4+B12 be shown so that the result of adding cells B4 and B12 is multiplied by the value in cell B3?
A)=(B3*B4)+B12
B)=(B3)*B4+B12
C)=B3*(B4+B12)
D)=(B3*B4+B12)
9
What would be the result of this Excel formula: =2*4/4?
A)2
B)4
C)6
D)8
10
What does the keyboard shortcut [Ctrl]+[~] do in an Excel worksheet?
A)Inserts a line break in a cell.
B)Adjusts the type of cell reference.
C)Displays formulas in a worksheet.
D)Starts Edit mode.





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 04 Quiz