Messages
Proposals
Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.
Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support
I don’t understand this Excel question and need help to study.
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.
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.
| Writer | Writer Name | Amount | Client Comments & Rating |
|---|---|---|---|
ONLINE |
Instant Homework Helper |
$36 |
She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up! |
Custom Original Solution And Get A+ Grades
Custom Original Solution And Get A+ Grades
Custom Original Solution And Get A+ Grades
| Writer | Writer Name | Offer | Chat |
|---|---|---|---|
ONLINE |
High Quality AssignmentsYou can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you! |
$23 | Chat With Writer |
ONLINE |
Maths MasterHello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism |
$20 | Chat With Writer |
ONLINE |
Finance Homework HelpGive me a chance, i will do this with my best efforts |
$19 | Chat With Writer |
ONLINE |
Engineering Exam GuruYou can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you! |
$31 | Chat With Writer |
ONLINE |
Smart Homework HelperI will cover all the points which you have mentioned in your project details. |
$40 | Chat With Writer |
ONLINE |
Writing FactoryI have read your project details. I can do this within your deadline. |
$24 | Chat With Writer |
Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.