Question 1

The ____ function returns the maximum value in the range.

Accepted Answer

A)  TOP 
B)  FIRST 
C)  MAX 
D)  MOST

Question 2

Excel functions are organized into ____ categories.

Accepted Answer

A)  8 
B)  10 
C)  11 
D)  13

Question 3

An error value begins with a pound sign (#)followed by an error name that indicates the type of error._______________

Accepted Answer

A) True 
 B)False

Question 4

Case 3-2
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 2016 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 5

Case 3-2
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 2016 Analysis tools
-Susan needs to use a lookup function to find an exact match of an inventory item,so she will set the range_lookup value to _______ .

Accepted Answer

A)  EXACT 
B)  1 
C)  TRUE 
D)  FALSE

Question 6

A trial-and-error method lets you explore the impact that changing input values has on the calculated values in the workbook._________________________

Accepted Answer

A) True 
 B)False

Question 7

Absolute references are marked with a ____.

Accepted Answer

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

Question 8

A lookup table organizes numbers or text into categories._____________

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

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

Question 10

=ROUND(AVERAGE(A1:A100),2)is an example of a(n)____ function.

Accepted Answer

A)  complex 
B)  logical 
C)  absolute 
D)  nested

Question 11

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 12

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 13

Optional arguments are always placed first in the argument list._______________

Accepted Answer

A) True 
 B)False

Question 14

A mixed reference "locks" one part of the cell reference while the other part can change._______________

Accepted Answer

A) True 
 B)False

Question 15

The statement "A1 >= B1" tests whether the value in cell A1 is lesser than or equal to the value in cell B1._________________________

Accepted Answer

A) True 
 B)False

Exam 3: Performing Calculations With Formulas and Functions

The ____ function returns the maximum value in the range.

Excel functions are organized into ____ categories.

An error value begins with a pound sign (#)followed by an error name that indicates the type of error._______________

A trial-and-error method lets you explore the impact that changing input values has on the calculated values in the workbook._________________________

Absolute references are marked with a ____.

A lookup table organizes numbers or text into categories._____________

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

=ROUND(AVERAGE(A1:A100) ,2) is an example of a(n) ____ function.

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

When you nest functions,you should have ____.

Optional arguments are always placed first in the argument list._______________

A mixed reference "locks" one part of the cell reference while the other part can change._______________

The statement "A1 >= B1" tests whether the value in cell A1 is lesser than or equal to the value in cell B1._________________________