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...
-
Kent sold his car to Carolynn for $2000 down and monthly payments of $259.50 for 3 1/2 years, including interest at 7.5% compounded annually. What was the selling price of the car?
-
Brooke and John formed a partnership. Brooke received a 40% interest in partnership capital and profits in exchange for contributing land (basis of $30,000 and fair market value of $120,000). John...
-
Does Fairmont have any personnel whose last name is similar?
-
WoodGrain Technology makes home office furniture from fi ne hardwoods. The company uses a joborder costing system and predetermined overhead rates to apply manufacturing overhead cost to jobs. The...
-
8. Suppose f(x) = x 2. Use the forward difference method with h = 0.1 to approximate f'(1).
-
Who do you think the CEO should appoint as CIO? Why? The Suarez Effect Pat Talley stood and watched, with grudging admiration, as Carmelita Suarez worked the room. Sharp, charming, and armed with a...
-
discuss how drinking patterns differ between groups of people depending upon their education, gender, ethnicity etc. what factors (biological, cultural, etc) do you think contribute to these...
-
In a survey of a sample of 1050 teenagers, 17% said they like to watch soccer. Determine whether the underlined value is a parameter or a statistic.
-
In a national survey of high school students (grades 9 to 12), 25% of respondents reported that someone had offered them a cigarette at least once. Determine whether the underlined value is a...
-
After the hand, the cards are discarded, and the next hand continues with the remaining cards in the deck. The player has had an opportunity to see some of the cards in the previous hand, those that...
-
In the game of blackjack, also known as twenty-one, the player and the dealer are dealt one card face-down and one card face-up. The object is to get as close as possible to the score 21, without...
-
Ages of children: 4 years, 5 years, 6 years, 7 years, and 8 years Determine the level of measurement of each variable.
-
ABC company wishes to raise $ 2 0 m via an issue of 1 2 0 day bills at 5 % pa . What is the face value of the issue?
-
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.
-
For the pediatrician presented in Example 1, find the probability that a randomly selected three-year-old girl is between 35 and 40 inches tall, inclusive. That is, find P(35 X 40). By-Hand...
-
Find the value of z 0.10 . Approach We wish to find the z-value such that the area under the standard normal curve to the right of the z-value is 0.10.
-
The heights of a pediatricians three-year-old females are approximately normally distributed, with mean 38.72 inches and standard deviation 3.17 inches. Find the height of a three-year-old female at...
Study smarter with the SolutionInn App