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

2 iodopropane sodium hydroxide - What is fixed practice in sport - Why It's Worth Listening to People We Disagree With - PUB 5. - Chatty pink job - At&t strengths and weaknesses 2017 - Discovering human sexuality 3rd edition ebook - Cover page unsw engineering - What is a cross cultural worker - The pillowman full script - The american promise 6th edition volume 2 pdf - Mike purchases a heavy duty truck - Community organizing training manual - Report for consulting management course, based on proposal which introduce someone as consultant to solve issues of mentioned company - Doosan 1600 compressor fault codes - New coke case study - Sunquest laboratory information system manual - Laminar flow in a triangular duct - National communication association credo for ethical communication - Gretchen at the spinning wheel lyrics - Week 2 Ethical Frameworks Essay - Research Report - Jupyter measure time - Measuring gravity with a pendulum - Red bull case analysis - Activity analysis occupational therapy - Escape from spiderhead pdf - FINANCE WEEK 5 DISCUSSION - ECO 100 - N/A - ASN 7 - Eye of the storm documentary - Consumer behavior a strategic approach - The jeaning of america summary - A 55 kg box is being pushed - Walking with the seasons in kakadu activities - Canadian credit unions by size - Moment generating function of a constant - Diamond bay sorrento walk - What is a nursing practice problem - How to add pinyin in powerpoint - Virtual blood type lab answers - Which product of prime polynomials is equivalent to 8x3 2x - The artificial silk girl sparknotes - Department of education caps documents - Trade and cash discount exercise - African History Discussion question - Hawaiian name for samantha - Margaret atwood happy endings essay - NEED IN 18 HOURS or LESS - 2000 years of chinese history crash course answers - Columbus journal of the first voyage to america - What is a single displacement reaction - Paper - Distributed algorithms nancy lynch - Module 05 Assignment - Esteban 50th anniversary impala guitar - Chapter 12 the revenue cycle sales to cash collections - Which best compares and contrasts visual and performing arts - Www biology4kids com files systems_main html - BUSINESS MOTIVATIONS OF SENTIMENT ANALYSIS USE ( DATA MINING) - B and m garden hose - Internet/Web Access Management - What is audit file - What's an irrational number - Unity gain bandwidth of 741 op amp - Water by the spoonful full text - 2 discussion - Raising the driving age statistics - Multi touch screens vs mouse driven screens - Pacific trails resort chapter 11 - Information technology - Gledhill thermal store problems - As a madman shakes a dead geranium - Health Finance wk 3 - Do you quarrel sir - How to calculate drg reimbursement - The united states has a dual court system - 90 day game plan pdf - Scada distribution management system - 688a pacific highway belmont - Paparazzi customer loyalty cards - Colpitts crystal oscillator design - Visio 2013 uml sequence stencil download - Premier's reading challenge victoria - How formidable a competitor is google for amazon - The anglo saxons 449 1066 - Power Point Presentation with small essay attached to reflect presentation - Cell phone battery charger circuit - Global Climate Change writing assignment - Ge reveal bulbs banned - Wirral council planning portal - Week 7 Assignment - Http www testingforschools com code - How many minutes is 2.3 hours - Barbell hip thrust athlean x - Candidature management system unimelb - Shrek 1 release date - What are social science issues - MGMT discussion