Question 1

A date stamp shows the date a workbook, report, or other document was created or the time period it represents.

Accepted Answer

A) True 
 B)False

Question 2

The arguments in an IF function are ____.

Accepted Answer

A)  logical_test 
B)  value_if_true 
C)  value_if_true_false 
D)  value_if_false 
A)  logical_test 
B)  value_if_true 
C)  value_if_true_false 
D)  value_if_false

Question 3

When you change a value on which a chart is dependent, Excel immediately redraws the chart based on the new value.

Accepted Answer

A) True 
 B)False

Question 4

____ refers to cells not wide enough to display the entire entry.

Accepted Answer

A)  ##### 
B)  &&&&& 
C)  $$$$$ 
D)  +++++ 
A)  ##### 
B)  &&&&& 
C)  $$$$$ 
D)  +++++

Question 5

The range of entries that identifies the major groups for a clustered column chart are called the category names.

Accepted Answer

A) True 
 B)False

Question 6

A sensitivity analysis is another name for a(n) ____________________ analysis.

Accepted Answer

The answer of A sensitivity analysis is another name for...

Question 7

Critical Thinking Questions
Case 3-2
Bea is the best pie baker around. She has decided to go into business and takes a survey in her town to find out what types of pies are favorites. She decides to record her data in a worksheet she can present to the bank when she seeks a loan for her business startup costs. Bea is new to using Excel, however, and she would like to become conversant in the keyboard shortcuts for the options available in the Paste Options gallery to expedite her work.
-Bea wants to copy the contents and format of a source area but transpose, or swap, the rows and columns. What keyboard shortcut can she use to do this?

Accepted Answer

A)  CTRL+S 
B)  CTRL+T 
C)  CTRL+K 
D)  CTRL+D 
A)  CTRL+S 
B)  CTRL+T 
C)  CTRL+K 
D)  CTRL+D

Question 8

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Returns a number that corresponds to the system date and time beginning with December 31, 1899.

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 9

Rotated text allows you to fit more text into a smaller column width.

Accepted Answer

A) True 
 B)False

Question 10

In a clustered column chart, the names of each column are part of the ____ series.

Accepted Answer

A)  category 
B)  data 
C)  label 
D)  legend 
A)  category 
B)  data 
C)  label 
D)  legend

Question 11

Text in a cell can be rotated counterclockwise by entering a number in the Alignment sheet in the Format Cells dialog box. Which of the following are valid values for that number?

Accepted Answer

A)  15 
B)  90 
C)  145 
D)  180 
A)  15 
B)  90 
C)  145 
D)  180

Question 12

The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.

Accepted Answer

A)  Copy Cells 
B)  Fill Formatting Only 
C)  Fill Without Formatting 
D)  none of the above 
A)  Copy Cells 
B)  Fill Formatting Only 
C)  Fill Without Formatting 
D)  none of the above

Question 13

When the Paste Options button is visible, you can use ____________________ to access the paste commands available in the Paste Options gallery.

Accepted Answer

The answer of When the Paste Options button is visible,...

Question 14

____________________ is the default option that Excel uses to fill an area with the Auto Fill Options menu.

Accepted Answer

The answer of ____________________ is the default option that Excel...

Question 15

Which of the following are formatting symbols?

Accepted Answer

A)  Dollar sign ($) 
B)  Comma (,) 
C)  Pound sign (#) 
D)  Percent sign (%) 
A)  Dollar sign ($) 
B)  Comma (,) 
C)  Pound sign (#) 
D)  Percent sign (%)

Question 16

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Keeps a cell reference constant when copying a formula or function.

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 17

Which of the following is an extension of the fill pattern Sunday, Tuesday?

Accepted Answer

A)  Wednesday, Thursday, Saturday 
B)  Thursday, Saturday, Monday 
C)  Saturday, Sunday, Monday 
D)  Monday, Wednesday, Friday 
A)  Wednesday, Thursday, Saturday 
B)  Thursday, Saturday, Monday 
C)  Saturday, Sunday, Monday 
D)  Monday, Wednesday, Friday

Question 18

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Fills a destination area using the format of the source area; no content is copied.

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 19

The incorrect use of copying, deleting, inserting, and moving ranges of cells has the potential to render a worksheet useless.

Accepted Answer

A) True 
 B)False

Question 20

____________________ are values in cells that can be changed to determine new values for formulas.

Accepted Answer

The answer of ____________________ are values in cells that can...

A date stamp shows the date a workbook, report, or other document was created or the time period it represents.

The arguments in an IF function are ____.

When you change a value on which a chart is dependent, Excel immediately redraws the chart based on the new value.

____ refers to cells not wide enough to display the entire entry.

The range of entries that identifies the major groups for a clustered column chart are called the category names.

A sensitivity analysis is another name for a(n) ____________________ analysis.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Returns a number that corresponds to the system date and time beginning with December 31, 1899.

Rotated text allows you to fit more text into a smaller column width.

In a clustered column chart, the names of each column are part of the ____ series.

Text in a cell can be rotated counterclockwise by entering a number in the Alignment sheet in the Format Cells dialog box. Which of the following are valid values for that number?

The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.

When the Paste Options button is visible, you can use ____________________ to access the paste commands available in the Paste Options gallery.

____________________ is the default option that Excel uses to fill an area with the Auto Fill Options menu.

Which of the following are formatting symbols?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Keeps a cell reference constant when copying a formula or function.

Which of the following is an extension of the fill pattern Sunday, Tuesday?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Fills a destination area using the format of the source area; no content is copied.

The incorrect use of copying, deleting, inserting, and moving ranges of cells has the potential to render a worksheet useless.

____________________ are values in cells that can be changed to determine new values for formulas.

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

A date stamp shows the date a workbook, report, or other document was created or the time period it represents.

The arguments in an IF function are ____.

When you change a value on which a chart is dependent, Excel immediately redraws the chart based on the new value.

____ refers to cells not wide enough to display the entire entry.

The range of entries that identifies the major groups for a clustered column chart are called the category names.

A sensitivity analysis is another name for a(n) ____________________ analysis.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Returns a number that corresponds to the system date and time beginning with December 31, 1899.

Rotated text allows you to fit more text into a smaller column width.

In a clustered column chart, the names of each column are part of the ____ series.

Text in a cell can be rotated counterclockwise by entering a number in the Alignment sheet in the Format Cells dialog box. Which of the following are valid values for that number?

The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.

When the Paste Options button is visible, you can use ____________________ to access the paste commands available in the Paste Options gallery.

____________________ is the default option that Excel uses to fill an area with the Auto Fill Options menu.

Which of the following are formatting symbols?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Keeps a cell reference constant when copying a formula or function.

Which of the following is an extension of the fill pattern Sunday, Tuesday?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Fills a destination area using the format of the source area; no content is copied.

The incorrect use of copying, deleting, inserting, and moving ranges of cells has the potential to render a worksheet useless.

____________________ are values in cells that can be changed to determine new values for formulas.

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