Question 1

With bar charts,you can drag the bar in the chart in one direction or another to change the corresponding value in the worksheet.

Accepted Answer

A) True 
 B)False

Question 2

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 3

The path to the Format Painter button is ____.

Accepted Answer

Question 4

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

Accepted Answer

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

Question 5

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 6

The Copy button copies the contents and format of the source area to the Office ____,a temporary storage area in the computer's memory.

Accepted Answer

A)  Ribbon 
B)  Clipboard 
C)  Folder 
D)  File 
A)  Ribbon 
B)  Clipboard 
C)  Folder 
D)  File

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Determines the value of a cell on which the formula depends.

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 8

The NETWORKDAYS function checks a formula for correctness.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is the path to the Increase or Decrease Indent button?

Accepted Answer

Question 10

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 11

To open the Format Cells dialog box with the Alignment sheet active,tap or click the Alignment Settings ____.

Accepted Answer

A)  button 
B)  check box 
C)  option button 
D)  Dialog Box Launcher 
A)  button 
B)  check box 
C)  option button 
D)  Dialog Box Launcher

Question 12

When you rest the mouse pointer over a chart item,such as the legend,Excel displays a chart tip containing the name of the item.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Indicates a cell is using a name Excel does not recognize.

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 16

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

Question 17

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 18

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

Accepted Answer

A) True 
 B)False

Question 19

If the contents of a cell copied using the fill handle is Sunday and Tuesday,what are the next three values of the extended series?

Accepted Answer

A) Wednesday 
B) Thursday 
C) Saturday 
D) Monday 
A) Wednesday 
B) Thursday 
C) Saturday 
D) Monday

Question 20

When you set up a worksheet,you should use cell references in formulas whenever possible,rather than ____ values.

Accepted Answer

A)  logical 
B)  constant 
C)  consistent 
D)  calculated 
A)  logical 
B)  constant 
C)  consistent 
D)  calculated

With bar charts,you can drag the bar in the chart in one direction or another to change the corresponding value in the worksheet.

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

The path to the Format Painter button is ____.

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

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

The Copy button copies the contents and format of the source area to the Office ____,a temporary storage area in the computer's memory.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Determines the value of a cell on which the formula depends.

The NETWORKDAYS function checks a formula for correctness.

Which of the following is the path to the Increase or Decrease Indent button?

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.

To open the Format Cells dialog box with the Alignment sheet active,tap or click the Alignment Settings ____.

When you rest the mouse pointer over a chart item,such as the legend,Excel displays a chart tip containing the name of the item.

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicates a cell is using a name Excel does not recognize.

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

Which of the following are formatting symbols?

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

If the contents of a cell copied using the fill handle is Sunday and Tuesday,what are the next three values of the extended series?

When you set up a worksheet,you should use cell references in formulas whenever possible,rather than ____ values.

Creating a Worksheet and a Chart

Formulas,Functions,and Formatting

Financial Functions,Data Tables,and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating,sorting,and Querying a Table

Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots

Office 2013 and Windows 8 Essential Concepts and Skills

Filters

Exam 3: Working With Large Worksheets,Charting,and What-If Analysis

With bar charts,you can drag the bar in the chart in one direction or another to change the corresponding value in the worksheet.

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

The path to the Format Painter button is ____.

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

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

The Copy button copies the contents and format of the source area to the Office ____,a temporary storage area in the computer's memory.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Determines the value of a cell on which the formula depends.

The NETWORKDAYS function checks a formula for correctness.

Which of the following is the path to the Increase or Decrease Indent button?

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.

To open the Format Cells dialog box with the Alignment sheet active,tap or click the Alignment Settings ____.

When you rest the mouse pointer over a chart item,such as the legend,Excel displays a chart tip containing the name of the item.

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicates a cell is using a name Excel does not recognize.

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

Which of the following are formatting symbols?

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

If the contents of a cell copied using the fill handle is Sunday and Tuesday,what are the next three values of the extended series?

When you set up a worksheet,you should use cell references in formulas whenever possible,rather than ____ values.

Creating a Worksheet and a Chart

Formulas,Functions,and Formatting

Financial Functions,Data Tables,and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating,sorting,and Querying a Table

Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots

Office 2013 and Windows 8 Essential Concepts and Skills

Filters