Copy and paste the tables below into separate worksheets in excel. In the \'All

Question

Copy and paste the tables below into separate worksheets in excel. In the 'All states' worksheet calculate the total revenue for auto insurance for all four states. You MUST use 3D cell references.

1. Calculate the total revenue for auto insurance. What formula was used?

2. What is the Total Revenue for fire insurance?

Worksheet 1: All States Mouseketeer Insurance Company 2012 Revenue Insurance Product Group Revenue Auto Fire Health Home Life Totals Wrotksheet 2: Maryland Mousketeer Insurance Maryland Revenue - 2012 Insurance Product Group Revenue Auto $22,572 Fire $41,380 Health $55,977 Home $71,222 Life $3,788 Totals Worksheet 3: Delaware Mousketeer Insurance Delaware Revenue - 2012 Insurance Product Group Revenue Auto $16,637 Fire $30,886 Health $50,234 Home $49,787 Life $4,639 Totals Worksheet 4: NY Mousketeer Insurance Connecticut Revenue - 2012 Insurance Product Group Revenue Auto $10,597 Fire $28,511 Health $35,335 Home $47,500 Life $3,102 Totals Worksheet 5: Pennsylvania Mousketeer Insurance Connecticut Revenue - 2012 Insurance Product Group Revenue Auto $5,299 Fire $9,900 Health $22,797 Home $31,667 Life $1,757 Totals

Explanation / Answer

1. The total revenue for Auto Insurance = $55,105

The formula Used is =(Sheet2!B6+Sheet3!B6+Sheet4!B6+Sheet5!B6)

2. The total revenue for Fire Insurance = $110,677

The formula Used is =(Sheet2!B7+Sheet3!B7+Sheet4!B7+Sheet5!B7)

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.