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

2 assignments of reading response - Raymond cattell trait theory of personality ppt - Find 3 consecutive even integers - Elements of art worksheet - 2 PAGES ESSAY - Financial and managerial accounting for mbas - Some recent financial statements for smolira golf corp follow - +91 9928097710 online vashikaRan specialist Molvi ji in Mumbai - How to determine income elasticity - Chemical kinetics iodine clock reaction lab answers - She's come undone wally lamb sparknotes - How much is 80 meters - Differences between aquatic and terrestrial environments - The development of neolithic house societies in orkney - How to tame a wild tongue essay - What were the most compelling topics learned in this course - Discussion 3: Disorders & Cognitive Behavioral Therapists - ACC 401 Week 7 Discussion "Foreign Currency Transactions and International Financial Reporting Standards (IFRS)" - Week 11 Discussion - Avoiding electrocution hazards assessment quizlet - Paper - Charlie echo delta alphabet - How to hack among us - Persuasive Annotated Bibliography - 17.1 independent practice answer key - Biointeractive regulation of the lactase gene answers - Ib math studies logic questions - How high does a tennis ball bounce - Project cost and time managment - What is recommendation in report writing - 10 things i hate about you quotes kat - Virginia henderson 14 basic needs ppt - Futur proche aller infinitif - Which market targeting strategy is virgin america following - Pavilion reit annual report 2019 - Discussion: Reflecting on Hardships & Overcoming Challenge - Advertising, Ethics, Values, and Diversity - Course Project—PowerPoint Presentation - Math Tutors needed - Mundane realism definition psychology - 3 Discussion Questions, 3 Student Responses, 2 Papers ... - Why is eggshell a good material for edta to chelate - Calcium and hydrochloric acid equation - Ntu method counterflow heat exchanger - Molal boiling point elevation constant - How to add music in html using notepad - PCI - Kettle reboiler design procedure - 2 dollar movie theater in bartlett - Paypal in 2015 reshaping the financial services landscape - Creating a Resource List - Stellar evolution lab the life cycle of a star - Ermo chinese film - Module 3 - Business intelligence plan template - Quality in qualitative evaluation a framework for assessing research evidence - Environmental Discussion Question (Mod 3) - Suffolk county council consultations - Molecular models lab answers - Indian grocery store near purdue university - Certified food scientist exam questions - Coco movie questions - Collision theory gizmo answer key - Loftus and palmer schema theory - Assignment 7.3: Final Exam and Reflective Essay - Holy family rockford il - Red energy service to property charge - 0.0455 moles of hydrochloric acid - Jolly phonics actions for parents - Red red red resistor value - LeaderAsChangeAgent_Assessment3 - Determination of the dissociation constant of a weak acid - Marquis de sade justine english pdf - Fire riser room requirements - What is the heat capacity of the unknown substance - Self theory response - Lord bernstein v skyviews and general ltd [1978] q.b. 479 - 1000 meters is how many kilometers - The physiology of stress - Www cambridge edu au go - Echoing green poem summary - Temperature in bacchus marsh - 540 paper - Hodder education textbook answers - "Navajo" - Triarchic theory of intelligence definition - Week 8 Assignment CL - Formal charge of mno4- - Tree trimming project - What is a ballista - What are the four types of hcpcs codes - Cisco mcs 7825 i3 - A white heron questions and answers - I want to become a soldier essay - Biological anthropology of the human skeleton - Should the american dream be capitalized - Case Study - Postmortem Plan - History of naa luro pdf - Internal rhyme poems by famous poets