Exam 8: Working With Advanced Functions

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

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.

The ____________________ function is used to change the orientation of a range-that is,return a vertical range of cells as a horizontal range,or vice versa.

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

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

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. -Which of the following is an effective alternative for the use of extensive nested IF functions? 

The major difference between HLOOKUP and VLOOKUP functions is the way the lookup tables are _____.

The 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._________________________

The _____ function is a logical function that evaluates a condition and then returns one value if the condition is true and another value if the condition is false.

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

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

Nesting IF functions will allow for three or more outcomes.

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

You can calculate the number of cells in a range that match criteria you specify using the SUMIF function._________________________

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

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. -If you omit the range_lookup value from a LOOKUP function,which of the following is true? 

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

You can edit existing conditional formatting rules from the Conditional Formatting _____ dialog box.Click the Edit Rule button and make the appropriate changes.

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.

Case 8-1 Evaluate the formula =AND(G2="FT",M2>=1)based upon the information provided. -What value is returned assuming that G2 contains the value PT and M2 contains the value 2?