Site MapHelpFeedbackLesson 05 - Exploring Formulas Basics
Lesson 05 - Exploring Formulas Basics
(See related pages)

1
What is the result of this formula: =1+2*3-1?
A)4
B)6
C)8
D)10
2
Which of these references is an example of a mixed reference?
A)B1
B)$B$1
C)$B1
D)AB1
3
Which group on the Page Layout tab includes commands to print a worksheet smaller than actual size?
A)Shrink to Fit
B)Adjust to Fit
C)Scale to Fit
D)Fit Options
4
How is a relative reference different from an absolute reference?
A)It includes column and row references.
B)It adjusts to its location on the worksheet.
C)It refers to an existing cell on the worksheet.
D)It resets to its original value.
5
Which of these references is an example of a relative reference?
A)B1
B)$B$1
C)$B1
D)B$1
6
In this formula =B4/B3*B2, how is the arithmetic carried out?
A)Multiplication first, then division
B)From right to left
C)From left to right
D)Exponentiation first, then multiplication
7
What does HTML mean?
A)High Top Math Level
B)Hyper True Math Language
C)Hypertext Markup Language
D)Hyper Text Memory Language
8
Which of these cell references is absolute?
A)A1
B)$A$1
C)$A1
D)A$1
9
Which group on the Page Layout tab includes commands to print a worksheet smaller than actual size?
A)Shrink to Fit
B)Adjust to Fit
C)Scale to Fit
D)Fit Options
10
Which of these arithmetic operators takes the highest precedence?
A)< (lesser than)
B)> (greater than)
C)/ (division)
D)^ (exponentiation)





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.


PASOnline Learning Center

Home > Excel > Lesson 05 Quiz