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

14/10/2021 Client: muhammad11 Deadline: 2 Day

Excel Chapter 2 Grader

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

Updated: 01/07/2013 1 E_CH02_EXPV1_A1_Instructions.docx

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:

Homework Guru
Best Coursework Help
Engineering Exam Guru
Solutions Store
Helping Engineer
George M.
Writer Writer Name Offer Chat
Homework Guru

ONLINE

Homework Guru

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$46 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

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

$24 Chat With Writer
Engineering Exam Guru

ONLINE

Engineering Exam Guru

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

$27 Chat With Writer
Solutions Store

ONLINE

Solutions Store

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.

$50 Chat With Writer
Helping Engineer

ONLINE

Helping Engineer

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$39 Chat With Writer
George M.

ONLINE

George M.

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

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

Metabical case study - Holy family bulletin rockford il - Unit 6 Discussion - Effects of Change - Barrier between two seas quran - Academic reading practice test 2 answers diabetes - American history by alan brinkley pdf - Random number generator iwb - Firms that achieve higher growth rates without seeking external financing - A first amendment junkie answers - Why did kathy experience the altered sensation - Weekly Homework 5 - Financial Statements - How to make fake blood look real - Beneath her shirt a book was eating her up - Cd - Woolworths ceo brad banducci - Biol 101 liberty university - Drew marine chemical product catalogue - What do you think a calorimeter does - Example of charging by contact - Explicit instruction lesson plan template - Swagelok hose and flexible tubing catalog ms 01 180 - 4 main earth systems - A5 bigger than a4 - 1610 abyss drive odessa fl - Cases studies - New belgium brewing ethical and environmental responsibility case study - 3.41 repeating as a fraction - Virtual half life lab answer key - Community interpreting level 1 - Week 3 Discussion MAT510 - Mr barton maths m1 - The dead james joyce - Nutrition - Salesmanship - Dell sc420 spec sheet - 2 compare and contrast the three major erp implementation categories - How to draw activity on arrow network diagram - Instrumentation amplifier lab experiment - Okra pepsin e3 australia - Tawanda nyambirai net worth - Who is o brien in 1984 - Organizational values presentation gcu - Types of feature articles journalism - Budget assignment for students - Discussion 1 - Lyle lanley costume - Mncis intocareers org site - Physics - Motel 6 - Tennis court dimensions australia - Asthma soap - What the world eats? - 11 pinxton court carine - Gibbs reflective cycle example - Food inc lesson plan - Informatics - Sace bonus points 2017 - Reed smith vacation scheme - Century marine pro 720 - Personal Financial Plan (8–12 pages) - Achieving excellence in fund raising - Connect chapter 8 homework - Lorain county sheriff sale - Kin maya angelou analysis - Physics chain reaction project - Grundfos magna1 flashing red - Tangent galvanometer lab report - Contagion movie questions for students - India credit risk default model in r - North central and east london foundation school - PLAGIARISM FREE "A" WORK - DB.PP2 - Papa cambridge igcse chemistry - Big Data and Data Analytics on Social Media - Cision university program final exam answers - Project management for business engineering and technology 5th edition pdf - What did mckinley's reelection show about american attitudes toward imperialism - Thai airways rop call center - What is the difference between mbsa and microsoft update - Nonmem 7.4 user guide - Political Speech Essay - 3 write a positioning statement for virgin america - My leo portal tamu commerce - Linux server market share 2012 - L4 Homework Scenario Loosely based on a true story- applied epi - Statistics for nursing research a workbook for evidence-based practice answer key - Common proper and possessive nouns - Unit 7 business law assignment - Essay Tutor - Ranger in time escape from the great earthquake comprehension questions - Plants resistant to honey fungus uk - How does multitasking confuse the resource availability of project team personnel? - Meiosis review worksheet answer key pdf - Pest control baton rouge prices - Organic chemistry homework - Epochs represent the total number of - Dhl telford stafford park - Measurable - Which is the correct chemical name for li2so4