Lesson 11

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

A

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? a. The number for the product in column A if the exact product number corresponding to A25 can be found, or #N/A if not. b. The price for the product in column A if the exact product number corresponding to A25 can be found, or #N/A if not. c. 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. d. Don't know

B

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

C

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

D

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

D