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

Myitlab excel chapter 2 grader project

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

BUS 180:301

Excel Chapter 2 Grader* Project [Assessment 1]

Formulas and Functions

Project Description:

In the following project, you will perform preliminary work on the sales worksheet. You will total quarterly earnings, create functions to determine sales regions, and bonus eligibility. Your last steps will be to calculate basic summary information and finalize the worksheet.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Download and open the file named exploring_e02_grader_a1.xlsx, and then save the file as exploring_e02_grader_a1_LastFirst.

0

2

Create a named range for cell B4 named Sales_Goal.

7

3

Insert a function in cell B24 to calculate the total sales for Q1 in column B.

7

4

Copy the total function into the range C24:E24 to calculate the totals of Q2 through Q4.

7

5

Insert functions in column F to calculate the sales totals of each individual sales rep.

7

6

Insert a function in the cell H11 that looks up the sales rep region based on the table in cells E3:F6.

7

7

Copy the function down to populate the remaining portion of column H. Be sure to use absolute or mixed referencing when necessary.

7

8

Enter a function in cell I11 to calculate the sales reps eligibility for bonus. If the reps total sales are greater than or equal to the sales_goal then the function should return the value Bonus, if not the function should return NA.

7

9

Copy the function down to populate the remaining portion of column I. Be sure to use absolute or mixed referencing when necessary.

7

10

Insert a function in cell B28 to calculate Median of all sales in column F.

7

11

Insert a function in cell B29 to calculate average sales dollar amounts.

6

12

Insert a function in cell B30 to calculate the total number of sales reps.

6

13

Format the values in the range B11:E11 with Accounting Number Format.

6

14

Format the values in the range B12:E23 with Comma Style.

6

15

Insert a function in cell B3 to display the current date.

7

16

Format the totals in cells F11:F23 with Accounting Number Format.

6

17

Save the file and close Excel. Submit the file as directed.

0

Total Points

100

Formulas and Functions

Project Description: In the following project, you will perform preliminary work on the sales worksheet. You will total quarterly earnings, create functions to determine sales regions, and bonus eligibility. Your last steps will be to calculate basic summary information and finalize the worksheet.

Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Download and open the file named exploring_e02_grader_a1.xlsx, and then save the file as exploring_e02_grader_a1_LastFirst. 0 2 Create a named range for cell B4 named Sales_Goal. 7 3 Insert a function in cell B24 to calculate the total sales for Q1 in column B. 7 4 Copy the total function into the range C24:E24 to calculate the totals of Q2 through Q4. 7 5 Insert functions in column F to calculate the sales totals of each individual sales rep. 7 6 Insert a function in the cell H11 that looks up the sales rep region based on the table in cells E3:F6. 7 7 Copy the function down to populate the remaining portion of column H. Be sure to use absolute or mixed referencing when necessary. 7 8 Enter a function in cell I11 to calculate the sales reps eligibility for bonus. If the reps total sales are greater than or equal to the sales_goal then the function should return the value Bonus, if not the function should return NA. 7 9 Copy the function down to populate the remaining portion of column I. Be sure to use absolute or mixed referencing when necessary. 7 10 Insert a function in cell B28 to calculate Median of all sales in column F. 7 11 Insert a function in cell B29 to calculate average sales dollar amounts. 6 12 Insert a function in cell B30 to calculate the total number of sales reps. 6 13 Format the values in the range B11:E11 with Accounting Number Format. 6 14 Format the values in the range B12:E23 with Comma Style. 6 15 Insert a function in cell B3 to display the current date. 7 16 Format the totals in cells F11:F23 with Accounting Number Format. 6 17 Save the file and close Excel. Submit the file as directed. 0 Total Points 100

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:

Quality Assignments
Engineering Guru
Math Specialist
High Quality Assignments
Premium Solutions
Quick Finance Master
Writer Writer Name Offer Chat
Quality Assignments

ONLINE

Quality Assignments

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.

