Exam 8: Working With Advanced Functions

In a fully qualified structured reference,the table name $\underline {\text { follows } }$ the column qualifier._________________________

The _____ function is a logical function that returns a TRUE value if any of the logical conditions are true and a FALSE value if all the logical conditions are FALSE.

The following formula is used to determine Dean's List status: =AND(B1>=12,B2>3.25).Use the information provided to evaluate the formula. -Assuming that B1 contains 15 and B2 contains 3.5,then _______.

The ORERROR function can determine if a cell contains an error value and then display the message you choose.

A(n)____________________ specifies the type of condition,the type of formatting when that condition occurs,and the cell or range the formatting is applied to.

The ____________________ function calculates the difference between two dates and shows the result in months,days,or years.

You have been using a variety of nested IF functions to calculate costs in your spreadsheet when a colleague stops by and comments on what you have been working on, suggesting that there is an easier approach to use. -Which of the following is an effective alternative for the use of extensive nested IF functions?

Lookup _____ allow you to use tables of data to "look up" values and insert them in another worksheet location.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Searches down the first column of the lookup table

_____ just above the header row of an Excel table to select the column data but not the header.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Searches across the first row of the lookup table

The _____ function calculates the number of cells in a range that match criteria you specify.

If a formula is in a calculated table column,you need to make a change in only one cell and the change will automatically be copied to all the cells in the column.

When Excel automatically fills the rest of a table column with a formula entered into an empty table column,this is referred to as a(n)_____ column.

-According to the dialog box in the accompanying figure,the column in the MedicalRates lookup table that stores the value to be returned is the first column.

$\underline {\text { Duplicate } }$ value highlighting helps to verify that columns of data have unique entries._________________________

In the DATEDIF function,the first date argument is the $\underline {\text { latest } }$ date._________________________

The COUNTAS function counts the number of cells within a range that meet multiple criteria.

For conditional formatting,a formula must be in the form of a(n)_____ test that results in a true or false value.

-According to the dialog box in the accompanying figure,the MedicalRates table is the one from which the data in your funtion argument will be obtained.