Site MapHelpFeedbackLesson 12 - Using Named Ranges and Structured References
Lesson 12 - Using Named Ranges and Structured References
(See related pages)

1
Which of the following cannot be included in a range name?
A)Letters
B)Numbers
C)Underscores
D)Spaces
2
How can a range name be scoped?
A)To a sheet or to the workbook
B)To a sheet, to the workbook, or to a folder
C)To a sheet, to the workbook, or the properties
D)To a sheet or to the folder
3
Which category of functions obtains data or displays information from the current or other workbooks?
A)Financial
B)Database
C)Logical
D)Lookup & Reference
4
Which command changes a columnar cell range into a row range?
A)Arrange
B)Rearrange
C)Select
D)Transpose
5
Which term describes a value that does not change?
A)Formula
B)Structured reference
C)Named range
D)Constant
6
What is a structured reference?
A)A specific range within a table
B)An identifiable formula in a table
C)The range that surrounds a table
D)The range that identifies a table
7
Why is Print_Area not a good choice as a range name?
A)It contains an underscore.
B)It is too long.
C)It is a reserved name.
D)It is the name of a constant.
8
Which button opens the New Name dialog box?
A)Define Name
B)Name Manager
C)Create Names
D)New Range
9
Which of the following statements about range names is false?
A)They are easier to remember than cell addresses.
B)They can be used for navigation.
C)They automatically substitute the relevant cell addresses.
D)They make formulas easier to understand.
10
How can words be separated in a range name?
A)With a space
B)With a comma
C)With a period
D)With a colon





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