$29 Chat With Writer
Engineering Guru

ONLINE

Engineering Guru

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$39 Chat With Writer
Math Specialist

ONLINE

Math Specialist

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$38 Chat With Writer
High Quality Assignments

ONLINE

High Quality Assignments

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.

$23 Chat With Writer
Premium Solutions

ONLINE

Premium Solutions

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$39 Chat With Writer
Quick Finance Master

ONLINE

Quick Finance Master

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

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

Professional Capstone and Practicum Reflective Journal - Enterprise Risk Management - Organizational behavior key concepts skills & best practices pdf - Scottsboro an american tragedy youtube - Week 4 Chapter 5 Homework - Cutting speed formula for turning - Nptc national safety conference - What are the two branches of statistical methods - How to write art appreciation - Cityof goldcoast com au payments - Alpha and omega god meaning - Modern marvels cotton worksheet answers - The epicurus reader selected writings and testimonia - Number of primes less than 10000 - Laura hughes sex offender shuffle - Southern queensland institute of tafe - Text to text connections examples - The suit short story summary - Best glide fishing kit - Policies -Criminal Justice crj101 - What is accounts receivable classified as - HW - CIS web design - Macbeth plot analysis graphic organizer - Schools interested in proposing a curriculum consistent with a nation at risk would probably offer - Drawing lab equipment worksheet - Which set of scores has the smallest standard deviation - Explain how empowerment heightens employee motivation - MM Case Study - Philosophy 2 First Paper - United food and commercial workers canada local 175 - 30.5 km in miles - Earth mat installation procedure - Strategic group map craft beer industry - Strong/* lOve marriAge speCialist +91-9924492424 Baba Ji - What is external evidence - How does the producer offset work - Ready player one book short summary - Low volume vehicle certification plate - Rmit special consideration extension - Road vehicle descriptor online - Network diagram table - Health care delivery in the united states 11th edition pdf - A just and lasting peace obama analysis - Roy vagelos attacks river blindness - Homework - John connelly crown cork and seal - How the hr function varies between organisations in different sectors - Discussion and Assignment - Special occasion speech topic ideas - Climate change speech outline - 6. 7 Discussion 3: International Trade --econ discussion - Class diagram for real estate management system - Answer 4 questions - Balance n2 h2 nh3 - MEE 5801 Unit 6 - Rheumatoid arthritis case study nursing - Coca cola company strategy implementation - Leather sector skill council - Dunkin donuts human resources for employees - Todd lubitsch boy in the plastic bubble - Loveworld children's ministry portal - Strategy and hrm at delta airlines case study - Byron bay cookies selection cookie bites assorted gift jar 400g - Psych - Madison harris the owner invested - Video Clip Discussion - How adverse selection might impact the market for unemployment insurance - Project Overview - Electrical certificate of proficiency - W5 Discussions - Narrative report about health and wellness - COVID-19: A Case Study in Effective Women's Leadership - Dr lisa lau chinatown chicago - Amortization schedule calculator bret whissel - A primer on communication studies v 1.0 author - Tweak nic sheff quotes - Executive Program Practical Connection Assignment - Crohn's disease pes statement - Shadow health focused assessment cough - Case Study - Prophylactic Hysterectomy - What was anne hutchinson's heresy - Niccol glass top adjustable study table - Unnatural causes in sickness and in wealth transcript - Week Assignments - Mccann co has identified an investment project - Anz vanuatu online banking - Is hmo mandatory in the philippines - Dormy way care home - Examples of chemical weathering in everyday life - Bending the frame photojournalism documentary and the citizen pdf - Ranger cayman 191 for sale craigslist - Ausnet solar pre approval - Spencers sexology bath bombs amazon - 2020 psychology study design - An organization that rates and classifies hotels and awards them diamonds is the - Bsbrsk501 - NEED 3+ PAGES WITH 4 PEER REVIEWED REFERENCES CITED IN APA FORMAT - August osage county screenplay