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

A thin rod of length l and uniform charge - Ptc auxiliary heater mercedes - Circumcentre of a triangle - Probability sum of three dice - Husqvarna 16h hedge trimmer - Stair climbing and power lab answers - Discussion 4.2: Interview Results Preview - Agresso self service login - Past participle of studieren - Solve z 3 8 - The two best signs of good strategy execution are - Deliverable 4 - Hypothesis Tests - Hill's pet nutrition annual report - Https www csun edu bashforth 098_pdf 06sep15connotation_denotation pdf - Promontory point gilded age - Blc sharp essay - Triaging an Incident - Mission Strategy. - POL 101 need 3 pages - Study of gods and goddesses - Callaghan motors bonds have 10 years remaining to maturity - My walden library database - Intercultural communication in the blind side - Robert b marks origins of the modern world pdf - Write a 4 pages paper on psychological and law analysis. The other article by Rose Rosenthal, R., Clark, S. E., &amp. Marshall, T. E. (2009). - Departmental income statements include - Assignment 1 professional email message - Volume and surface area of shapes - The Assignment—Part 2: - Crocs vertical integration - Coca cola company financial statements 2013 - Fall of humanity then and now worksheet - Responding - Wessex water developer services - New south wales ecumenical council - Match the parametric equations with the graphs - Http www innerbody com image nervov html - Hog bristle half dulux - Just Paraphrase a report on: The Study and Analysis of Mounted Cameras on Rails System - Motte and bailey castles - Supply chain management quiz 1 - Difference between funds of knowledge and virtual school bag - Harlequin enterprises the mira decision case study - Practical connection without plagiarism - Community mental health team dumfries - The miller of the dee - Current trip error fujitsu - Infusion drops per minute formula - Review - Chapter 5 network design in the supply chain exercise solutions - Mary louise pratt contact zone - B and q bungee - Nucor swot analysis - Data structures in prolog - Social and Racial Problems - Q and A ten questions. - Thermann hot water system warranty - Chuck e cheese token prices 2014 - The lymph node excision category codes are based on what two things? - Vsocial control through mass media - Mcgraw hill practice operations module 1 answers - I pledge to thee my country - Shoretel operator license features - Is moreover a subordinating conjunction - Life on the goldfields - How to hit a vein when dehydrated - Edu 555 - Marketing management orientation concept - HW - Sociocentric thinking - A credit sale of $2,500 to a customer would result in: - RESEARCH METHODOLOGIES AND INQUIRY - Jimmy lafave net worth - CASE STUDY AND 500-WORD ESSAY - Blue mountains trains timetable - Grey elephant from denmark joke - Discussion Board due Friday 10.31.2020 at 3PM EST - Wildwood by junot diaz audio - Song c day lewis analysis - Www pandasecurity com homeusers support register - Servlet life cycle ppt - Imc maths past papers - How to write an eei - Molykote p74 data sheet - World History - Mcdonalds hume hwy liverpool - Web access protection non functional eset 6 - Bga heatsink with fan - Clash of the titans book merrill lynch - Psychotherapy question - No me gustan esos zapatos voy a comprar - I need 750 words on Human Resource Management 6152 - Cba mortgage discharge authority - Are ben and jerry brothers - How to demonstrate customer service skills - Quantitative criteria for strategy evaluation - Chapter 16 international pay systems - Kingdom hearts black & white pete 264 walmart exclusive - English Research Sumo Work - 7 1 final project submission presentation to investors assignment