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
Q22: The _ button, located in the Formula
Q23: The _ function pairs each element of
Q24: The SUM function in Excel
A)adds up all
Q25: The VLOOKUP with range set to _
Q26: The _ button in the Formula Auditing
Q28: With reference to the SUMPRODUCT function, which
Q29: The _ function allows the user to
Q30: The calculations of a cell can be
Q31: The user can monitor how listed cells
Q32: The function of Trace Precedents and Trace
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