View the step-by-step solution to:

TOPIC:

Excel Problems 2 (Arrays)
TOPIC: Arrays, Filters, Subtotals, Groups Carrier Device Type Mar-09 Apr-09 May-09 <-- Add a Filter to the top row Verizon cell phone 347 320 360 Verizon smart phone 458 446 321 Verizon air card 120 110 113 Verizon Total devices Verizon <-- Group by Carrier with Total being summary; subtotal each provider ATT cell phone 146 147 150 ATT smart phone 510 511 515 ATT air card 53 55 62 ATT Total devices ATT <-- Group by Carrier with Total being summary; subtotal each provider Sprint cell phone 41 30 28 Sprint smart phone 82 82 65 Sprint air card 19 17 17 Sprint Total devices Sprint <-- Group by Carrier with Total being summary; subtotal each provider Nextel cell phone 2 2 2 Nextel smart phone 1 1 1 Nextel air card Nextel Total devices Nextel <-- Group by Carrier with Total being summary; subtotal each provider T-Mobile cell phone 39 35 35 T-Mobile smart phone 40 40 40 T-Mobile air card 0 0 0 T-Mobile Total devices T-Mobile <-- Group by Carrier with Total being summary; subtotal each provider TOTAL TOTAL DEVICES <-- sum totals by month using subtotal formula All Carriers Mar-09 Apr-09 May-09 cell phone <-- use SumIf to total the number of cell phone devices for all carriers in the table above smart phone <-- use SumIf to total the number of cell phone devices for all carriers in the table above air card <-- use SumIf to total the number of cell phone devices for all carriers in the table above Total devices All Carriers <-- sum the total number of devices by Month
Background image of page 1
Sign up to view the entire interaction

Top Answer

Here's your... View the full answer

Excel Problems_Arrays.xls

TOPIC: Arrays, Filters, Subtotals, Groups Carrier
Verizon
Verizon
Verizon
Verizon
ATT
ATT
ATT
ATT
Sprint
Sprint
Sprint
Sprint
Nextel
Nextel
Nextel
Nextel
T-Mobile
T-Mobile
T-Mobile
T-Mobile
TOTAL...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online