You manage a publishing company that publishes and sells books to bookstores in Austin, excel conversion help
Subject
Business Finance
Question Description
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
Start Excel. Download and open the workbook named exploring_e01_grader_h1.xlsx.
0
2
Merge and center the title over the range A1:D1.
4
3
Delete the blank column between the Hardback and Paperback 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.