Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

show me how you get. thank you 9 AWN 6 Complete the following problems considering the four =SUM Rules 7 8 a. Use the AutoSum

show me how you get. thank you image text in transcribed
image text in transcribed
9 AWN 6 Complete the following problems considering the four =SUM Rules 7 8 a. Use the AutoSum icon to sum the Total Expense for Jan, then Use the Fill Handle to copy the formula to Feb and Mar. 0 Jan Feb Mar Operating Expenses 2 Consulting 240 3 Supplies Exp 67 33 4 Insurance 75 75 75 5 Postage 40 6 Other 5 12 8 7 Total Expense 8 9 b. Input the proper formula for each of the following: 0 1 Revenue $ 1,000 2 Expense 700 The Use of the =SUM 3 Net Income would be inappropriate 4 here. 5 Retail Price 400 5 x Discount % 7.0% 7 Discount HINT 3 2 Sales By Store Long Beach $ 89 1 Cerritos 78 Orange 122 Total Sales HINT HINT c. Below is the Quantity on Hand of each of the toasters the company manufactures Following the Sum rules input the formula that will provide the total of ALL toasters regardless of Model Model # Qty Model # Qty AL487 43 116 12 GF8 76 X75 117 GF9xt 19 X86 84 L111 4 Use TOTAL QTY OF ALL ITEMS HIN =SUM(range)+Sum(range) d. Using the Autosum icon to it's fullest: The Autosum icon for applying the Sum can significantly increase your efficiency Quickly get the proper =Sum formulas in the Qtr Total and Individual month Totals cells by highlighting the ENTIRE YELLOW shaded area and clicking on the Autosum icon once Apparel Quantities Purchased: Qtr 1 Total 5 Jan Mar Feb 1,200 7 B 1,000 9 Socks Shirts Pants Belts Total 1,200 975 300 750 275 0 1 Notice that the Autosum icon put the same row range for each of the month totals 2 3 14 55 56 57 58 59 70 Notice that the Autosum icon put the same column range for each of the item's Quarter totals > Right or Wrong???? Notice that the Qtr Grand Total is a cross footing of the columns rather than a sum of the quarter column. Are you wondering if that is Right or wrong

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions

Question

4. Employ fair disciplinary practices.

Answered: 1 week ago

Question

Discuss the importance of positioning in IMC planning.

Answered: 1 week ago