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 12 grader project

04/12/2021 Client: muhammad11 Deadline: 2 Day

Excel Chapter 2 Grader* Project [Assessment 1]

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

Office 2013 – myitlab:grader – Instructions Exploring - Excel Chapter 2: Assessment Project 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

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 Help Online
Premium Solutions
Top Academic Tutor
Academic Master
Engineering Mentor
Assignment Guru
Writer Writer Name Offer Chat
Coursework Help Online

ONLINE

Coursework Help Online

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$29 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.

$19 Chat With Writer
Top Academic Tutor

ONLINE

Top Academic Tutor

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

$46 Chat With Writer
Academic Master

ONLINE

Academic Master

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$20 Chat With Writer
Engineering Mentor

ONLINE

Engineering Mentor

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$28 Chat With Writer
Assignment Guru

ONLINE

Assignment 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.

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

Tuesdays with morrie interview questions - Cisco finesse not ready reason codes - Unsw canberra key dates - Waren sports supply bank reconciliation - Ethica and Legal Aspects of Nursing Practice DQ 5 week 3 laura Rosa - Week 5 Assignment: Ethical and Cultural Perspectives of Inquiry Paper - Click stream analysis ppt - Numbers 1-20 in french - Tom bohlman lexus of albuquerque - Irac example duty of care - Marketing assignment new product launch - What is parochialism in management - Marketing Planning - Why has establishing credibility become so important in the post-trust era? - Historical Analysis and Analysis of Relevant Criminological Theories - Mg/hr to ml/hr calculator - Apqc process classification framework - What was the scoop deliverable and results of the project - A poll solicits a large number of college - 560- POST AND RESPONSES DB-4 - Why might you use a perception check - 1 100 transistor circuits - Operation could not be completed - How to conclude a persuasive speech examples - Movie summary - Music Artist Career Plan - Strategic management accounting syllabus - Exchange policy jb hi fi - White rock spring mountain - Eric ogbogu net worth - Expected return and standard deviation graph - Case study - I need 1600 words(4 pages 1.5 space )on Instruction contract. - Components of time series - A manufacturing company, current company in a developed country and two possible developing countries in different parts of the world where you could relocate - Waeco reversing camera spares - Nigel's service centre geraldton - Does history repeat itself evidence from the course - Chik chik company showed the following balances at the end of its first year: - Combat oil cabinet heaters - Valle del lili foundation sap - Portfolio - A comparative balance sheet for shabbona corporation - Comprehensive problem 1 the accounting cycle bob night answers - Friction loss experiment lab report - Pink ribbon morning tea - Naoh and benzoic acid reaction - As nzs 1170 structural design actions - Fallout 76 demonstrate pioneer scout values - Concentric zone model strengths and weaknesses - Week 3 quiz information - Broome senior high school timetable - Forward and backward scheduling ppt - Britax 395 series beacon - John deere jd 750 case study - 100 hotter grace glasses no lenses - Key concepts in mathematics - Comparing historical fiction and reality - Financial Statement Concepts - Elephant toothpaste potassium iodide equation - Biology Week 5 - Smart goals for impaired gas exchange - American bureau of shipping abs singapore - What is the difference between impedance and resistance - 0.19 repeating as a fraction - Pilfering union dues - Literature class discussion post about Dante's Inferno from Ch1 to Ch5 - Middle english pronunciation guide - Examples of informative language function - To measure the amount of acetic acid in vinegar - Connection between education and income - Management accounting course syllabus - Annotated bibliography - Doulton court care home - Snap on mg1250 review - Calculate the focal length of a thin meniscus lens - Eugene onegin russian text - Data-driven decision making - Business Intelligence Chapter 1 - Leading across cultures at michelin analysis - Burj khalifa site plan - Box office receipt - Lev vygotsky's - B and q bungee - Halting problem is undecidable - Load bank connection cabinet - Week 5 BIO2070 MICROBIOLOGY PROJECT - Dimensions of information systems ppt - Voting! - The principal components of opera include arias recitatives overtures and - Data entry in pharmacovigilance - Freedom on my mind volume 2 - Nursing diagnosis for love and belonging - Lab 7: ecological interactions - Ge ecomagination criticism - Which source would provide credible information about the life of jazz musician charlie parker? - Organizational behavior chapter 7 motivation concepts - O brien auto group onemint login - Phet solar system simulation lab answers - 4 Questions for IT managers to be answered and analysed