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? 8 10 11 12 13 ID 14 15 16 17 18 19 20 21 22 23 A Product ID 3563 3564 3565 3571 3572 3573 3575 3576 3577 3578 Product Manfucaturer: Price: In Stock: On Order: Reorder Level Value of Investory Value on Order: Average corder Cesti 3571 K N a K K R G K G R с $108.64 32.48 0 0 $3,52863 $0.00 $162.40 Product Manufacturer Unit Price In Stock On Order 43.68 20.16 21.28 19.04 11.2 14.56 108.64 32.48 34.72 34.72 23.52 24.64 6.72 D 26.04 17.36 19.544 26.88 39.2 E 43.68 32.48 0 44.8 78.4 0 0 33.6 0 0 0 0 Recrder level 11.2 28 28 0 0 33.6 5.6 O 5.6 11.2 O a. Select "Trace Precedents" in the Formula Auditing Group on the Formulas tab. O b. Select "Trace Dependents" in the Formula Auditing Group on the Formulas tab. O c. Select "Show Formulas" in the Formula Auditing Group on the Formulas tab. O d. Select "Evaluate Formulas" in the Formula Auditing Group on the Formulas tab.
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? 8 10 11 12 13 ID 14 15 16 17 18 19 20 21 22 23 A Product ID 3563 3564 3565 3571 3572 3573 3575 3576 3577 3578 Product Manfucaturer: Price: In Stock: On Order: Reorder Level Value of Investory Value on Order: Average corder Cesti 3571 K N a K K R G K G R с $108.64 32.48 0 0 $3,52863 $0.00 $162.40 Product Manufacturer Unit Price In Stock On Order 43.68 20.16 21.28 19.04 11.2 14.56 108.64 32.48 34.72 34.72 23.52 24.64 6.72 D 26.04 17.36 19.544 26.88 39.2 E 43.68 32.48 0 44.8 78.4 0 0 33.6 0 0 0 0 Recrder level 11.2 28 28 0 0 33.6 5.6 O 5.6 11.2 O a. Select "Trace Precedents" in the Formula Auditing Group on the Formulas tab. O b. Select "Trace Dependents" in the Formula Auditing Group on the Formulas tab. O c. Select "Show Formulas" in the Formula Auditing Group on the Formulas tab. O d. Select "Evaluate Formulas" in the Formula Auditing Group on the Formulas tab.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question

Transcribed Image Text:QUESTION 19
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?
1
2 Product ID:
3
4
5
6
7
8
9
10
11
12
13 ID
14
15
16
17
18
19
20
A
21
22
23
3563
3564
3565
3571
3572
3573
3575
3576
3577
3578
B
Product Manfucaturer:
Price
In Stock:
On Order:
Reorder Level:
Value of Inventory:
Value on Order:
Average Reorder Cest:
Product Manufacturer
K
N
a
K
3571
K
R
K
R
$108.64
32.48
0
0
Unit Price
$3,528.63
$0.00
$162.40 www.
20.16
21.28
11.2
108.64
34.72
D
23.52
6.72
In Stock
43.68
19.04
14.56
32.48
34.72
24.64
26.88
39.2
26.04
17.36 43.68
19.544
32.48
E
On Order
0
44.8
78.4
0
0
33.6
0
0
0
0
Recrder Level
11.2
28
28
0
0
33.6
5.6
0
5.6
11.2
O a. Select "Trace Precedents" in the Formula Auditing Group on the Formulas
O b. Select "Trace Dependents" in the Formula Auditing Group on the Formulas tab.
O c. Select "Show Formulas" in the Formula Auditing Group on the Formulas tab.
O d. Select "Evaluate Formulas" in the Formula Auditing Group on the Formulas tab.
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON

Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education