Question 1

=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 2

Case 3-1
Ellen is a recent college graduate. She has decided to open a T-Shirt business and would like to create budget worksheet using Microsoft Excel 2016. She need to keep track of her expenses and income for the year.
-Ellen's spending varies from month to month. She wants to calculate the total  expenses for each month. She wants to see all of the arguments associated with the SUM function so she clicks the ____ then clicks SUM to open the Function Arguments dialog box.

Accepted Answer

A)  Math & Trig button in the Formula group 
B)  Math & Trig button in the Function Library group 
C)  Financial button in the Formula group 
D)  Financial button in the Function Library group

Question 3

In "SUM( number1 [, number2 , number3 , ...])", number 1, number 2, and number 3 may be numbers or ____.

Accepted Answer

A)  letters 
B)  cell references 
C)  symbols 
D)  operators

Question 4

The ____________________ organizes all of the functions by category and allows you to search for functions that perform particular calculations.

Accepted Answer

The answer of The ____________________ organizes all of the functions...

Question 5

FUNCTION ( argument1 , argument2 , ...) is ____.

Accepted Answer

A)  the syntax of writing optional arguments 
B)  an example of a formula 
C)  the general syntax of all functions 
D)  the general syntax of all formulas

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

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 8

Which of the following is a Statistical function? _____

Accepted Answer

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

Question 9

Another name for the middle value is the ____ value.

Accepted Answer

A)  mode 
B)  center 
C)  median 
D)  relative

Question 10

Some cell references are called ____________________ references because they are always interpreted in relation to the location of the cell containing the formula.

Accepted Answer

The answer of Some cell references are called ____________________ references...

Question 11

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 designs a worksheet with the inventory number, description, quantity, unit cost, reorder point and value.  To find values in tables of data, and insert them in another location in the worksheet such as cells or in formulas, she will use ________.

Accepted Answer

A)  Max function 
B)  Lookup function 
C)  CountA function 
D)  Sum function

Question 12

Which category of Excel functions returns information about the format, location, or contents of worksheet cells? ____

Accepted Answer

A)  Location 
B)  Information 
C)  Reference 
D)  Description

Question 13

In the formula =IF(A1=B1, C1, C2), the result will be C2 if ____.

Accepted Answer

A)  A is equal to B 
B)  A does not equal B 
C)  A1+B1 is equal to C1 
D)  A1>B1 is equal to C2

Question 14

Functions are organized in the Function Library group on the FORMULAS tab.

Accepted Answer

A) True 
 B)False

Question 15

The WORKDAY function displays the date of the weekday a specific number of weekdays past a starting date.

Accepted Answer

A) True 
 B)False

Question 16

A logical function is a function that works with values that are either ____.

Accepted Answer

A)  right or wrong 
B)  absolute or relative 
C)  positive or negative 
D)  true or false

Question 17

Case 3-1
Ellen is a recent college graduate. She has decided to open a T-Shirt business and would like to create budget worksheet using Microsoft Excel 2016. She need to keep track of her expenses and income for the year.
-Ellen is expecting to get a 3% raise next year.  She enters .03 in cell D2 so that she can predict her monthly income for the next year. What function key will make D2 an absolute reference?

Accepted Answer

A)  F2 
B)  F4 
C)  F6 
D)  F1

Question 18

If the VLOOKUP function cannot find the lookup value, the _________ error value is displayed in the cell.

Accepted Answer

A)  #VALUE 
B)  #N/A 
C)  #ERROR 
D)  #NULL

Question 19

One of the great advantages of ____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations.

Accepted Answer

A)  cell 
B)  relative 
C)  absolute 
D)  formula

Question 20

When a formula includes a cell reference, Excel interprets that cell reference as being located relative to the position of the current cell.

Accepted Answer

A) True 
 B)False

Exam 8: Excel Module Performing Calculations With Formulas and Functions

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

In "SUM( number1 [, number2 , number3 , ...]) ", number 1, number 2, and number 3 may be numbers or ____.

The ____________________ organizes all of the functions by category and allows you to search for functions that perform particular calculations.

FUNCTION ( argument1 , argument2 , ...) is ____.

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

Which of the following is a Statistical function? _____

Another name for the middle value is the ____ value.

Some cell references are called ____________________ references because they are always interpreted in relation to the location of the cell containing the formula.

Which category of Excel functions returns information about the format, location, or contents of worksheet cells? ____

In the formula =IF(A1=B1, C1, C2) , the result will be C2 if ____.

Functions are organized in the Function Library group on the FORMULAS tab.

The WORKDAY function displays the date of the weekday a specific number of weekdays past a starting date.

A logical function is a function that works with values that are either ____.

If the VLOOKUP function cannot find the lookup value, the _________ error value is displayed in the cell.

One of the great advantages of ____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations.

When a formula includes a cell reference, Excel interprets that cell reference as being located relative to the position of the current cell.