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



1

A range can:
A)be a single cell
B)also cover a three-dimensional area
C)cross more than one worksheet within a workbook
D)all the above is possible
2

If the value for Revenue is stored in C5 on Sheet1 and the value for Expenses is stored in C6 on Sheet2, the formula, revenue -expense would read:
A)=Sheet1@C5-Sheet2@C6
B)=Sheet1$C5-Sheet2$C6
C)=Sheet1!C5-Sheet2!C6
D)=Sheet1!C6-Sheet2!C5
3

If a formula adjusts itself automatically when copied, the cell reference is
A)Relative
B)Automatic
C)Absolute
D)Mixed
4

When the formula "=B6*(1+B3)" in cell B6 is copied to cell D6:
A)Copying and pasting has modified the cell addresses by automatically adjusting the column letters
B)the cell references do not change.
C)the cell references also change to reflect their relative positions on the worksheet.
D)Both A and C are right
5

Which formula allows you to build a formula using the row and column labels from the active worksheet?
A)Relative formula
B)Absolute formula
C)Language formula
D)Natural language formula





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


Office 2003 Advantage SeriesOnline Learning Center

Home > Excel 2 > Chapter 4 > Multiple Choice Quiz