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.

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

Transcribed Image Text:

A 1 McCarty Books 2 Schedule of sales 3 4 5 6 7 8 9 Hardcover fiction. 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 For year ended December 31 E-Book children's E-Book fiction E-Book nonfiction Hardcover children's B $ 169,100 937,500 $ $ 845,100 $ 114,500 $ 490,200 $ 432,600 $ 288,240 $ 1,254,800 $ 859,600