MIS 303 Quiz 11

There are two types of cell reference, ABSOLUTE and RELATIVE. Select the correct notation for an ABSOLUTE cell reference. A7 A A-7 $A$7

$A$7

The cell range that starts in cell A1 and goes over to J15 is WRITTEN AS __________ in a formula. (A1-J15) (A1;J15) (A1:J15) (A1toJ15)

(A1:J15)

The Conditional Formatting function in Excel allows you to: - Automatically apply formatting based on specific rules or conditions being met. - Automatically apply highlighting to selected cell ranges based on specific rules or conditions being met - Automatically change the font of selected cell ranges based on specific rules or conditions being met. - All of the options listed above are correct.

- All of the options listed above are correct.

Suppose cells A2:B20 contain a table with product numbers in column A and product prices in column B. What does the formula =VLOOKUP(A25,A2:B20,2,FALSE) return? - The number for the product in column A if the exact product number corresponding to A25 can be found, or #N/A if not. - The price for the product in column A if the exact product number corresponding to A25 can be found, or #N/A if not. - The price for the product in column A if the exact product number corresponding to A25 can be found, or the price for the closest product if the exact product number can't be found. - Don't know

The price for the product in column A if the exact product number corresponding to A25 can be found, or #N/A if not.

By default, all cells are Relative Cell References within a formula and will update when copied or use of Autofill. True False

True