Question 1

Excel displays the error message ____________________ in cells to indicate a cell reference error in a formula.

Accepted Answer

The answer of Excel displays the error message ____________________ in...

Question 2

You can replace a formula with its function so it remains constant.

Accepted Answer

A) True 
 B)False

Question 3

A(n) ____________________ cell reference instructs a paste operation to keep the same cell reference as it copies a formula from one cell to another.

Accepted Answer

The answer of A(n) ____________________ cell reference instructs a paste...

Question 4

Discuss how you should format the various elements of a worksheet.

Accepted Answer

A worksheet should be formatted in the f

Question 5

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Pastes the contents, format, and styles of the source area.

Accepted Answer

A) NOW function 
B) Fill Formatting Only 
C) goal seeking 
D) what-if analysis 
E) NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing 
A) NOW function 
B) Fill Formatting Only 
C) goal seeking 
D) what-if analysis 
E) NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing

Question 6

Following the insertion of a row, the Insert Options button lets you select from which of the following options?

Accepted Answer

A)  Format Same As Above 
B)  Undo Formatting 
C)  Format Same As Below 
D)  Clear Formatting 
A)  Format Same As Above 
B)  Undo Formatting 
C)  Format Same As Below 
D)  Clear Formatting

Question 7

When working with a large worksheet, you can split the window into ____ panes.

Accepted Answer

A)  three or four 
B)  four or five 
C)  two or six 
D)  two or four 
A)  three or four 
B)  four or five 
C)  two or six 
D)  two or four

Question 8

You should use a ____ chart to compare values side by side, broken down by category.

Accepted Answer

A)  Column 
B)  Bar 
C)  Line 
D)  Clustered Column 
A)  Column 
B)  Bar 
C)  Line 
D)  Clustered Column

Question 9

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell.

Accepted Answer

A) NOW function 
B) Fill Formatting Only 
C) goal seeking 
D) what-if analysis 
E) NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing 
A) NOW function 
B) Fill Formatting Only 
C) goal seeking 
D) what-if analysis 
E) NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing

Question 10

The ____________________ option on the Auto Fill Options menu fills the destination area using the format of the source area; no content is copied unless the fill is a series.

Accepted Answer

Fill Forma

Question 11

The <= comparison operator means less than or equal to.

Accepted Answer

A) True 
 B)False

Question 12

Which comparison operator means "not equal to"?

Accepted Answer

A)   
C)   
A)   
C)

Question 13

The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.

Accepted Answer

A) True 
 B)False

Question 14

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Indicates a cell that uses a number incorrectly.

Accepted Answer

A) NOW function 
B) Fill Formatting Only 
C) goal seeking 
D) what-if analysis 
E) NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing 
A) NOW function 
B) Fill Formatting Only 
C) goal seeking 
D) what-if analysis 
E) NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing

Question 15

The NETWORKDAYS function checks a formula for correctness.

Accepted Answer

A) True 
 B)False

Question 16

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

Accepted Answer

A)  Click or tap 
B)  Press or long-press 
C)  Double-click or double-tap 
D)  Triple-click or tap 
A)  Click or tap 
B)  Press or long-press 
C)  Double-click or double-tap 
D)  Triple-click or tap

Question 17

Case 3-1
George runs a mid-size accounting practice and recently upgraded to Excel 2013. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility.
-In George's Sales Data worksheet, the result for a formula in cell H14 is ######. What should George do?

Accepted Answer

A)  increase the width of column H 
B)  provide a correct argument or operand 
C)  run the calculation again to find the available value 
D)  replace the incorrect formula in cell H14 with one that does not divide by zero 
A)  increase the width of column H 
B)  provide a correct argument or operand 
C)  run the calculation again to find the available value 
D)  replace the incorrect formula in cell H14 with one that does not divide by zero

Question 18

Which of the following is not a valid format symbol?

Accepted Answer

A)  semi-colon (;) 
B)  percent sign (%) 
C)  dollar sign ($) 
D)  comma (,) 
A)  semi-colon (;) 
B)  percent sign (%) 
C)  dollar sign ($) 
D)  comma (,)

Question 19

You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it, for example.

Accepted Answer

A)  Alignment 
B)  Left and Right 
C)  Center 
D)  Position 
A)  Alignment 
B)  Left and Right 
C)  Center 
D)  Position

Question 20

The path to the Logical button is (FORMULAS tab | Function Library group).

Accepted Answer

A) True 
 B)False

Excel displays the error message ____________________ in cells to indicate a cell reference error in a formula.

You can replace a formula with its function so it remains constant.

A(n) ____________________ cell reference instructs a paste operation to keep the same cell reference as it copies a formula from one cell to another.

Discuss how you should format the various elements of a worksheet.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Pastes the contents, format, and styles of the source area.

Following the insertion of a row, the Insert Options button lets you select from which of the following options?

When working with a large worksheet, you can split the window into ____ panes.

You should use a ____ chart to compare values side by side, broken down by category.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell.

The ____________________ option on the Auto Fill Options menu fills the destination area using the format of the source area; no content is copied unless the fill is a series.

The <= comparison operator means less than or equal to.

Which comparison operator means "not equal to"?

The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicates a cell that uses a number incorrectly.

The NETWORKDAYS function checks a formula for correctness.

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

Which of the following is not a valid format symbol?

You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it, for example.

The path to the Logical button is (FORMULAS tab | Function Library group).

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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 4: Working With Large Worksheets, Charting, and What-If Analysis

Excel displays the error message ____________________ in cells to indicate a cell reference error in a formula.

You can replace a formula with its function so it remains constant.

A(n) ____________________ cell reference instructs a paste operation to keep the same cell reference as it copies a formula from one cell to another.

Discuss how you should format the various elements of a worksheet.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Pastes the contents, format, and styles of the source area.

Following the insertion of a row, the Insert Options button lets you select from which of the following options?

When working with a large worksheet, you can split the window into ____ panes.

You should use a ____ chart to compare values side by side, broken down by category.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell.

The ____________________ option on the Auto Fill Options menu fills the destination area using the format of the source area; no content is copied unless the fill is a series.

The <= comparison operator means less than or equal to.

Which comparison operator means "not equal to"?

The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicates a cell that uses a number incorrectly.

The NETWORKDAYS function checks a formula for correctness.

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

Which of the following is not a valid format symbol?

You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it, for example.

The path to the Logical button is (FORMULAS tab | Function Library group).

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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