Site MapHelpFeedbackLesson 10 - Using 3-D References
Lesson 10 - Using 3-D References
(See related pages)

1
What is changed when you drag the tab split box?
A)Width of the formula bar
B)Number of visible tab names
C)Height of the search bar
D)Depth of the vertical scroll bar
2
What can a simple 3-D reference refer to?
A)One sheet name
B)One filename
C)One cell
D)One comment
3
What key(s) completes an entry and keeps the insertion point in the current cell?
A)[Enter]
B)[Alt]+[Enter]
C)[Ctrl]+[Enter]
D)[Shift]+[Enter]
4
Which of the following best describes a 3-D reference?
A)A formula that refers to cells in another part of the same worksheet.
B)A formula that refers to cells in another worksheet in the same workbook.
C)A formula that refers to workbooks in another folder.
D)A formula that refers to worksheets in another workbook.
5
What appears in the title bar for a workbook that has been marked as final?
A)[Final]
B)[Marked as Final]
C)[Read]
D)[Read Only]
6
Which of the following is true about a document that is marked as final?
A)It cannot be viewed.
B)It cannot be opened.
C)It cannot be edited.
D)It cannot be resaved.
7
Which of these formulas is a 3-D reference?
A)0
B)#REF!
C)#NAME?
D)=([Book1]:Sheet1!)
8
How can a workbook be electronically authenticated?
A)Digital signature
B)Document inspection
C)Document signature
D)Digital review
9
How can the horizontal scroll bar be sized?
A)By double-clicking the worksheet tab.
B)By dragging the split tab box.
C)By dragging the worksheet tab.
D)By right-clicking the split tab box.
10
What should follow the sheet name in a 3-D formula?
A)Colon
B)Parentheses
C)Period
D)Exclamation point





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


PAS Office 2007 BriefOnline Learning Center

Home > Excel > Lesson 10 Quiz