Hi... I'm having trouble with the following: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 MadisonCopy 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:MadisonCopy 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.) ABEFArt FairsMadison 2021QIQ2Q3Q4Total5 Ceramics6 Fiber7 Glass8 Stone9 Total sales101213141516171819DocumentationArt FairsChicagoSt. LouisMinneapolisMadisonCombined Sales AB.DEHArt Fairs2Combined Sales 202134QIQ2Q3Q4Total2020 Total5 Ceramics$1,802$2,198$3,357$2,556$9,912$12,637$1,620$2.386$3,743"6 Fiber7 Glass$2,781$10,530$13,636$1,973$1,986$3,546$4,206$I1,711$15,4358 Stone$2,042"$2,117$2.272"$3,180$9,611ȘI1,9139 Total sales$7,436$৪,686$12,918$12,723$41,764$53,621101213141516171819DocumentationArt FairsChicagoSt. LouisMinneapolisMadisonCombined Sales

Open all the three workbooks it is given In cell A5, enter a formula without using a function that…

Answered: in Jee wants to combine the sales data…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Concept explainers

Question

100%

Hi... I'm having trouble with the following:

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:
1. In cell A5, enter a formula without using a function that references cell A5 in the Madison
2. Copy the formula from cell A5 to the range A6:A8 without copying the formatting.
3. 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
4. Copy the formula from cell B5 to the range B6:B8 without copying the formatting.
5. 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.)

A
B
E
F
Art Fairs
Madison 2021
QI
Q2
Q3
Q4
Total
5 Ceramics
6 Fiber
7 Glass
8 Stone
9 Total sales
10
12
13
14
15
16
17
18
19
Documentation
Art Fairs
Chicago
St. Louis
Minneapolis
Madison
Combined Sales

A
B.
D
E
H
Art Fairs
2
Combined Sales 2021
3
4
QI
Q2
Q3
Q4
Total
2020 Total
5 Ceramics
$1,802
$2,198
$3,357
$2,556
$9,912
$12,637
$1,620
$2.386
$3,743"
6 Fiber
7 Glass
$2,781
$10,530
$13,636
$1,973
$1,986
$3,546
$4,206
$I1,711
$15,435
8 Stone
$2,042"
$2,117
$2.272"
$3,180
$9,611
ȘI1,913
9 Total sales
$7,436
$৪,686
$12,918
$12,723
$41,764
$53,621
10
12
13
14
15
16
17
18
19
Documentation
Art Fairs
Chicago
St. Louis
Minneapolis
Madison
Combined Sales

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions