Exploring Microsoft Excel 2013, Comprehensive, Poatsy - Complete test bank - exam questions - quizzes (updated 2022)

Exploring Microsoft Excel 2013, Comprehensive (Poatsy)

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



1) Pressing Tab moves the insertion point ________.

A) down a row in the same column

B) to the beginning of the next row

C) right one cell

D) 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:

A) add a percent sign after the number.

B) delete the number.

C) add a zero in front of the decimal point.

D) insert a formula.

Answer: C

Diff: 2

Objective: HOE 1: Introduction to Spreadsheets



3) Which of the following symbols represents division?

A) /

B) \

C) ÷

,D) ^

Answer: A

Diff: 2

Objective: HOE 1: Introduction to Spreadsheets



4) All Excel formulas begin with ________.

A) *

B) @

C) =

D) #

Answer: C

Diff: 1

Objective: HOE 1: Introduction to Spreadsheets



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

A) a new formula is entered.

B) the Tab key is pressed.

C) the Enter key is pressed.

D) a blank row is encountered.

Answer: D

Diff: 2

Objective: HOE 1: Introduction to Spreadsheets

6) Excel displays a series of ________ to indicate that the column width is too narrow to
display entire cell contents.

A) asterisks *

,B) pound signs #

C) exclamation marks !

D) ampersands @

Answer: B

Diff: 2

Objective: HOE 2: Mathematics and Formulas



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

A) 19

B) 49

C) 27

D) 81

Answer: A

Diff: 2

Objective: HOE 2: Mathematics and Formulas



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

A) @

B) "

C) $

D) `

Answer: D

Diff: 3

Objective: HOE 2: Mathematics and Formulas

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

A) Go

B) Enter

C) Complete

D) 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.

A) click

B) right-click

C) double-click

D) triple-click

Answer: B

Diff: 2

Objective: HOE 3: Workbook and Worksheet Management

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

A) double-click the column C heading.

B) right-click the column C heading.

C) double-click the border between columns C and D in the column headings.

D) double-click the border between columns B and C in the column headings.

Answer: C

Diff: 2