Exam 8: Calculating Data With Formulas and Functions

Which of the following is a Statistical function?

An error value begins with a pound sign (#) followed by an error name that indicates the type of error.

MATCHING -References that are fixed

A mixed reference "locks" one part of the cell reference while the other part can change.

Excel functions are organized into ____ categories.

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 needs to use a lookup function to find an exact match of an inventory item, so she will set the range_lookup value to _______ .

The ____ category of Excel functions retrieves data from multidimensional databases involving online analytical processing.

Another name for the middle value is the ____ value.

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

An error value indicates that some part of a function is preventing Excel from returning a calculated value. ________________

In the formula =INT(AVERAGE(A1:A100)), which would occur first? ____

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

A constant is a value in a formula that doesn't change.

MATCHING -A Statistical function that calculates the middle value of a collection of numbers

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

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

MATCHING -A function inside another function

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

____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.

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