Question

Excel searches for an exact match of the first argument in the first column of the data when the range in the VLOOKUP function is

a. EXACT.

b. TRUE.

c. FALSE.

d. NULL.

The function of Trace Precedents and Trace Dependents is to

a. highlight errors in copying and formula construction.

b. investigate the cell calculations in great detail.

c. ascertain how model parts are segregated.

d. trace the range of cells included in the Watch Window box list.

Answer 1

Excel searches for an exact match of the first argument in the first column of the data when the range in the VLOOKUP function is FALSE

Explanation: While writing VLOOKUP function to get Approximate match we use TRUE as range lookup and for exact match we use FALSE

The function of Trace Precedents and Trace Dependents is to Investigate the cell calculations in great details

Explanation: Trace Precedents and Trace Dependents functions are mainly used to identify which cell will be affected by formula in the current cell