Copyright 2014 Pearson Education, Inc.

1 Copyright © 2014 Pearson Education, Inc.Exploring Microsoft Excel 2013, Comprehensive (Poatsy)

Chapter 1 Introduction to Excel: Hands-On-Exercise Videos

1) Pressing Tab moves the insertion point ________.

• down a row in the same column
• to the beginning of the next row
• right one cell
• left one cell

Answer: C

Diff: 1

Objective: HOE 1: Introduction to Spreadsheets

2) If .25 is typed and Enter or Tab is pressed, Excel will automatically:

• add a percent sign after the number.
• delete the number.
• add a zero in front of the decimal point.
• insert a formula.

Answer: C

Diff: 2

Objective: HOE 1: Introduction to Spreadsheets 3) Which of the following symbols represents division?

• /

B)\

• ÷
• ^

Answer: A

Diff: 2

Objective: HOE 1: Introduction to Spreadsheets 4) All Excel formulas begin with ________.

• *
• @
• =
• #

Answer: C

Diff: 1

Objective: HOE 1: Introduction to Spreadsheets

5) Double-clicking on the fill handle copies a formula until:

• a new formula is entered.
• the Tab key is pressed.
• the Enter key is pressed.
• a blank row is encountered.

Answer: D

Diff: 2

Objective: HOE 1: Introduction to Spreadsheets Exploring Microsoft Excel 2013 Comprehensive by Mary Anne Poatsy Keith Mulbery Jason Davidson Robert Grauer (Test Bank All Chapters, 100% Original Verified, A+ Grade) 1 / 4

2 Copyright © 2014 Pearson Education, Inc.6) Excel displays a series of ________ to indicate that the column width is too narrow to display entire cell contents.

• asterisks *
• pound signs #
• exclamation marks !
• ampersands @

Answer: B

Diff: 2

Objective: HOE 2: Mathematics and Formulas

7) What is the value of =1+2*3^2?

• 19
• 49
• 27
• 81

Answer: A

Diff: 2

Objective: HOE 2: Mathematics and Formulas

8) To display formulas instead of formula results you press Ctrl + ________.

• @
• "
• $
• `

Answer: D

Diff: 3

Objective: HOE 2: Mathematics and Formulas

9) The check mark between the Name Box and the Formula Bar indicates ________.

• Go
• Enter
• Complete
• Correct

Answer: B

Diff: 3

Objective: HOE 3: Workbook and Worksheet Management

10) To change the color of a worksheet tab, you ________, click Tab Color from the menu, and select the desired color from the palette.

• click
• right-click
• double-click
• triple-click

Answer: B

Diff: 2

Objective: HOE 3: Workbook and Worksheet Management 2 / 4

3 Copyright © 2014 Pearson Education, Inc.

11) To automatically adjust the width of column C, you:

• double-click the column C heading.
• right-click the column C heading.
• double-click the border between columns C and D in the column headings.
• double-click the border between columns B and C in the column headings.

Answer: C

Diff: 2

Objective: HOE 3: Workbook and Worksheet Management

12) When copying or cutting a range of cells, the range is:

• surrounded by a solid green border.
• surrounded by a moving dashed green border.
• surrounded by a solid black border.
• surrounded by a moving dashed black border.

Answer: B

Diff: 2

Objective: HOE 4: Clipboard Tasks

13) When pasting the contents of the Clipboard, options such as Formulas & Number Formatting and Values & Source Formatting are displayed by selecting the destination cell or cells and

________.

• clicking Paste
• clicking the Paste arrow
• double-clicking
• clicking the object in the Clipboard

Answer: B

Diff: 2

Objective: HOE 4: Clipboard Tasks

14) The term ________ refers how data are placed in cells.

• positioning
• configuration
• arrangement
• alignment

Answer: D

Diff: 2

Objective: HOE 5: Formatting

• / 4

4 Copyright © 2014 Pearson Education, Inc.15)

In the figure shown above, row 1 is the result of clicking ________.

• Merge Across
• Merge & Center
• Align to Center
• Align to Middle

Answer: B

Diff: 2

Objective: HOE 5: Formatting 16)

The four cells shown in figure above, are the result of clicking ________.

• Text Wrap
• Word Wrap
• Merge & Center
• Orientation

Answer: B

Diff: 2

Objective: HOE 5: Formatting

17)

The figure shown above, depicts the ________ button.

• Center
• Wrap Text
• Decrease Decimal
• Increase Decimal

Answer: D

Diff: 2

Objective: HOE 5: Formatting

18) Landscape and Portrait are examples of page ________.

• alignment
• arrangement
• positioning
• orientation

Answer: D

Diff: 2

Objective: HOE 6: Page Setup and Printing

• / 4