The following is a sample of a worksheet in Excel. To complete this exercise, download the Excel

Question:

The following is a sample of a worksheet in Excel.


image


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.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Managerial Accounting

ISBN: 9780137858514

7th Edition

Authors: Karen W. Braun, Wendy M. Tietz

Question Posted: