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