The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identification number, sales region, item number, item description, unit price, units sold, and month when the sales were made during the fourth quarter of last year. Modify the spreadsheet to calculate the total sales revenue for each of the eight stores as well as each of the three sales regions.

Store No. Sales Region Item No. Item Description 1 South 2005 24" Monitor 1 South 2005 24" Monitor 1 South 2005 24" Monitor 1 South 3006 Wireless Keyboard 1 South 3006 Wireless Keyboard 1 South 3006 Wireless Keyboard 1 South 6050 PC Mouse 1 South 6050 PC Mouse 1 South 6050 PC Mouse 1 South 8500 Laptop 1 South 8500 Laptop 1 South 8500 Laptop 2 South 2005 24" Monitor 2 South 2005 24" Monitor 2 South 2005 24" Monitor 2 South 3006 Wireless Keyboard 2 South 3006 Wireless Keyboard 2 South 3006 Wireless Keyboard 2 South 6050 PC Mouse 2 South 6050 PC Mouse 2 South 6050 PC Mouse 2 South 8500 Laptop 2 South 8500 Laptop 2 South 8500 Laptop 3 South 2005 24" Monitor 3 South 2005 24" Monitor 3 South 2005 24" Monitor 3 South 3006 Wireless Keyboard 3 South 3006 Wireless Keyboard 3 South 3006 Wireless Keyboard 3 South 6050 PC Mouse 3 South 6050 PC Mouse 3 South 6050 PC Mouse 3 South 8500 Laptop 3 South 8500 Laptop 3 South 8500 Laptop 4 North 2005 24" Monitor 4 North 2005 24" Monitor 4 North 2005 24" Monitor 4 North 3006 Wireless Keyboard 4 North 3006 Wireless Keyboard 4 North 3006 Wireless Keyboard 4 North 6050 PC Mouse 4 North 6050 PC Mouse 4 North 6050 PC Mouse 4 North 8500 Laptop 4 North 8500 Laptop 4 North 8500 Laptop 5 North 2005 24" Monitor 5 North 2005 24" Monitor 5 North 2005 24" Monitor 5 North 3006 Wireless Keyboard 5 North 3006 Wireless Keyboard 5 North 3006 Wireless Keyboard 5 North 6050 PC Mouse 5 North 6050 PC Mouse 5 North 6050 PC Mouse 5 North 8500 Laptop 5 North 8500 Laptop 5 North 8500 Laptop 6 East 2005 24" Monitor 6 East 2005 24" Monitor 6 East 2005 24" Monitor 6 East 3006 Wireless Keyboard 6 East 3006 Wireless Keyboard 6 East 3006 Wireless Keyboard 6 East 6050 PC Mouse 6 East 6050 PC Mouse 6 East 6050 PC Mouse Unit Price Units Sold Week Ending $229.00 28 October $229.00 30 November $229.00 9 December $19.95 30 October $19.95 35 November $19.95 39 December $8.95 28 October $8.95 3 November $8.95 38 December $849.95 25 October $849.95 27 November $849.95 33 December $229.00 8 October $229.00 8 November $229.00 10 December $19.95 8 October $19.95 8 November $19.95 8 December $8.95 9 October $8.95 9 November $8.95 8 December $849.95 18 October $849.95 18 November $849.95 20 December $229.00 38 October $229.00 30 November $229.00 3 December $19.95 30 October $19.95 32 November $19.95 33 December $8.95 25 October $8.95 5 November $8.95 26 December $849.95 28 October $849.95 27 November $849.95 29 December $229.00 18 October $229.00 20 November $229.00 4 December $19.95 12 October $19.95 24 November $19.95 36 December $8.95 29 October $8.95 11 November $8.95 38 December $849.95 21 October $849.95 24 November $849.95 30 December $229.00 27 October $229.00 25 November $229.00 23 December $19.95 80 October $19.95 82 November $19.95 75 December $8.95 65 October $8.95 24 November $8.95 55 December $849.95 55 October $849.95 57 November $849.95 47 December $229.00 24 October $229.00 85 November $229.00 56 December $19.95 52 October $19.95 58 November $19.95 69 December $8.95 35 October $8.95 39 November $8.95 44 December 6 East 6 East 6 East 7 East 7 East 7 East 7 East 7 East 7 East 7 East 7 East 7 East 7 East 7 East 7 East 8 East 8 East 8 East 8 East 8 East 8 East 8 East 8 East 8 East 8 East 8 East 8 East 8500 Laptop 8500 Laptop 8500 Laptop 2005 24" Monitor 2005 24" Monitor 2005 24" Monitor 3006 Wireless Keyboard 3006 Wireless Keyboard 3006 Wireless Keyboard 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop 8500 Laptop 8500 Laptop 2005 24" Monitor 2005 24" Monitor 2005 24" Monitor 3006 Wireless Keyboard 3006 Wireless Keyboard 3006 Wireless Keyboard 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop 8500 Laptop 8500 Laptop $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 78 88 99 34 36 35 49 47 48 45 42 45 55 57 55 18 17 23 22 18 22 14 16 17 32 28 30 October November December October November December October November December October November December October November December October November December October November December October November December October November December