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

Author royalties excel

05/01/2021 Client: saad24vbs Deadline: 2 Day

Office 2013 – myitlab:grader – Instructions Exploring - Excel Chapter 1: Homework Project 1


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: Rule 1: If an object is selected and a new tab appears, it is 95% in that new tab. Rule 2: If you are ever confused, right click on the selected item. Formulas: + = Addition - = Subtraction * = Multiplication / = Division Step Instructions Points Possible 1 Start Excel. Download and open the workbook named exploring_e01_grader_h1.xlsx. In File, use the SAVE AS function to save the document in Computer / Z Drive as Excel Chapter 1 Capstone 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 using the decrease decimal button in Number. 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. This should be the Retail Price subtracting (the Retail Price multiplying the Standard Discount) Copy the formula in cell B15 and paste it in C15 using the Formulas & Numbering Formatting option in the Paste drop-down under Home / Clipboard. 8 7 Enter the Net Retail Sales formula in cell B16. The net retail sales is the net units sold multiplied by the retail price. Gross units sold minus the returned units equals net units sold. Copy the formula in cell B16 to cell C16 using the Paste Formulas & Numbering Formatting option. 8 8 Enter the Royalty to Author formula in cell B20. Royalties are based on Net Retail Sales multiplied by the Royalty Rate. Copy the formula in cell B20 to cell C20 using the Paste Formulas & Numbering Formatting option. 8 9 Enter the Royalty per Book formula in cell B21. This amount is the Royalty to Author Amount divided by the difference between the Gross Units Sold and the No. of Returns. Copy the formula in cell B21 to cell C21 using the Paste Formulas & Numbering Formatting option. 8 10 Apply Comma Style with zero decimal places to the range B8:C9. 4 11 Apply Percent Style with two decimal places to the range B19:C19. 4 12 Apply Accounting Number Format to the cell C13. 4 13 Click cell A7, apply Purple font color, and then apply Gray-25%, Background 2, Darker 10% fill color. Select the range A7:C7 and select Merge Across. 6 14 Select the ranges A8:A10, A13:A16, and A19:A21. Within Alignment using the increase indent, indent the labels twice. Widen column A to 23.75. 6 15 Select the range A7:C10 (the Units Sold section) and apply the default Outside Borders border style. 3 16 Select the margin setting to center the data horizontally on the page. 3 17 Insert a footer with the text Exploring Series on the left side, the sheet name code in the center, and the file name code on the right side. 6 18 Copy the Jacobs worksheet, move the new worksheet to the end, and then rename it as Lopez. Change cell B4 in the Lopez worksheet to Lopez. Change the Jacobs sheet tab to Red. Change the Lopez sheet tab to Dark Blue. Select options to print the gridlines and headings on the Lopez sheet. 13 19 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: 03/06/2013 2 E_CH01_EXPV1_H1_Instructions.docx

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
Helping Hand
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.

$62 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.

$60 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

Amy, age 19 and single, has $8,050 of wages, $800 of interest, and $350 of self-employment income. - Ends ways and means model - Vivid art tattoos monroe mi - Environmental effects of the hoover dam - A point charge of 5nc is located at the origin - Assume that a procedure yields a binomial distribution - Hltwhs002 assessment - Faraday's electromagnetic lab 1 answers - Discussion - What is a force table - Electrical analogy of fluid flow - Highland tree trunk crossword clue - Case Study 4 The Space Shuttle Disasters - 5 year career plan powerpoint - Swot analysis strengths examples for students - Cole hersee 75228 03 - The terminal movie questions and answers - Ecology the lion king movie guide answers - Contact moreton bay regional council - Fish cheeks questions and answers - 40 difficult words to pronounce - Immigrants in our own land poem - Looney tunes robot rampage 2 - Louis jordan happy birthday boogie - University of wollongong v metwally - Reply to an informal invitation - Act 4 scene 3 - Tiffany's nails des moines ia - Molar solubility from ksp - Features of web 2.0 software as a service - Curfews for minors pros and cons - Aero automatic sprinkler company lawsuit - Does apple juice contain monosaccharides - Subgame perfect equilibrium problem set - Rabbits for sale loughborough - Enter the november 1 balances in the ledger accounts - Art history - Synthesizing The Concepts - Role of promotional agencies in entrepreneurship development - Brunswick park primary school - Nursing interventions for kussmaul respirations - Discussion 1 - Mini-Case studies on ERM and Risk - Police administration 9th edition pdf free - Paper writing - Fahrenheit 451 parlor walls page number - What is unrelated diversification strategy - The deep river by head summary - Picot question examples infection control - Communication- For Creative Instructor ONLY- - Sdl threat modeling tool examples - Hope by lisel mueller analysis - Celebrating diversity in early years - Oracle 12c sql chapter 5 hands on assignments answers - Chamberlain 4090 hydraulic pump - Accounting budget project - Atomic radius of diamond cubic structure - American Dream - Carlsberg organizational structure - This is 2 separate assignments . I need the outline and the essay. Please send me the essay topic before you start - Partition node in spss modeler - Brandt v boston scientific corporation - Money and the prices in the long run and open economies - Aviary plans free download - Chemical formulas pre lab questions - Electric potential of a charged ring - 14 divided by what equals 2 - Against school john taylor gatto thesis - Find all the zeros of each equation x^5-3x^4 - Reply 1 and 2 ,150 words each one add references and citations by 08/14/2020 - Salts confidence be convex - Keith rn case studies - Labview clad exam preparation - List of distributed databases - Business name availability qld - Objectives of teaching pronunciation - Uncle ernest short story questions and answers - Planes para el invierno fill in the blanks with informal commands based on the cues. - Ram 2500 tow capacity chart - Physical measure method of allocating joint costs - Essentials4work - Nursing theory and conceptual model - Discussion (350 words) - Mcdonald's monopoly case study - ______ guides the justice approach to deciding ethical dilemmas - Wall street journal classroom edition chapter 8 article business organizations - David foster wallace tense present democracy english and the wars over usage - Mcgraw hill practice operations module 1 answers - Bright star jane campion analysis - Statistics Excel: Week 4 - Humidity sensor advantages and disadvantages - 4 types of innovation invention extension duplication synthesis - Strategic Planning 8352 - For anyone - Image Analysis - Tattoo machine armature bar setup - Solution-Focused Brief Therapy - Discussion: Strategies for Academic Portfolios - Post2 - Sir charles gairdner hospital dental clinic