Exam 3: Calculating Data With Formulas and Functions

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

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

A $\underline { \text { lookup table } }$ organizes numbers or text into categories._____________

The Insert Function button is in the ____ group.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicate that some part of formula is preventing Excel from returning a calculated value.

An ___________________ occurs when the lookup value falls within a range of numbers in the first column of the lookup table.

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.

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

Absolute references are marked with a ____.

The Insert Function dialog box has a(n)____ option.

-Referring to the figure above,the last entry shown in Column K is 644.7953813. There is an icon in the cell underneath the 644.7953813 which is the ____.

Which of the following is a Statistical function?

Using AutoFill,what would be the extended series of the initial entry Jan? ___

The numbers,text,or cell references used by the function to return a value are called ____.

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

When you nest functions,you should have ____.

Goal Seek 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._________________________

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

-Referring to the figure above,the last entry shown in Column K is 644.7953813. There is a black "plus sign" on the lower right edge of the cell that is the ____.

The fill handle copies ____.