Question 1

The arithmetic operator, ^, directs Excel to perform the division operation.

Accepted Answer

A) True 
 B)False

Question 2

In designing a worksheet, visual aesthetics should come first.

Accepted Answer

A) True 
 B)False

Question 3

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

Accepted Answer

A) True 
 B)False

Question 4

The range automatically selected by Excel is always correct.

Accepted Answer

A) True 
 B)False

Question 5

You cannot format an entire column at once.

Accepted Answer

A) True 
 B)False

Question 6

In the order of operations, the last operation Excel performs is ____________________.

Accepted Answer

subtractio

Question 7

To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.

Accepted Answer

A)  Print Active Sheets 
B)  Print Selection 
C)  Print Entire Workbook 
D)  none of the above 
A)  Print Active Sheets 
B)  Print Selection 
C)  Print Entire Workbook 
D)  none of the above

Question 8

Which of the following Option buttons gives options for filling cells following a fill operation?

Accepted Answer

A)  Auto Fill Options 
B)  AutoCorrect Options 
C)  Insert Options 
D)  Paste Options 
A)  Auto Fill Options 
B)  AutoCorrect Options 
C)  Insert Options 
D)  Paste Options

Question 9

To select a number format, you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear.

Accepted Answer

A) True 
 B)False

Question 10

Critical Thinking Questions
Case 2-1
Leo, owner of Leo's Bread Company, recently installed Excel 2013 and created a new workbook to track sales of different types of bread. He wants to determine which types of bread are the most popular among his customers. He is particularly interested in sales of rye bread, onion rolls, and bagels. Leo has formatted the sales numbers with the Accounting number format.
-After Leo enters the sales numbers into the cells, he decides he does not want the fixed dollar sign to appear on the far left of the cell, separated by spaces from the actual value. He would prefer that the dollar sign appear immediately to the left of the first digit of the value. To specify a floating dollar sign, which of the following formats should Leo apply?

Accepted Answer

A)  Comma style 
B)  Percent style 
C)  Currency style 
D)  General number 
A)  Comma style 
B)  Percent style 
C)  Currency style 
D)  General number

Question 11

You can open the Format Cells dialog box by pressing the ____ keys.

Accepted Answer

A)  SHIFT+TAB 
B)  CTRL+1 
C)  ALT+1 
D)  SHIFT+F1 
A)  SHIFT+TAB 
B)  CTRL+1 
C)  ALT+1 
D)  SHIFT+F1

Question 12

You can use the arrow keys to complete an entry in Point mode.

Accepted Answer

A) True 
 B)False

Question 13

To start a new line in a cell, press the ____ keys.

Accepted Answer

A)  CTRL+ENTER 
B)  TAB+ENTER 
C)  ALT+ENTER 
D)  SHIFT+ENTER 
A)  CTRL+ENTER 
B)  TAB+ENTER 
C)  ALT+ENTER 
D)  SHIFT+ENTER

Question 14

Critical Thinking Questions
Case 2-1
Leo, owner of Leo's Bread Company, recently installed Excel 2013 and created a new workbook to track sales of different types of bread. He wants to determine which types of bread are the most popular among his customers. He is particularly interested in sales of rye bread, onion rolls, and bagels. Leo has formatted the sales numbers with the Accounting number format.
-Leo wants the sales numbers for rye bread, onion rolls, and bagels to look different each time the sales for each exceeds $500. What Excel feature can Leo use to accomplish this?

Accepted Answer

A)  Spell checker 
B)  Conditional formatting 
C)  Point mode 
D)  Formulas version 
A)  Spell checker 
B)  Conditional formatting 
C)  Point mode 
D)  Formulas version

Question 15

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Pastes a formula.

Accepted Answer

A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V 
A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V

Question 16

Which of the following happens when you enter the formula =G15 into a cell?

Accepted Answer

A)  Excel recalculates all formulas in the worksheet 
B)  Excel assigns the sum of the values in the previous 15 cells to the active cell 
C)  Excel assigns the value in cell G15 to the active cell 
D)  Nothing; =G15 is an invalid formula 
A)  Excel recalculates all formulas in the worksheet 
B)  Excel assigns the sum of the values in the previous 15 cells to the active cell 
C)  Excel assigns the value in cell G15 to the active cell 
D)  Nothing; =G15 is an invalid formula

Question 17

Which of the following is the path to the Copy and Paste buttons?

Accepted Answer

Question 18

Which of the following is the path to the Sum arrow?

Accepted Answer

Question 19

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Displays the worksheet with formulas.

Accepted Answer

A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V 
A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V

Question 20

While holding down the ALT key, you can select nonadjacent ranges and cells.

Accepted Answer

A) True 
 B)False

The arithmetic operator, ^, directs Excel to perform the division operation.

In designing a worksheet, visual aesthetics should come first.

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

The range automatically selected by Excel is always correct.

You cannot format an entire column at once.

In the order of operations, the last operation Excel performs is ____________________.

To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.

Which of the following Option buttons gives options for filling cells following a fill operation?

To select a number format, you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear.

You can open the Format Cells dialog box by pressing the ____ keys.

You can use the arrow keys to complete an entry in Point mode.

To start a new line in a cell, press the ____ keys.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Pastes a formula.

Which of the following happens when you enter the formula =G15 into a cell?

Which of the following is the path to the Copy and Paste buttons?

Which of the following is the path to the Sum arrow?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Displays the worksheet with formulas.

While holding down the ALT key, you can select nonadjacent ranges and cells.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Working With Large Worksheets, Charting, and What-If Analysis

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters

Exam 3: Formulas, Functions, and Formatting

The arithmetic operator, ^, directs Excel to perform the division operation.

In designing a worksheet, visual aesthetics should come first.

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

The range automatically selected by Excel is always correct.

You cannot format an entire column at once.

In the order of operations, the last operation Excel performs is ____________________.

To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.

Which of the following Option buttons gives options for filling cells following a fill operation?

To select a number format, you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear.

You can open the Format Cells dialog box by pressing the ____ keys.

You can use the arrow keys to complete an entry in Point mode.

To start a new line in a cell, press the ____ keys.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Pastes a formula.

Which of the following happens when you enter the formula =G15 into a cell?

Which of the following is the path to the Copy and Paste buttons?

Which of the following is the path to the Sum arrow?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Displays the worksheet with formulas.

While holding down the ALT key, you can select nonadjacent ranges and cells.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Working With Large Worksheets, Charting, and What-If Analysis

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters