Home /
Expert Answers /
Other /
10-min-jee-wants-to-combine-the-sales-data-from-each-of-theart-fairs-switch-to-the-combined-sales-wo
(Solved): 10. Min Jee wants to combine the sales data from each of theart fairs. Switch to the Combined Sales ...
10. Min Jee wants to combine the sales data from each of theart fairs. Switch to the Combined Sales worksheet, and then updatethe worksheet as follows:a. In cell A5, enter a formula without using a function thatreferences cell A5 in the Madison worksheet.b. Copy the formula from cell A5 to the range A6:A8 withoutcopying the formatting.c. In cell B5, enter a formula using the SUM function, 3-Dreferences, and grouped worksheets that totals the values from cellB5 in the Chicago:Madison worksheets.d. Copy the formula from cell B5 to the range B6:B8 withoutcopying the formatting.e. Copy the formulas and the formatting from the range B5:B8to the range C5:E8. (Hint: You can ignore the error about emptycells because Min Jee will enter the Madison sales datalater.)***Cant use Madison 2021 A5****tried go use ref from Chicago-Minneapolis I get #REFany help is very aoprocated! please and thank you
Home fx NP EX19.56.Christian Antonio, 2. Excel sert Page Layout Formulas Data Review View Developer Help Power Pivot Search 2 A Define Name Trace Precedents show formules V ure in formula Trace Dependents f Math & Recently Financial Logical Text Date & Lookup More Name or Checking Welch - - - Time Reference Functions Manager Create from Selection Remove Arrows- Evaluate Formule Window Function Die Support_19_56_Combined_2020.xlsxCombined Sales 1$$$ et A Function m - - Art Fairs Combined Sales 2021 Q2 03 Q1 04 Total 2020 Total 9 Total sales $53,621 Insert Function AutoSum Recently Financial Logical Text Date & Lookup & Math & More - Used - - Time- Reference Trigo Functions Function Ubrary Define Name - Une in formula Name Manager ate from Selection Defined Names Trace Precedents Show Formulas Trace Dependents for Checking - F Remove Arrow - vuste Formula Formula Auditing X SUMBS:09) Art Fairs Chicago 2021 $ 5 Ceramics 6 Fiber 7 Glass 8 Stone 9 Total sales 612.50 $ 586.70 $ 657.85 $ 605.65 $ 2.462.70 $ 724355 803.45 698.75 656.80 $ 288315 LI 15.80 $ 1.222.75 $ 1.205.15 $ 04 845.00 $ 934.50 $ 1,435,25 $ 1,093.45 $ 4.308.20 $ Total 3.297 65 3.547.40 3.997.00 3.116.65 13,958.70 $ 304.45 $ POWERS fx E O ? A @ @ @ Insert Function AutoSum Recently Financial Logical Tat Dute & Lookup - Used - • Time Reference Function Library Mats & ng More functions M Name Manager Define Name usenform Create from Selection Defined Nunes Trace Precedents Show Formula recedents Ancing Remove Arrows - v e Formula FormActing Art Fairs St. Louis 2021 5 Ceramics 6 Fiber 7 G 8 Stone Total sales 644.50 $ 516.70 S 607.95 $ 710.65 $ 2.479.80 $ Q2 733.30 801.15 628.95 696.95 2.880.35 $ $ Q3 1,105.50 $ 1.242.15$ 1,185.75 $ 785.75 $ 4319.15$ 04 825.25 $ 913.15 5 1,385.20 $ 1,143.355 4.26695 Total 3,308 55 3473.15 3,807.85 3670 .926 25 1 AutoSave om 9 : File Home Insert Page Layout Formulas Data Review View fx Insert AutoSum Recently Financial Logical Test Date & Look Math & More Function - Used - - Time Reference. The functions @ 2 A Q NP_EX19.56.Christian Antonio, 2. Bice Developer Help Power Pivot Search Define Name - Trace Precedents Show Formulas Q Use in Formula trace Dependents from Checking Manager Create from Selection Remove Arow - E f ormula Window omul Auditing X SUM(5:58) Art Fairs Minneapolis 2021 Total s Ceramics 6 Fiber 7 Glass 54450 $ $16.40 $ 707.05$ 225.65 $ 2,493.60 $ Q2 740.305 781.15$ 658.15 $ 762.95 $ 2.942.55 $ Q3 1,135.55 $ 1.278.15 $ 1.155.50 $ 725 25 $ 4,294.45 885.50 $ 933.75 $ 385.20 $ 943.65 $ 4.148.10 $ 3.305.85 3,509:45 3,905.90 3.157.50 13,878.70 8 Stone 9 Total sales $ AutoSave On : NP EX19 Ostatnio 2 - Excel File Home Help fr Power Pivot Search Tace Precedents Show Formulas Trace Dependents Amor Checking - Remove Arow - Formula Insert Function Autosum Recently Test De Lookup Window Options D H K L - Art Fairs Madison 2021 Q1 Q2 Q3 04 5 Ceramics 6 Fiber 9 Total sales NP. EX19.56. Christian Antonio, 2. Excel The Home Insert Page Layout Formulas Data Review View Developer Help Power Pivot Search fx E92 A 20 GOD Defne Nane Tace Precedents Bishow Formulas Usein Formula het A Error Checking Autum Recently Financial Logical Test Date & Lookup & Math & More Name grace Dependents Watch - Time Reference Thig Functions Manager Create from Selection Remove Arrows - Evaluate Formula Window Function Ubrary Defined Names Formula Auditing Support_EX19_5b_Combined_2020.xlsx)Combined Sales I$F$ DE GHIK Art Fairs Combined Sales 2021 QI Q2 Q3 Q4 Total 2020 Total $12,637 $13.636 SI5435 $11.913 $53,621
Expert Answer
Answer to 10. Min Jee wants to combine the sales data from each of the art fairs. Switch to the Combined Sales worksheet, and then...