The following is a sample of a worksheet in Excel.

To complete this exercise, download the Excel file from MyLab Accounting. Complete the exercise in Excel.

Requirements1. Calculate total sales and put the total in Cell B14.2. Calculate average sales and put the total in Cell B16.3. Calculate total E-book sales and put the total in Cell B18.4. Calculate total Hardcover sales and put the total in Cell B19.5. Calculate total Paperback sales and put the total in Cell B20.6. Calculate total Children’s sales and put the total in Cell B22.7. Calculate total Fiction sales and put the total in Cell B23.8. Calculate total Nonfiction sales and put the total in Cell B24.

Transcribed Image Text:

1 Smythe Books 2 Schedule of sales 3 4 A For year ended December 31 5 E-Book children's 6 E-Book fiction 7 E-Book nonfiction Hardcover children's 9 Hardcover fiction 8 10 Hardcover nonfiction 11 Paperback children's 12 Paperback fiction 13 Paperback nonfiction 14 Total 15 16 Average 17 18 Total E-Book sales 19 Total Hardcover sales 20 Total Paperback sales $ 274,600 208,200 609,100 179,850 886,500 603,400 $ 318,700 $ 1,369,200 $ 679,300 $ $ $ $ B $