The following table is used to lookup information on a specific product. The Product ID is entered into cell B2 and the information is returned in the shaded box.There are several formulas in the table. How could I look at the cells that use the value in cell B2? 
A) Select "Trace Dependents" in the Formula Auditing Group on the Formulas tab.
B) Select "Trace Precedents" in the Formula Auditing Group on the Formulas tab.
C) Select "Show Formulas" in the Formula Auditing Group on the Formulas tab.
D) Select "Evaluate Formulas" in the Formula Auditing Group on the Formulas tab.
Correct Answer:
Verified
Q21: The Watch Window is observable
A)only when the
Q24: The SUM function in Excel
A)adds up all
Q25: The VLOOKUP with range set to _
Q32: The function of Trace Precedents and Trace
Q33: The condition that VLOOKUP assumes is that
A)there
Q36: The arguments supplied to the IF function,
Q39: The user can monitor how listed cells
Q41: A company asked one of their analysis
Q42: Anna operates a consignment shop where she
Q43: A company asked one of their analysis
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents