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

Add column sparklines to cells f2

08/11/2021 Client: muhammad11 Deadline: 2 Day

Grader - Instructions Excel 2019 Project

Excel_2F_Commercial_Compensation
Project Description:
In the following project, you will edit a worksheet that summarizes the compensation for the commercial salespersons who qualified for bonuses in two regions.

Steps to Perform:
Step

Instructions

Points Possible

1

Open the Excel workbook Student_Excel_2F_Commercial_Compensation.xlsx downloaded with this project.

0

2

Rename Sheet1 as Arizona and rename Sheet2 as Washington.

4

3

Click the Arizona sheet tab to make it the active sheet, and then group the worksheets. In cell A1, type Marisol Desserts and Spices and then Merge & Center the text across the range A1:F1. Apply the Title cell style. Merge & Center the text in cell A2 across the range A2:F2, and then apply the Heading 3 cell style.

10

4

The bonus rates for each salesperson are determined by sales amounts using the following scale: Sales greater than $35,000 earn a bonus rate of 5%, sales greater than $25,000 earn a bonus rate of 4%. All other sales (any amount greater than 0) earn a bonus rate of 2%. With the sheets still grouped, in cell C5 use an IFS function to determine the commission rate for the first salesperson whose sales are in cell B5. Fill the formula down through cell C8.

6

5

In cell D5, calculate Bonus for Moreland by multiplying the Sales times the Bonus Rate. Copy the formula down through cell D8.

4

6

In cell F5, calculate Total Compensation by summing the Bonus and Base Salary for Moreland. Copy the formula down through the cell F8.

8

7

In row 9, sum the columns for Sales, Bonus, Base Salary, and Total Compensation. Apply the Accounting Number Format with two decimal places to the appropriate cells in row 5 and row 9 (do not include the percentages).

4

8

Apply the Comma Style with two decimal places to the appropriate cells in rows 6:8 (do not include the percentages). Apply the Total cell style to B9 and D9:F9.

4

9

Ungroup the sheets, and then insert a new worksheet. Change the sheet name to Summary and then widen column A to 210 pixels and columns B:E to 155 pixels

4

10

Move the Summary sheet so that it is the first sheet in the workbook. In cell A1 of the Summary sheet, type Marisol Desserts and Spices and then Merge & Center the title across the range A1:E1. Apply the Title cell style. In cell A2, type November Commercial Salesperson Bonus Summary and then Merge & Center the text across the range A2:E2. Apply the Heading 1 cell style.

11

11

In the range A5:A7, type the following row titles and then apply the Heading 4 cell style: Bonus Base Salary Total Compensation

4

12

In the range B4:E4, type the following column titles, and then Center and apply the Heading 3 cell style: Arizona/Washington Arizona Washington Total

6

13

In cell C5, enter a formula that references cell D9 in the Arizona worksheet so that the total bonus amount for the Arizona region displays in cell C5. Create a similar formula to enter the total Base Salary for the Arizona region in cell C6. Using the same technique, enter formulas in the range D5:D6 so that the Washington totals display.

8

14

Sum the Bonus and Base Salary rows, and then calculate Total Compensation for the Arizona, Washington, and Total columns.

7

15

In cell B5, insert a Column Sparkline for the range C5:D5. In cells B6 and B7, insert Column sparklines for the appropriate ranges to compare Arizona totals with Washington totals.

10

16

To the sparkline in cell B6, in the first row, apply the second sparkline style. To the sparkline in cell B7, in the first row, apply the third sparkline style.

4

17

Group the three worksheets, and then center the worksheets Horizontally on the page and insert a Custom Footer in the left section with the file name. Change the Orientation to Landscape and fit the columns to 1 page.

6

18

Save and close the file, and then submit for grading.

0

Total Points

100

Created On: 10/03/2019 1 GO19_XL_CH02_GRADER_2F_AS - Commercial Compensation 1.1

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:

Coursework Assignment Help
Pro Writer
Assignment Hub
Supreme Essay Writer
Top Writing Guru
WRITING LAND
Writer Writer Name Offer Chat
Coursework Assignment Help

ONLINE

Coursework Assignment Help

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$36 Chat With Writer
Pro Writer

ONLINE

Pro Writer

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$27 Chat With Writer
Assignment Hub

ONLINE

Assignment Hub

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$27 Chat With Writer
Supreme Essay Writer

ONLINE

Supreme Essay Writer

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$38 Chat With Writer
Top Writing Guru

ONLINE

Top Writing Guru

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$46 Chat With Writer
WRITING LAND

ONLINE

WRITING LAND

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

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

Costco wholesale corporation financial statement analysis a solution - Educational technology - Descartes meditations 6 summary - Patch adams movie questions and reflection - The forsaken merman by matthew arnold summary - Separation of a mixture lab answers - Powerpoint - Dior meaning in swahili - Organ Leader - artificial intelligence - Class in america 2012 gregory mantsios - Describe the abercrombie & fitch style - Vcaa religion and society - I need two slides on HR plan Developing as an effective professional in the real food company - Rias gifted test sample questions - Discussion Post BPaas-4 - Nesa physics additional sample questions - Discussion 4 - Problem 12 6 preparing a payroll register - Attic needlework last chance - Ciro model evaluation - How to write a conclusion for a newspaper article - Jes jython environment for students - Bosch fr 7 dc+ - Of paramount significance in the tabernacle was the - Rms minimum lane width - Guidance on the use of tactile paving surfaces - What should be a firm's primary long term financial objective - Nursing - Chapel street traders association - Fellow craft square and compass - Unit 2 Learning Activity: Applied Project 1500 words - A salesperson clicks repeatedly on the online ads - Radiation exposure immediately around a properly functioning nuclear power plant is about - HCA320 Assignment Mod 5: - Business finance practice exam - Chicago style sample paper - How to recognize plagiarism tutorials and tests answers 2019 - Sheilas wheels cancellation fee - What strategies will you use to peer assess written assignments - Teresa granger is the manager of chicago cheese - It 210 milestone two technology solutions and recommendations - Banrock station crimson cabernet review - Code name verity chapter 1 summary - Wicked witch and her monkeys - Cisco downloadable acl example - Another word for drab - Butterfly garden gold coast - 4/47 roslyn st brighton - Essentials of management andrew j dubrin pdf - Public administration discussion 3 - University of leicester campus map - Management Accounting Coursework - What capabilities should a wireless security toolkit include - Kaiser modesto er wait time - Ionic bonding worksheet answers - Prince of prussia hotel - What is managerial ethics - Frankston community vaccination hub - bayside centre - Weak acid weak base conductivity curve - Ece 5 year license application bc - Coca cola information systems - What did greek theater originally celebrate - Define tenaz - Myob termination code 1203 - Hotel saville south yarra - Campbells cash n carry adelaide - Advantages and disadvantages of italy - Mansa musa pilgrimage primary source - Karmac sliding door rollers - Unplugged the myth of computers in the classroom pdf - Salford city council complaints - Best rhymes for competition - RisK Mgt Project part - 2-3 Page - Accounting career preparation - Individual programmatic assessment week five programmatic assessment - Supplementary bonding 18th edition - Visual language features english - Case study on capital budgeting with solution - Engineering strain formula - 22.2 shape center and spread answers - Tokenization - Research and writing del 2 - RESEARCH METHODOLOGIES AND INQUIRY - Medicare levy exemption or reductio - Aviation - Edinburgh university paterson's land - Marianne moore the paper nautilus - Commonwealth bank merchant services - Duke merchant of venice - A5 size in cm width and height - Timbuk2 case study operations management - The lion's bride analysis - A housekeeper at a local hospital - Wayne maunder lucia maisto - Arlec wireless alarm system manual - Timothy aubry a matter of life and death - Why is sti considered a scientifically controversial strategy - Thick and thin questions - Iwg format paperhow is cmi calculated - Socw 6456