Exam 8: Working With Advanced Functions

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.

_____ references make it easier to create formulas that use portions or all of an Excel table because the names of headers are usually simpler to identify than cell addresses.

Duplicate value highlighting helps to verify that columns of data have unique entries._________________________

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.

Case 8-3 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. -You implement the VLOOKUP formula at your colleague's suggestion,but you get the #VALUE! error as the result of the formula.Which of the following is likely true? 

When you want to reference an entire column of data in a table,you create a column _____.

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.

When you create a calculated column,you can use _____ references to create the formula.

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

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.

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

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

When using VLOOKUP,the _____argument is optional.

Using the VLOOKUP function,an exact match lookup occurs when the value entered must match one of the values in _____ of the lookup table.