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

Trump boulders in a harness sticker - Privacy and Compliance - Project deliverable 3 database and data warehousing design - Right to work laws inhibit union formation by - Gcu capstone project examples - Ops 571 week 1 individual assignment - Hospitality in the odyssey - Drinking coffee elsewhere doris is coming summary - How to check soldering iron with multimeter - 36 essential multiplication facts - How many miles per second does light travel - Case study on capital structure with solution - American pharoah stallion register - Business - They say i say 4th edition with readings citation - Methods Social Res;Quantitative Hus-311 - Jad joint application design - 100 word positive response due 9/3/20 at 10pm three defenses - Stata commands cheat sheet - Cyber assignment - Que oyen los estudiantes de la residencia todas las mañanas - Applied managerial statistics course project - Amazon com inc retailing giant to high tech player - Voting! - Space lord monster magnet lyrics unedited - Economies of Education - 10 journal articles review summary - John gardner writing exercises - Biggest challenges facing organizations in the next 20 years powerpoint - Textiles and design syllabus - Gcu individual success plan example - Diet and exercise assistant desktop version 6.0 - Historical accuracy of gladiator - Norton introduction to literature 12th edition - HR Papers - Who certification scheme on the quality of pharmaceutical products - Incarceration nations chapter 5 summary - 2357 unit 604 answers - Iot based energy meter block diagram - Electrolysis of water experiment procedure - Team Research Paper - Chai lim dentist nedlands - Determination of ka of weak acids post lab answers - Ancient history essay topics - Persuasive speech topics about dogs - Student exploration calorimetry lab answers activity b - Cardiac muscle diagram labeled - What happens in a positive test for oxygen gas - Https owl english purdue edu owl resource 560 02 - Principal beliefs of judaism - Zappos case study questions and answers - Observations of chemical changes lab report - Which client requires immediate nursing intervention the client who - 4.6 features of rational functions answers - Wk 3 - College Communication Worksheet [due Mon] Wk 3 - College Communication Worksheet [due Mon] - 2 assignments due within 24 hours - Objectives in a lesson plan bloom's taxonomy example - Mk wiring accessories catalogue pdf - Inductive and deductive reasoning in economics - Etikan musa & alkassim 2016 - 9780321979070 - Prepare a business case for the global treps project - The guidelines on cyber security onboard ships version 3 - The road not taken questions with answers - Organization leadership - Royall v the queen causation - Shadow health digital clinical experience - Question - 95a queens road connells point - Federal safeguards for financial reporting abuse - The new new play by kelly stuart - Essay: code of Hammurabi - Engstrom auto mirror plant milestone 3 - What is 1 4 as a decimal and percent - Peter hockley speech pathologist - Medical image analysis - Discussion - Atx motherboard hole template - Sensor switch programming instructions - Dyson 1908 2 kb 454 - Acri hues vs evershield - Penta hexa hepta octa nona deca - 8 melaleuca drive athelstone - Jane lynch snl sunday night football skit - Lego's turnaround brick by brick case study - All over the counter receipts are entered in cash registers - Tim hortons case study analysis - Curved mirrors and the law of reflection worksheet answers - Knight company reports the following costs and expenses in may - How to cite a chapter in a book apa - Iom report the future of nursing leading change - Department of education regional directors - Michael ymer professional development - What did ned kelly achieve - Kaps institute of management pty ltd - Employee profit sharing agreement template - Paraphrase and cite at the following passages. Try not to look back at the original passage aft - Lady macbeth sleepwalking scene video - I need help with HRM/498T Strategic Human Resource Management And Emerging Issues Assignment week 2 - G polya how to solve it - Cable abc has a length of 5 m figure 1