Copyright 2014 Pearson Education, Inc.

1 Copyright © 2014 Pearson Education, Inc.

Your Office: Microsoft Office 2013, Excel Comprehensive (Kinser et al.)

Module 1 Workshop 1 Navigate, Manipulate, and Print Worksheets 1) A ________ application is a computer program has a user interface comprised of a grid of rows and columns.

• database
• spreadsheet
• matrix
• tabular

Answer: B

Diff: 1 Page Ref: 46

Objective: Understand Spreadsheet Terminology and Components

Text: Your Office: Microsoft Excel 2013 Comprehensive 2) The intersection of a row and column is called a ________.

• cell
• container
• chamber
• cubicle

Answer: A

Diff: 1 Page Ref: 46

Objective: Understand Spreadsheet Terminology and Components

Text: Your Office: Microsoft Excel 2013 Comprehensive 3) Formulas and functions begin with a(n) ________ sign.

• =
• #
• @
• &

Answer: A

Diff: 1 Page Ref: 46

Objective: Understand Spreadsheet Terminology and Components

Text: Your Office: Microsoft Excel 2013 Comprehensive 4) Which of the following is NOT contained in a cell?

• Functions
• Formulas
• Subroutines
• Text

Answer: C

Diff: 2 Page Ref: 46

Objective: Understand Spreadsheet Terminology and Components

Text: Your Office: Microsoft Excel 2013 Comprehensive Your Office Microsoft Excel 2013, Comprehensive 1e Amy S. Kinser et al (Test Bank All Chapters, 100% Original Verified, A+ Grade) 1 / 4

2 Copyright © 2014 Pearson Education, Inc.5) The extension for Microsoft Excel 2013 workbooks is ________.

• .xlx
• .xls
• .xlxs
• .xlsx

Answer: D

Diff: 2 Page Ref: 47

Objective: Understand Spreadsheet Terminology and Components

Text: Your Office: Microsoft Excel 2013 Comprehensive 6) When there are multiple worksheets, you can use the keyboard shortcut Ctrl + ________ to move one worksheet to right.

• Page Down
• Page Up
• Home
• End

Answer: A

Diff: 3 Page Ref: 50 Objective: Navigate Within Worksheets and Workbooks, and Navigate Among Worksheets Text: Your Office: Microsoft Excel 2013 Comprehensive 7) The keyboard shortcut to move one column to the left is ________.

• Tab
• Shift + Tab
• Ctrl + Tab
• Alt + Tab

Answer: B

Diff: 3 Page Ref: 51 Objective: Navigate Within Worksheets and Workbooks, and Navigate Among Worksheets Text: Your Office: Microsoft Excel 2013 Comprehensive 8) The keyboard shortcut to move to cell A1 is ________.

• Home
• Shift + Home
• Ctrl + Home
• Alt + Home

Answer: C

Diff: 2 Page Ref: 51 Objective: Navigate Within Worksheets and Workbooks, and Navigate Among Worksheets Text: Your Office: Microsoft Excel 2013 Comprehensive 2 / 4

3 Copyright © 2014 Pearson Education, Inc.9) To move right one screen, you would use the keyboard shortcut ________.

• Page Down
• Shift + Page Down
• Ctrl + Page Down
• Alt + Page Down

Answer: D

Diff: 3 Page Ref: 51 Objective: Navigate Within Worksheets and Workbooks, and Navigate Among Worksheets Text: Your Office: Microsoft Excel 2013 Comprehensive 10) Which of the following is NOT an example of worksheet documentation?

• Descriptive drop-down documentation menus
• Descriptive worksheet names
• Descriptive cell labels
• Descriptive column titles

Answer: A

Diff: 3 Page Ref: 52

Objective: Document Your Work

Text: Your Office: Microsoft Excel 2013 Comprehensive

11) A comment is indicated by the presence of a ________ in the upper-right corner of a cell.

• red square
• blue square
• red triangle
• blue triangle

Answer: C

Diff: 2 Page Ref: 53

Objective: Document Your Work

Text: Your Office: Microsoft Excel 2013 Comprehensive

12) To insert a comment into a cell, you click New Comment in the ________.

• Comments group on the REVIEW tab
• Comments group on the INSERT tab
• Documentation group on the REVIEW tab
• Documentation group on the INSERT tab

Answer: A

Diff: 3 Page Ref: 53

Objective: Document Your Work

Text: Your Office: Microsoft Excel 2013 Comprehensive

• / 4

4 Copyright © 2014 Pearson Education, Inc.13) Which of the following is typically NOT contained in a separate documentation worksheet?

• Author
• Modification dates
• Charts
• Modification history

Answer: C

Diff: 3 Page Ref: 54

Objective: Document Your Work

Text: Your Office: Microsoft Excel 2013 Comprehensive

14) The base date for date and time data in Excel 2013 is ________.

• January 1, 1000
• January 1, 1900
• December 31, 999
• December 31, 1899

Answer: D

Diff: 3 Page Ref: 55

Objective: Enter and Edit Data

Text: Your Office: Microsoft Excel 2013 Comprehensive 15) Which of the following data types is NOT automatically right-aligned by Excel?

• Text
• Numeric
• Date
• Time

Answer: A

Diff: 3 Page Ref: 55

Objective: Enter and Edit Data

Text: Your Office: Microsoft Excel 2013 Comprehensive

16) The keyboard shortcut for Undo is ________.

• Ctrl + U
• Ctrl + Z
• Ctrl + Y
• Ctrl + W

Answer: B

Diff: 2 Page Ref: 56

Objective: Enter and Edit Data

Text: Your Office: Microsoft Excel 2013 Comprehensive

• / 4