Exam 8: Calculating Data With Formulas and Functions

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

The IF function is a logical function that returns one value if a condition is true, and returns a different value if that condition is false.

Functions can also be ____________________ or placed inside another function.

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

Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references?

-Referring to the figure above, which number represents the COUNT function?

MATCHING -Contains both relative and absolute references.

One challenge of nesting functions is to make sure that you include all of the parentheses.

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

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

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

Use ____ references when you want different formulas to refer to the same cell.

MATCHING -Indicate that some part of formula is preventing Excel from returning a calculated value.

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

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 2013. 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?

______ functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas.

The ____ function returns the maximum value in the range.

The Insert Function button is in the ____ group.

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.

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