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

Rights and responsibilities of friendship - How many ram chips are necessary - Introduction to Philosophy- 2 pages - 8-10 paragraphs. - Intermediate accounting chapter 23 statement of cash flows solutions - Ka ba and akh - Flip dot boards xy5 price - Fantastic mr fox chapter 1 - Average weight of a round bale of hay - Discussion - Uncle doug output transformer - What is internal environment analysis - 95 management interview questions and answers pdf - Poli 330 final exam answers - Universal laser inc just paid a dividend of - Bilingual education - Write 83 1 3 as a fraction - The speed of a runner increased steadily - Petbarn narre warren grooming - C++ - Othello soliloquy act 1 scene 3 - Which protozoan group consists solely of parasitic forms - Write a theory - 3 pages due by 16 hours ..Attendance policy development scholarly paper - Directorate of secondary education - Literature review on Security Challenges in Cloud Computing - Cyclone naming convention australia - Stages of international marketing involvement - Unsw health service bulk bill - Program to convert decimal to binary in java - Urgent 1- 7 hours due - The wrong place by susan michalski - Probability and statistics - CRM 1 - Latin vce study design - Closed feedwater heater analysis - Worded equation for photosynthesis - How deep is 8 meters in feet - Appreciation and depreciation worksheet - Speech Delivery - Starbucks barista training program - For all work solver - 32nd annual fall diddley craft show - Market segmentation strategy of coca cola - ACC 499 Week 10 Discussion "Case C18-5: Deferred Tax Assets and Liabilities" - Ebix australia vic pty ltd - Flavour enhancer 621 halal or haram - Week 7 Video Presentation - Anthony heywood qvc usa - Tidi insect in english - Tappd cocktails discount code - An activity that has more than one dependency arrow flowing into it is termed a(n) - Write your own strcpy function in c - Florida board of cosmetology - BHS380 Module 2 Discussion Post 2 - Hp 3par storage 7200 - Who can complete this assignment by 4pm TODAY ? - Weetabix for weight loss - Greenhouse effect lab report - Staffing metric - Chapter 7 internal control and cash answers - Queen mary's hospital sidcup address - Revays auto service harrisburg pa - Short essay about a Bollywood movie - Whs workplace inspection checklist - Map of mega cities - Forgiving the unforgivable sherry johnson pdf - Company sales invoices census data and trade association statistics - University of washington environmental policy - What is half of a5 - 34 54 poplar road parkville - How to buy happiness - Civil engineering graduate cover letter - Tcp ip attack lab solution - A storage shed is to be built in the shape of a box - Hol microscope - What pricing strategy does bentley motors use - Ethical issues in interpersonal communication - Life is beautiful movie summary - The monkey's paw summary - Cinderella steven curtis chapman - Art history research paper outline - Business management unit 1 - Cell size lab answer key - El envía sangre (sends blood) al resto del cuerpo. - Dc power supply polarity - Quality and safety in nursing wgu - James mcnaughton paper group v hicks anderson - The ethical no free lunch rule states that - Cisco asr1001 x ios upgrade procedure - PLEASE NOTE due TODAY OCTOBER 24, 2020 EASTERN TIME 10:00PM. 2-3 page essay, Plaigiarism free, no cover page, APA style. - Software development plan outline - Assignment - Hope is the thing with feathers figurative language - The wizard of oz a political allegory worksheet answers - Airfield defence guard salary - Outline instructions - Using HIN website - Getting to yes summary - Chapter 2 conceptual framework for financial reporting - Consumer behaviour case study pdf