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

Examples of reporting verbs in academic writing - Greek gods and roman counterparts - Observation in qualitative research ppt - 3 day lesson plan - Anatomical evidence of evolutianatomical evidence of evolution labon lab - Discuss the importance of netiquette in professional electronic communication - Bbc bitesize macbeth context - Eat drink man woman cooking scene - University of winnipeg acs - Is college for everyone argumentative essay - Tarantella dance steps tutorial - Hell and night must bring this monstrous - Hairy bear big book activities - Apply 4 - Islam Discussion - Discussion 8 - We are only what we always were page number - 603 bus timetable tweed heads - Physical behavior of matter heating and cooling curves - Anyone here knows assembly code - Assignment 3 - Adenauerallee 24 42 53113 bonn - What is contemporary culture - Lancashire grid for learning - 90 confidence interval z-score - Organizational behavior book pdf free download - At kimberly clark dead wood workers have nowhere to hide - Order 2262458: Explain the process of public school findings in Florida - Qiba professional year brisbane - Oregon’s Death with Dignity Act - Filing application for consent orders - Ostevit d once a week review - Nitric acid calcium carbonate - No fear jane eyre - Td 2004/22 is only relevant for on-market share buybacks. - Palm jumeirah completion date - Business & society stakeholders etc edition 15th - Ibm svc simulator download - Meet the student teacher template - Deutsch connector how to - Rei employee login snaplink - Movie exhibition industry case analysis questions - Character vs society conflict definition - New Systems - Viburnum odoratissimum emerald lustre - Jenna perelle terre haute indiana - Experiment 1: enzymes in food - Anna quindlen quilt of a country - Ethics and accountability in public administration - Creative innovative and proactive demeanour - Management Consulting Template: “The Pearl Industry: Is there a market opportunity?”) • Template provided (fillable) - Englishhh - Melbourne transport zones map - Latisha assignments 3 pages total due by 24 hours - Wooden ping pong ball launcher - Lymphatic system jeopardy game - An external website permitting users to browse and purchase widgets - How to graph y 3x 6 - Somewhere in outer space god has prepared a place - Module 2 - Forum 3 - 520 paper - American history textbook alan brinkley pdf - Watch and Comment - Https://tutorsonspot.com/questions/post-homework-complete/ - Chapter 1 the human body an orientation review questions answers - Mystic monk coffee vision and mission - A successful blue ocean strategy requires - 2.1 10 practice written assignment english - Management homework - Reply 1 and 2 ,150 words each one add references and citations by 08/14/2020 - How to read api 20e results - Oxyana documentary youtube - Chemistry for the ib diploma workbook answers pdf - Iv x pv factorial design example - What are social science issues - Difference between stream and block cipher - C program - Adxloader log sync error - Sample training proposal for teachers - Moodle gutech - Discussion 10 - Determination of soil texture by hydrometer method pdf - Rubber band racer design - Blue mountain resorts limited - " What Started the Civil War" - Skill development accomplishments - Lost dog budweiser commercial song - Agcl + nh3 net ionic equation - History of philippine literature timeline pdf - Terminal velocity coffee filter lab report - How is imagism part of modernist literature - Usa patriot act powerpoint presentation - Planning for Innovation - Criminal Law - Competition? Just fix - ASSIGNMENT 2. - A godly woman is to be praised - Week 10 Discussion Forum - Decision making in finance using credit - Persistent http without pipelining