10. Min Jee wants to combine the sales data from each of the art fairs. Switch...
Fantastic news! We've Found the answer you've been seeking!
Transcribed Image Text:
10. Min Jee wants to combine the sales data from each of the art fairs. Switch to the Combined Sales worksheet, and then update the worksheet as follows: In cell A5, enter a formula without using a function that references cell A5 in the Madison worksheet. a. b. Copy the formula from cell A5 to the range A6:A8 without copying the formatting. In cell B5, enter a formula using the SUM function, 3-D references, and grouped worksheets that totals the values from cell B5 in the Chicago:Madison C. worksheets. d. Copy the formula from cell B5 to the range B6:B8 without copying the formatting. Copy the formulas and the formatting from the range B5:B8 to the range C5:E8. (Hint: You can ignore the error about empty cells because Min Jee will enter the Madison sales data later.) e. Ceramits A5 H B Art Fairs 2. Chicago 2021 3 QI Q2 Q3 Q4 Total S Ceramics %24 724.35 $ 1,115.80 $ 845.00 %24 3,297.65 %24 612.50 6 Fiber %24 586.70 %24 803.45 %24 1,222.75 $ 934.50 3,547.40 7 Glass %24 657.85 $ 698.75 1,205.15 %24 1,435.25 $ 3,997.00 8 Stone $ 605.65 $ 656.80 $ 760.75 $ 1,093.45 %24 3,116.65 9 Total Sales 24 2,462.70 $ 2,883.35 $ 4,304.45 %24 4,308.20 $ 13,958.70 10 %3D 12 13 14 IS 16 17 18 19 Documentation Art Fairs Chicago St. Lous Minneapolis Madison Combined Sales A D. H. Art Fairs 2. St. Louis 2021 3. 4. QI Q2 Q3 Q4 Total 5 Ceramics %24 644.50 %24 733.30 %24 1,105.50 %24 825.25 $ 3,308.55 6 Fiber %24 516,70 %24 801.15 %24 1,242.15 $ 913.15 $ 3,473.15 7 Glass %24 607.95 628.95 1,185.75 $ 1,385.20 $ 3,807.85 8 Stone 710.65 696.95 %24 785.75 %24 1,143.35 $ 3,336.70 9 Total Sales 2,479.80 $ 2,860.35 $ 4,319.15 $ 4,266.95 $ 13,926.25 10 12 13 14 15 16 17 18 19 Documentation Art Fairs Chicago St. Louis Minneapolis Madison Combined Sales Ready D Art Fairs 2. Minneapolis 202I 3. 4 QI Q2 Q3 Q4 Total 5 Ceramics 6 Fiber 24 544.50 %24 740.30 $ 1,135.55 $ 885.50 3,305.85 $4 516.40 781.15 $ 1,278.15 $ 933.75 %$4 3,509.45 7 Glass 707.05 658.15 $ 1,155.50 %24 1,385.20 3,905.90 8 Stone 725.65 762.95 $4 725.25 $ 943.65 3,157.50 9 Total Sales 2,493.60 2,942.55 $ 4,294.45 4,148.10 $ 13,878.70 10 12 13 14 15 16 17 18 19 Documentation Art Fairs Chicago St. Louis Minheapolis Madisan Combined Sales Ready C D Art Fairs 3. 2. Madison 2021 3. 4. QI Q2 Q3 Q4 Total 5 Ceramics 6 Fiber 7 Glass %$4 %24 8 Stone 9 Total Sales 10 12 13 14 15 16 17 18 19 Art Fairs St. Louis Minneapolis Madisc Combined Sales Documentation Chicago Ready B D. H. Art Fairs 2. Combined Sales 2021 3. 4. QI Q2 Q3 Q4 Total 2020 Total $0 6. $0 7. $0 8. $0 9 Total sales $0 $0 $0 $0 $0 10 %3D 12 13 14 15 16 17 18 19 Documentation Art Fairs Chicago St. Louis Minneapolis Madison Combined Sales Ready 10. Min Jee wants to combine the sales data from each of the art fairs. Switch to the Combined Sales worksheet, and then update the worksheet as follows: In cell A5, enter a formula without using a function that references cell A5 in the Madison worksheet. a. b. Copy the formula from cell A5 to the range A6:A8 without copying the formatting. In cell B5, enter a formula using the SUM function, 3-D references, and grouped worksheets that totals the values from cell B5 in the Chicago:Madison C. worksheets. d. Copy the formula from cell B5 to the range B6:B8 without copying the formatting. Copy the formulas and the formatting from the range B5:B8 to the range C5:E8. (Hint: You can ignore the error about empty cells because Min Jee will enter the Madison sales data later.) e. Ceramits A5 H B Art Fairs 2. Chicago 2021 3 QI Q2 Q3 Q4 Total S Ceramics %24 724.35 $ 1,115.80 $ 845.00 %24 3,297.65 %24 612.50 6 Fiber %24 586.70 %24 803.45 %24 1,222.75 $ 934.50 3,547.40 7 Glass %24 657.85 $ 698.75 1,205.15 %24 1,435.25 $ 3,997.00 8 Stone $ 605.65 $ 656.80 $ 760.75 $ 1,093.45 %24 3,116.65 9 Total Sales 24 2,462.70 $ 2,883.35 $ 4,304.45 %24 4,308.20 $ 13,958.70 10 %3D 12 13 14 IS 16 17 18 19 Documentation Art Fairs Chicago St. Lous Minneapolis Madison Combined Sales A D. H. Art Fairs 2. St. Louis 2021 3. 4. QI Q2 Q3 Q4 Total 5 Ceramics %24 644.50 %24 733.30 %24 1,105.50 %24 825.25 $ 3,308.55 6 Fiber %24 516,70 %24 801.15 %24 1,242.15 $ 913.15 $ 3,473.15 7 Glass %24 607.95 628.95 1,185.75 $ 1,385.20 $ 3,807.85 8 Stone 710.65 696.95 %24 785.75 %24 1,143.35 $ 3,336.70 9 Total Sales 2,479.80 $ 2,860.35 $ 4,319.15 $ 4,266.95 $ 13,926.25 10 12 13 14 15 16 17 18 19 Documentation Art Fairs Chicago St. Louis Minneapolis Madison Combined Sales Ready D Art Fairs 2. Minneapolis 202I 3. 4 QI Q2 Q3 Q4 Total 5 Ceramics 6 Fiber 24 544.50 %24 740.30 $ 1,135.55 $ 885.50 3,305.85 $4 516.40 781.15 $ 1,278.15 $ 933.75 %$4 3,509.45 7 Glass 707.05 658.15 $ 1,155.50 %24 1,385.20 3,905.90 8 Stone 725.65 762.95 $4 725.25 $ 943.65 3,157.50 9 Total Sales 2,493.60 2,942.55 $ 4,294.45 4,148.10 $ 13,878.70 10 12 13 14 15 16 17 18 19 Documentation Art Fairs Chicago St. Louis Minheapolis Madisan Combined Sales Ready C D Art Fairs 3. 2. Madison 2021 3. 4. QI Q2 Q3 Q4 Total 5 Ceramics 6 Fiber 7 Glass %$4 %24 8 Stone 9 Total Sales 10 12 13 14 15 16 17 18 19 Art Fairs St. Louis Minneapolis Madisc Combined Sales Documentation Chicago Ready B D. H. Art Fairs 2. Combined Sales 2021 3. 4. QI Q2 Q3 Q4 Total 2020 Total $0 6. $0 7. $0 8. $0 9 Total sales $0 $0 $0 $0 $0 10 %3D 12 13 14 15 16 17 18 19 Documentation Art Fairs Chicago St. Louis Minneapolis Madison Combined Sales Ready
Expert Answer:
Answer rating: 100% (QA)
a Enter the formula MadisonA5 in Combined Sales cel... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Determine CPI, ETC (1), and EAC. Activity Total PV 1 2 3 4 5 6 7 8 9 10 11 12 13 14 1 6 6 2 20 10 10 3 30 9 6 6 6 3 4 20 8 2 5 5 5 16 4 4 4 4 6 18 9 9 7 8 4 4 Status Report: Ending Period 5 Task %...
-
(1) Given A and i. (1a) Find the equivalent amount at the end of year 1. (1b) Find the equilvalent amount at the end of year B. (2) Given X and i, Find the annual equivalent A from year S to 8. *...
-
1. [10] Let A = 2 4 a b c d e f g h i 3 5, B = 2 4 d + 5g e+ 5h f+ 5i a 2g b 2h c 2i g h i 3 5, C = 2 4 2g 2h 2i 3d 3e 3f 1a 1b 1c 3 5. Suppose that det A = 5. Find det B = , det C = , and det (AC) =
-
Suppose there are 50 companies in a commercial building. Initially there is no automatic fire sprinkler system in the public area of the building. Each company has identical individual demand curve...
-
Why is capital budgeting such an important process? Why are capital- budgeting errors so costly?
-
The AICPA Code of Professional Conduct states that a CPA shall not disclose any confidential information obtained in the course of a professional engagement except with the consent of the client....
-
How to draft a pretrial memorandum?
-
The American demand and supply curves for labor cross at a wage rate of $25 per hour. However, American firms can hire as many foreign workers as they want to at a wage of $15 per hour. (Assume that...
-
Q1. Lily borrowed a 28-year $823986 mortgage with an annual rate of 5% and monthly repayments. After 6 years, interest rates have increased to 6% per aum now. How much does she need to pay to the...
-
An accounting entry is required, with one exception: the annual change in employee pay rates, Trans. Document ? Dec. Flowchart Description Received customer purchase order No. 53426 (Doc. No. 4) from...
-
Explain graph based clustering algorithm through examples along with all the parameters required in the algorithm.?
-
How does a crime compare to a civil wrong?
-
What is lenity? How does it place limitations on the criminal law?
-
Explain the principle of legality.
-
How do the separation of powers and federalism place limitations on governments law-making authority? Be specific.
-
Explain the relationship (real and ideal) between higher and lower courts.
-
A company constructs a building for its own use. Construction began on January 1 and ended on December 30. The expenditures for construction were as follows: January 1, $500,000; March 31, $600,000;...
-
D Which of the following is considered part of the Controlling activity of managerial accounting? O Choosing to purchase raw materials from one supplier versus another O Choosing the allocation base...
-
Explain the concept of backward scheduling and give examples of how you use backward scheduling in your personal life.
-
Explain the importance of a business strategy.
-
What are the three major business functions, and how are they related to one another? Give specific examples.
-
Lifestyle Lighting Lid. reported the following on its balance sheed at December 31. 2019: In early July 2020, Lifestyle Lighting Ltd. expanded operations and purchased additional equipment at a cost...
-
The board of directors of Special Services is reviewing its 2020 annual report. A new board member-a nurse with little business experience-questions the accountant about the depreciation amounts. The...
-
Assume that Inter-Provincial Transport Lid's balance sheet includes the following assets under Property, Plant, and Equipment: Land, Buildings, and Motor-Carrier Equipment. Inter-Provincial has a...
Study smarter with the SolutionInn App