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

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.

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.

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

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.

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

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

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?

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.