Exam 8: Excell: Working With Advanced Functions

If you need to modify the formula in a calculated column, you edit the formula in one cell of the column and then you modify the formulas in the remaining cells in that table column.

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

Case-Based Critical Thinking Questions Case 8-4 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 _____.

If you edit a cell in a calculated column so it is no longer consistent with the other formulas in the column, a _____ appears in the upper-left corner of the cell.

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

The _____ function searches vertically down the first column of the lookup table.

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.

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.

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

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

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

The _____ function calculates the average of values in a range that match criteria you specify.

Each time you create a conditional format, you are defining a conditional formatting _____.

If you see _____ as the result of a VLOOKUP formula, you might have entered a letter for the col_index_num instead of a number.

All the logical conditions listed in an AND function must be true for the AND function to return a TRUE value.

An error value begins with a(n) number sign followed by an error name, which indicates the type of error.

You can _____ IF functions to allow for three or more outcomes.

Case-Based Critical Thinking Questions 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?

The _____ function adds the values in a range that match criteria you specify.