Exam 19: Excel: Formulas and Functions: Performing Quantitative Analysis

A function in Excel must begin with a plus sign (+).

The ________ is the lowest value in a category of a lookup table.

The ________ key toggles between relative,absolute,and mixed references.

What are the rules for creating range names?

The TODAY and the NOW functions display the date and time that a workbook was last opened or last calculated.

A relative cell reference:

The logical test:

A(n)________ function occurs when one function is embedded as an argument within another function.

The =________(serial_number)function displays the day within a given month for a date or its serial number.

To simplify entering ranges in formulas you can use:

An absolute cell reference:

Excel provides three basic count functions: COUNT,COUNTA,and ________.

The breakpoint:

Which of the following is NOT one of Excel's three basic count functions?

________ references usually cause inaccurate results.

The PMT function uses ________ required arguments and up to two optional arguments.

Which of the following is a new feature in Excel 2013?

How does a nested function work? Provide an example.

The logical test evaluates true or false.