Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

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

Royalty to author formula excel

18/12/2020 Client: saad24vbs Deadline: 10 Days

Office 2010 – myitlab:grader – Instructions Exploring Series! Excel Ch. 01 - EOC Project


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: Step Instructions Points Possible 1 Start Excel. Download and open the workbook named Exploring_e01_Grader_EOC.xlsx. 0 2 Enter 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 3 Insert 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 4 In 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 5 In 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 6 In 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 7 In cell B21, enter the formula to calculate the royalty per book. This amount is calculated by multiplying the retail price of the book (B13) by the royalty rate (B19). 4 8 Copy the formulas from the B15:B16 to C15:C16 and from B20:B21 to C20:C21. 3 9 Apply the Accounting Number Format to the monetary values in the ranges B13:C13, B15:C16, and B20:C21. 7.5 10 Apply bold formatting and the Purple, Accent 4, Lighter 40% fill color to the Units Sold heading in cell A7. 4 11 Indent the text in cells A13:A16 two times. 4 12 Apply an Outside Border (default settings) to the range A7:C10. Apply the same border style to the ranges A12:C16 and A18:C21. 6 13 Insert a new worksheet on the right side of the Jacobs worksheet. Rename the new worksheet Lopez. Change the Lopez sheet tab color to Dark Blue (under Standard Colors). 9 14 Copy the data from the range A1:C21 in the Jacobs worksheet, and paste it into the same cells in the Lopez worksheet. 3 15 Change the following values on the Lopez worksheet: Cell: New value: B4 Lopez B8 5000 C8 15000 B9 400 C9 175 B13 19.95 C13 7.95 7 16 Select both worksheets and center the data horizontally on the page when printed. Insert a custom header with the name Cecil Kramer in the left section, the Sheet Name code in the center, and the File Name code in the right section. 10 17 With both sheets selected, select the options to display the gridlines and row and column headings when printed. 4 18 On the Lopez worksheet only, display the cell formulas. 3 19 In Normal view, on the Lopez worksheet, adjust the width of column A to 11.00 (165 pixels). Adjust the widths of columns B and C of the Lopez worksheet to 7.00 (108 pixels). 4.5 20 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Jacobs, Lopez. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0 Total Points 100


Updated on: 1/4/2010 1 E_CH01_EXPV1_EOC _Instructions.docx


Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

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!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

University Coursework Help
Homework Guru
Helping Hand
Top Essay Tutor
Writer Writer Name Offer Chat
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$122 Chat With Writer
Homework Guru

ONLINE

Homework Guru

Hi dear, I am ready to do your homework in a reasonable price and in a timely manner.

$122 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$120 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$125 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Identifying hazards in occupational environments ati - Introduction to advertising - The accounting software installation project case study solution - What makes a laundry detergent good math worksheet answer key - Ms andrews hotel video - What is a diagnostic essay - English - How to become a cop nsw - Gis software and gps agriculture - I need 1000 words on article How to Clean Mac System Storage - Hubspot inbound marketing and web 2.0 case solution - Assignment: Advocating for the Nursing Role in Program Design and Implementation - Hershey case study analysis - 20 cm hg of vacuum to atm absolute - Suppose stark ltd just issued a dividend of - Caars observer short version - MBA work 7 - Huckleberry finn duke and king quotes - Discussion post (two) - Dyson core competencies - Anu group study room - Compare the four categories of ebusiness models - Nun - So3 2 lewis structure - Us and them david sedaris sparknotes - Define the term policy impacts - Error retrieving key to decrypt file vce - Sagging pants origin in slavery - Is nebosh recognized in canada - The database medline is produced by - Uts library journal articles - The habitable planet ecology lab answers - Forklift licence victoria handbook - Linear piecewise defined functions edgenuity answers - Sandra case study - Musculoskeletal system shadow health assessment - CompXm Final Rounds - Difference between am gm and hm - Why does hamlet pretend to be mad - A fairly subtle approach to advertising is _____. - Dehydration powerpoint presentations - Florida port community college career center - Average cost of ending inventory - Artificial Intelligence assignment - Jesse stone benefit of the doubt recap - Week - 05 - Determination of the formula of a hydrate lab answers - In regression analysis the residuals represent the - Sue klebold my son was a columbine shooter - Http biz yahoo com ic ind_index html - Is lsd a hallucinogen stimulant or depressant - Pinto fires and personal ethics summary - Promotion and the product life cycle mkt/571 - Java slot machine source code - Discussion for human Sexuality class - PROJECT MANAGEMNT RESARCH PAPER - Needed 12 pages + APA FORMAT + PALAGRISIM REPORT. TOPIC IS The relationship between project management and overall performance of a company - Cell homeostasis virtual lab answer - Assignment - Jsa template western australia - Operational planning in nursing management - ENG 102 Critical Writing week 2 - Clinical Supervision - What does mise en scene mean - Case study 2 improving e mail marketing response - Essentials of lifespan development 5th edition with connect - Mies van der rohe barcelona pavilion column - British spacecraft hermes 1959 - Computer networking a top down approach wireshark labs - How does teamwork influence innovation at ideo - Organ system worksheet answers - In a parallel circuit the voltage is across all branches - Essay online games - Target market for solar energy - Does anyone offer proofreading services? - Appreciative inquiry strategic planning questions - Buiness Essay - Fin decisions - 5 to 32 line decoder - Paid freight charges on merchandise purchased - Spectrum protect rest api - Performance management case studies pdf - Algebra equations year 7 - What is the identity of the cation in the unknown - Human body systems assignment - 8.5 x 11 title block autocad - Mattress disposal brisbane city council - The lost generation commonlit answer key - Psychology Journal EASY 200 words - 1045 steel mechanical properties - Nur495journalw3 - Bbc bitesize scalar and vector - Compare and contrast vision and mission statements - Executive ethical leadership reputation matrix - How do protozoa reproduce - Sodium hydroxide flame test color - Information Systems Architecture - God of schemes sacrifice - Allergy asthma & sinus center judge gurdev md - Create webquest - Project closure document sample