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

Excel chapter 2 grader project assessment

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

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:

Supreme Essay Writer
Engineering Solutions
Finance Homework Help
A Grade Exams
Study Master
Professor Smith
Writer Writer Name Offer Chat
Supreme Essay Writer

ONLINE

Supreme Essay Writer

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

$47 Chat With Writer
Engineering Solutions

ONLINE

Engineering Solutions

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$36 Chat With Writer
Finance Homework Help

ONLINE

Finance Homework Help

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$23 Chat With Writer
A Grade Exams

ONLINE

A Grade Exams

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$48 Chat With Writer
Study Master

ONLINE

Study Master

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$33 Chat With Writer
Professor Smith

ONLINE

Professor Smith

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

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

Informative Speech Outline Rough Draft - Assignment - Butterfly pooped a spider - Bloom's taxonomy second language acquisition - Signature Assignment: Strategies - Poussin landscape with the ashes of phocion - Difference between batting average and slugging percentage - Movie review - What does second author mean - Chegg whatsapp group - Diversity and Ethical Codes - DUE IN 24 HOURS - According to a newspaper account a paratrooper - 13th film discussion questions - Essay due tomorrow at midnight - Escape from spiderhead pdf - John d varlaro - Creative evolution henri bergson pdf - The ethics of teaching strike and soltis chapter summaries - Effect of temperature on yeast respiration experiment - Americans with Disabilities Act - Discussion 7 - Earthquake quiz iit kanpur - To kill a mockingbird chapter 1 2 questions and answers - Tuesdays with morrie pdf 192 pages - Why are discourse communities important - Shadow health focused exam chest pain transcript - Policy Diffusion - Aboriginal charter of rights poem - Norton introduction to literature portable - What Are the Best Styles and Fits for a Yellow Varsity Jacket? - Paradox in macbeth act 1 scene 2 - Estee lauder strengths and weaknesses - Nurs561w2 - Sample project report financial statement analysis - Alpha to omega placement test - Hr - Segmentation of samsung - Arimidex side effects steroids - Execution of wanda jean - If you were a flavor what would it be - Rube goldberg interesting facts - Chemical reaction word equations - Single axle roll off hoist - Human resources - Mgt - Claude mckay powerpoint - Method of consistent deformation truss - Cornish and clarke 1986 the reasoning criminal - Bt 7600 base unit - Difference between drg and apc - Essentials of business law 8th edition pdf - Need two responses to discussion questions. 150 words min with references if needed - Ionic bonding worksheet answers - Market Plan - An example of horizontal analysis is - Case study steve jobs - Emerging Threats - Need help in my history homework - Approaches and methodologies in the social sciences a pluralist perspective - Human Resource Mang. (for tutorjass) - Client file management policy - Group discussion number 4 is assigned to me - Describe the moment captured in leonardo's last supper painting - Is vinegar and baking soda exothermic or endothermic - Ap1 - Charles lackey operates a bakery in idaho falls idaho - Reading Response - Https docs python org 3 library random html - Air expands on heating class 7 - Literature review fire alarm system - Quickbooks online student guide chapter 5 - Termite trails lab - Business Statistics class - Composition and rhetoric - Salford council pest control - Bd vacutainer instructions for use - Www businessballs com howardgardnermultipleintelligences htm - Sociocentric thinking - Legislation Comparison Grid and Testimony/Advocacy Statement - Rhetorical Analysis - Petrovend system 2 manual - Lang may yer lum reek pronunciation - Report 3(A) - Practical Connection Paper ; 2-3 pages ; Due Oct 03, 12pm EST - Kinetic energy of a rotating disk - The use of multiple perspective and primary shapes - Analyzing Student Data: The RTI Model - Identifying hazards in occupational environments ati - Brisbane city council pdonline - King lear cordelia death scene - Al no3 3 9h2o molar mass - In a state's pick lottery game you pay - What were the main causes of the great depression - +971561686603 Abortion pills in Dubai/Abu Dhabi-mifepristone & misoprostol in DUBAI - Prg420 - Coca cola balanced scorecard - College of medicine south africa - Ucl division of surgery and interventional science - Tata communications emerging markets growth strategy - Re expressing data definition