Exam 9: Performing Calculations With Formulas and Functions

A lookup table organizes numbers or text into categories._____________

The Insert Function button is in the ____ group.

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

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.

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

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

A(n)____________________ function is a function that works with statements that are either true or false.

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?

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

Using the AutoFill Options button,the Fill Without Formatting option copies the ____ but not the formatting.

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

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

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

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

When you nest functions,you should have ____.

After you describe a function in the Search for a function box in the Insert Function dialog box,click ____.

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

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.

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