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

Ottoman science and technology - Australian taxation office townsville address - Six roman rulers nfl team - Dr kaoru ishikawa biography - Budget - Plr 8022027 - A variable cost is a cost that - Risk analysis for medium scale expansion excel - Ftsz inhibitor and imipenem - Ethical leadership style questionnaire - Issue in Police recruitment - Emergency light installation instructions - Csda public speaking 2021 - American autowire crimper alternative - The extra good sunday journeys - Apple accounting change - Cornell notes on i have a dream speech - Identify the structure for the following nmr spectrum - Bus pass redcar and cleveland - Sodium phosphate monobasic and dibasic buffer - 5.03 argument analysis graphic organizer - Cliff longshaw driving instructor - Well researched paper needed - African American Studies_Week 2 - Medway council planning portal - International economics answer key - A study with questionable sponsorship or motives - Reputation & Stakeholder Audit - How much is a bowl of chili at wendy's - Module 9 workbook answers - Walmart cost leadership strategy case study - Ibm short term disability - Abdominectomy - Disseminating nursing research outcomes - Nursing Leadership and Management Discussion Board - Implementing Protocols and Improving Guest Services - Geek squad claim form - Bottoms english lawyers atherton - Imperial college london fees - What is emotive laguage - Waltzing matilda poetic devices - Construction project turnover checklist - Driving to the funeral by anna quindlen - Green computing research project charter - Yatra 2007 full movie - Romeo and juliet dream cast - An inexperienced accountant for prestwick company - Global Cities - Swansea bay campus map - Write a 500- to 750-word summary that describes the importance of understanding and using appropriate health care medical terminology in your current or future career. - Komatsu super coolant af-nac - Unethical behavior in physical therapy - Marketing real people real choices 7th edition ebook - Animal farm chapter 1 2 questions - Polynomial addition using linked list in data structure - Ac relay coil snubber - Need early tomorrow - Pride of india tree - Major landforms of sweden - Can i get a powerpoint presentation done by the end of today sept 27th 2020 the scope of the assignment is listed below - How can Ghostwriters help us? - Principles of advocacy in nursing - Vlan ip address range - Resource description framework ppt - Adidas social responsibility report - Actvy - Sucrose melting point and boiling point - Who owns the ice house discussion questions - Parents workshop - Half square triangle formula - What are common mythemes in myths and legends - Flame test lab answers conclusion - Performance lawn equipment case answers - Why doesn t cybersecurity have a naics code - Stages of gospel formation - The clan of one breasted women - Final project busi 201 - Holacracy the future of organizing the case of zappos - Duty of trust and confidence cipd - FIN Questions - The ditchdigger's daughters book summary - Comparing cultures dimensions of culture in a comparative perspective - Rankine active earth pressure coefficient - Electron configuration of br ion - Public mobile to koodo migration offer - Response to Classmates Discussions - Tanglin club guest parking - Gucci replica - Ppm questions and answers pdf - Internship report sample business administration - Canterbury downs spring craft show - Quality management system construction - Draft complaint - Nagoya mag 79el 3w - How much acetic acid is in vinegar lab - Neb prestained protein ladder - Clinical development plan example - Gapu monuk saltwater - The learning place elearn - Act form 16mc1 answer key