Excel

Page 1 of 3

Excel

By | March 2012
Page 1 of 3
Royalty Statement

Project Description:
You manage a small publishing company in Austin, Texas. You publish and sell hardback and paperback novels to regional bookstores. At the end of every six-month period, you prepare royalty statements for the authors based on the net sales and a standard royalty rate. Your assistant prepared a standard royalty statement for one author. You need to insert formulas to calculate missing values and format the worksheets. In addition, you need to insert worksheets to prepare a royalty statement for other authors.

Instructions:
For the purpose of grading the project you are required to perform the following tasks: StepInstructionsPoints Possible
1START EXCEL. DOWNLOAD AND OPEN THE WORKBOOK NAMED EXPLORING_E01_GRADER_EOC.XLSX.0 2ENTER THE TEXT ROYALTY STATEMENT IN CELL A1. MERGE AND CENTER THE TITLE OVER THE RANGE A1:C1. CHANGE THE FONT SIZE OF THE TITLE TO 16, AND APPLY BOLD FORMATTING. CHANGE THE FONT COLOR TO PURPLE (UNDER STANDARD COLORS).9 3INSERT A NEW ROW BETWEEN ROWS 13 AND 14. ENTER STANDARD DISCOUNT RATE IN CELL A14, 0.55 IN CELL B14, AND 0.5 IN CELL C14. FORMAT THE TWO VALUES IN B14 AND C14 AS PERCENT STYLE.10 4IN CELL B15, ENTER THE FORMULA TO CALCULATE THE PRICE TO THE BOOKSTORE. THE PRICE TO THE BOOKSTORE IS CALCULATED BY SUBTRACTING THE STANDARD DISCOUNT FROM THE RETAIL PRICE. THE DISCOUNT IS CALCULATED BY MULTIPLYING THE RETAIL PRICE (B13) BY THE STANDARD DISCOUNT RATE (B14).4 5IN CELL B16, ENTER THE FORMULA TO CALCULATE THE NET RETAIL SALES. THE NET RETAIL SALES NUMBER IS FOUND BY MULTIPLYING THE NET UNITS SOLD BY THE RETAIL PRICE (B13). THE NET UNITS SOLD IS CALCULATED BY SUBTRACTING THE RETURNED UNITS (B9) FROM THE GROSS UNITS SOLD (B8).4 6IN CELL B20, ENTER THE FORMULA TO CALCULATE THE ROYALTIES TO THE AUTHOR. ROYALTIES ARE CALCULATED BY MULTIPLYING THE NET RETAIL SALES (B16) BY THE APPLICABLE ROYALTY RATE (B19).4 7IN CELL B21, ENTER THE FORMULA TO CALCULATE THE ROYALTY PER BOOK. THIS...