Question 1

Susan is in charge of the inventory reports for her company. She will need to find specific inventory items as well as project increases in inventory costs. To get ready she will create a worksheet and use the Microsoft Excel 2013 Analysis tools.
-Susan wants to make some changes to the worksheet to explore the impact that changing input values has on the calculated values in the worksheet.She can use ______.

Accepted Answer

A) Lookup Analysis 
B) What-If Analysis 
C) IF conditions 
D) nested OR conditions

Question 2

The ____ category of Excel functions returns (true-false)values

Accepted Answer

A) Information 
B) Statistical 
C) Logical 
D) Math & Trig

Question 3

A $\underline {  \text { lookup table }  }$ organizes numbers or text into categories._____________

Accepted Answer

A) True 
 B)False

Question 4

The Insert Function button is in the ____ group.

Accepted Answer

A) Calculation 
B) Function Library 
C) Sort & Filter 
D) Home

Question 5

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Indicate that some part of formula is preventing Excel from returning a calculated value.

Accepted Answer

A) NOW 
B) error value 
C) COUNTA 
D) < 
E) MEDIAN
F)Mon, Tues, Wed, Thurs, Fri
G)F4
H)absolute
I)nested
J)mixed

Question 6

An ___________________ occurs when the lookup value falls within a range of numbers in the first column of the lookup table.

Accepted Answer

The answer of An ___________________ occurs when the lookup value...

Question 7

Not all functions have arguments,and some functions have ____________________ arguments,which are not required for the function to return a value,but can be included to provide more control over the returned value.

Accepted Answer

The answer of Not all functions have arguments,and some functions...

Question 8

If an optional argument is not included,Excel assumes a(n)____ value for it.

Accepted Answer

A) default 
B) generic 
C) static 
D) absolute

Question 9

Absolute references are marked with a ____.

Accepted Answer

A) < 
B) : 
C) $ 
D) !

Question 10

The Insert Function dialog box has a(n)____ option.

Accepted Answer

A) search 
B) formatting 
C) find and replace 
D) expand/collapse

Question 11

-Referring to the figure above,the last entry shown in Column K is 644.7953813. There is an icon in the cell underneath the 644.7953813 which is the ____.

Accepted Answer

A) fill handle 
B) Auto Fill Options button 
C) formula finder 
D) function finder

Question 12

Which of the following is a Statistical function?

Accepted Answer

A) INT 
B) RAND 
C) ROUND 
D) AVERAGE

Question 13

Using AutoFill,what would be the extended series of the initial entry Jan? ___

Accepted Answer

A) uary 
B) Feb, Mar, Apr 
C) Kan, Lan, Man, Nan 
D) Jan1, Jan2, Jan3,

Question 14

The numbers,text,or cell references used by the function to return a value are called ____.

Accepted Answer

A) expressions 
B) arguments 
C) data 
D) values

Question 15

=IF(G22= "x ",SUM(H22:J22), " ")with display ______ if G22 is not equal to "x".

Accepted Answer

A) a blank cell 
B) the result of the SUM 
C) dashes 
D) False

Question 16

When you nest functions,you should have ____.

Accepted Answer

A) the equal sign 
B) the same number of left and right parentheses 
C) at least two functions 
D) the correct number of brackets

Question 17

Goal Seek automates the trial-and-error process by allowing you to specify a value for
a calculated item,which Excel uses to determine the input value needed to reach that
goal._________________________

Accepted Answer

A) True 
 B)False

Question 18

A(n)____________________ reference contains both relative and absolute references.

Accepted Answer

The answer of A(n)____________________ reference contains both relative and absolute...

Question 19

-Referring to the figure above,the last entry shown in Column K is 644.7953813. There is a black "plus sign" on the lower right edge of the cell that is the ____.

Accepted Answer

A) fill handle 
B) Auto Fill Options button 
C) formula finder 
D) function finder

Question 20

The fill handle copies ____.

Accepted Answer

A) content only 
B) formats only 
C) content and formats 
D) formats and cell references

Exam 3: Calculating Data With Formulas and Functions

The ____ category of Excel functions returns (true-false) values

A $\underline { \text { lookup table } }$ organizes numbers or text into categories._____________

The Insert Function button is in the ____ group.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicate that some part of formula is preventing Excel from returning a calculated value.

An ___________________ occurs when the lookup value falls within a range of numbers in the first column of the lookup table.

Not all functions have arguments,and some functions have ____________________ arguments,which are not required for the function to return a value,but can be included to provide more control over the returned value.

If an optional argument is not included,Excel assumes a(n) ____ value for it.

Absolute references are marked with a ____.

The Insert Function dialog box has a(n) ____ option.

-Referring to the figure above,the last entry shown in Column K is 644.7953813. There is an icon in the cell underneath the 644.7953813 which is the ____.

Which of the following is a Statistical function?

Using AutoFill,what would be the extended series of the initial entry Jan? ___

The numbers,text,or cell references used by the function to return a value are called ____.

=IF(G22= "x ",SUM(H22:J22) , " ") with display ______ if G22 is not equal to "x".

When you nest functions,you should have ____.

Goal Seek automates the trial-and-error process by allowing you to specify a value for a calculated item,which Excel uses to determine the input value needed to reach that goal._________________________

A(n)____________________ reference contains both relative and absolute references.

-Referring to the figure above,the last entry shown in Column K is 644.7953813. There is a black "plus sign" on the lower right edge of the cell that is the ____.

The fill handle copies ____.

Exam 3: Calculating Data With Formulas and Functions

The ____ category of Excel functions returns (true-false) values

A lookup table ‾\underline { \text { lookup table } } lookup table ​ organizes numbers or text into categories._____________

The Insert Function button is in the ____ group.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicate that some part of formula is preventing Excel from returning a calculated value.

An ___________________ occurs when the lookup value falls within a range of numbers in the first column of the lookup table.

Not all functions have arguments,and some functions have ____________________ arguments,which are not required for the function to return a value,but can be included to provide more control over the returned value.

If an optional argument is not included,Excel assumes a(n) ____ value for it.

Absolute references are marked with a ____.

The Insert Function dialog box has a(n) ____ option.

-Referring to the figure above,the last entry shown in Column K is 644.7953813. There is an icon in the cell underneath the 644.7953813 which is the ____.

Which of the following is a Statistical function?

Using AutoFill,what would be the extended series of the initial entry Jan? ___

The numbers,text,or cell references used by the function to return a value are called ____.

=IF(G22= "x ",SUM(H22:J22) , " ") with display ______ if G22 is not equal to "x".

When you nest functions,you should have ____.

Goal Seek automates the trial-and-error process by allowing you to specify a value for a calculated item,which Excel uses to determine the input value needed to reach that goal._________________________

A(n)____________________ reference contains both relative and absolute references.

-Referring to the figure above,the last entry shown in Column K is 644.7953813. There is a black "plus sign" on the lower right edge of the cell that is the ____.

The fill handle copies ____.

A $\underline { \text { lookup table } }$ organizes numbers or text into categories._____________