### Free Educational Resources

• > Exploring ­ Excel Chapter 1: Homework Project 1 Author Royalties
+

# Exploring ­ Excel Chapter 1: Homework Project 1 Author Royalties

##### Rating:
(0)
Author: matthew stock
##### Description:

http://homework.plus/exploring-excel-chapter-1-homework-project-1-author-royalties/

Author Royalties

Project Description:
You manage a publishing company that publishes and sells books to bookstores in Austin. Your assistant prepared a standard six-month royalty statement for one author. You need to insert formulas, format the worksheets, and then prepare royalty statements for other authors.

Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step

Instructions

Points Possible

1

0

2

Merge and center the title over the range A1:D1.

4

3

Delete the blank column between the Hardback andPaperback columns.

3

4

Insert a new row between Retail Price and Price to Bookstore. Enter Standard Discount Rate in cell A14, 0.55 in cell B14, and 0.5 in cell C14. Format the range B14:C14 with Percent Style.

6

5

Enter the Percent Returned formula in cell B10. The Percent Returned is the ratio of No. of Returns over the Gross Units Sold. Format the result with Percent Style with one decimal place. Copy the formula in B10 to C10.

6

6

Enter the Price to Bookstore formula in cell B15. This is the price at which you sell the books to the bookstore. It is based on the Retail Price and the Standard Discount Rate. For example, if a book has a \$10 retail price and a 55% discount, the price to the bookstore would be \$4.50. Copy the formula in cell B15 to cell C15 using the Paste Formulas & Numbering Formatting option.

8

7

Enter the Net Retail Sales formula in cell B16. The net retail sales is the revenue from the net units sold at the retail price. Gross units sold minus the returned units equals net units sold. Copy the formula in cell B16 to cell C16 using the Paste Formulas & Numbering Formatting option.

8

8

Enter the Royalty to Author formula in cell B20. Royalties are based on Net Retail Sales and the Royalty Rate. Copy the formula in cell B20 to cell C20 using the Paste Formulas & Numbering Formatting option.

8

(more)
##### Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

No credit card required

26 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial