Exam 8: Excel Module Performing Calculations With Formulas and Functions

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

TODAY is an example of a(n) ____________________ function.

A lookup table organizes numbers or text into categories.

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

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.

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 automate the trial-and-error process by allowing her to specify a value for a calculated item, which Excel uses to determine the input value needed to reach that goal. She can use ______.

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

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

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 wants to find out what her median monthly spending is. The monthly totals for her spending appear in the range A10:L10. Which of the following is NOT a way to enter the MEDIAN function into her database?

One way to perform a _________ is by changing one or more of the input values  to see how they affect the calculated results.

The ____________________ is the middle value from a sample.

In the following formula: =IF(A1="YES", "DONE", "RESTART"), what happens if A1= "NO"? _____

____ arguments may provide more control over the returned value.

An argument can be any type of value including text, numbers, cell references, or even other formulas or functions.