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

1
If you key 1.2385 in an Excel worksheet and format the cell for two decimal places, which of the following numbers will be displayed in the formula bar?
A)1.2
B)1.23
C)1.24
D)1.2385
2
Which of the following phrases defines an integer?
A)A cell reference
B)A number with decimals
C)A number with fractions
D)A whole number
3
Which of the following choices determines the font and color used for hyperlink text in an Excel worksheet?
A)Format Cells dialog box
B)Document theme
C)Default options in the Font dialog box
D)Web page settings
4
Which of the following statements about SmartArt is true when you save a workbook in Excel 97-2003 format?
A)It is removed from the workbook.
B)It is converted to viewable objects.
C)It is converted to editable objects.
D)It is saved in a separate file.
5
Which of the following arguments in an Excel financial function determines how the interest is calculated?
A)FV
B)PV
C)Nper
D)Rate
6
Which of the following statements about hyperlinks in an Excel workbook is false?
A)It is a clickable object or text.
B)It displays another file when clicked.
C)It is a shortcut to files on the computer.
D)It is created automatically by Excel.
7
Which of the following Excel function categories displays data or information from other worksheets or workbooks?
A)Financial
B)Database
C)Logical
D)Lookup & Reference
8
Which of the following definitions is correct for the draw layer in an Excel workbook?
A)Cover sheet for the workbook with file name and size
B)Transparent working area on top of a worksheet for objects
C)Invisible worksheet for layering comments and objects
D)Bottom layer in the worksheet stack
9
Which of the following terms applies to shaped and formatted text in an Excel worksheet?
A)TextArt
B)TextWord
C)WordArt
D)WordText
10
Which of the following statements about SmartArt in an Excel worksheet is true?
A)It is an image that snaps to its location.
B)It is a high quality illustration.
C)It is formatted and beveled text.
D)It is an image that appears behind the data.





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