You own six local coffee shops. The revenues and customer count for each coffee shop are given in the following table.

Set up a workbook that makes it easy to enter the revenue and customer count for each store. Then create a summary worksheet (using three-dimensional formulas) that computes the total weekly revenue and customer count.

Transcribed Image Text:

Shop 1 2 3 4 LO 5 6 Revenues $8,000 $7,000 $9,000 $8,400 $5,900 $10,100 Customer Count 1,950 1,800 2,200 2,000 1,400 2,500