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

Here's your... View the full answer

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...

### 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