Exam 8: Working With Advanced Functions

To retrieve a particular value from a lookup table,a(n)____________________ needs to match the compare values.

When you create a formula that references all or parts of an Excel table,you can replace the specific cell or range address with a(n)____________________ reference,the actual table name or column header.

When using VLOOKUP,the _____argument is optional.

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

An error value begins with a(n)_____ followed by an error name that indicates the type of error.

In most cases,when manually creating a conditional formatting formula,the formula should use $\underline {\text { absolute } }$ references and point to the first row of data in a table._________________________

The IF function evaluates a(n) $\underline { \text { single } }$ condition._________________________

To get the effect of a calculated column in a range of data,you must copy and paste the formula or use the _____ feature.

If you are creating a calculated column or formula within an Excel table,you can use the _____ structured reference in the formula.

You can use _____ to reference cells within an Excel table.

What are the guidelines to keep in mind when creating fields in an Excel table?

The _____ error value means that a value is not available to a function or formula.

Two common categories of formula errors in Excel are syntax errors and logic errors.

The ____________________ function can determine if a cell contains an error value and displays the message you choose rather than the default error value.

To change the background fill color of duplicate values,in the _____ group on the HOME tab,click the Conditional Formatting button,and then click Manage Rules.

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 12 and B2 contains 3.25,then _____.

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

You can calculate the number of cells in a range that match criteria you specify using the $\underline {\text { SUMIF }}$ function._________________________

In the Edit Formatting Rule dialog box,click the _____ button to open the Format Cells dialog box.

The $\underline {\text { VLOOKUP } }$ function searches vertically down the first column of the lookup table for the value you entered,and then retrieves the corresponding value from another column of the table._________________________