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

Ocr m1 june 2014 - Persona shadow anima self - A.1 risk management - Pos inbound processing engine - Create scrum board in excel - First order wave equation - Why is uluru on the world heritage list - Margaret newman nursing theory - Animal farm student workbook answer key - Import odeint function in python - 12 pm on 24 hour clock - Who is the protagonist in trifles - Warp and weft of fabric - Alpha decay equations worksheet - Force table and vector addition of forces lab report - Lead and lag indicators - Zone of proximal development social constructivism - Note search - Creed shreds 4 a thousand yasseahs - Ansys gpu acceleration supported cards - Instituting policies and procedures that facilitate strategy execution - Dynamic environment of international trade - Does history repeat itself evidence from the course - General language stimulation techniques - Why doesn't george help lennie in the fight - Lincoln elementary white bear lake - 0.78 inches to cm - Ballad of sexual dependency pdf - Large Scale Assessments - Architecturally exposed structural steel specifications connections details - Fat leo restaurant brighton - Schilders arm extension test - Poetry #2 - Powershift rc dead man switch - Macrowikinomics new solutions for a connected planet pdf - River red gum facts - Laboratory activities for general biology i custom fgcu - A class divided questions and answers - Week 3 - Nearest telstra exchange to me - Case study teamwork in the workplace - Did ferdinand magellan accomplish his goal - Case Study - Advantages of a multicultural society and labor force - Journal entry 15 on course - Week 9 assignment NS - 5 pillars of sustainable change - Table - Database performance tuning and query optimization ppt - Reid chocolates is considering a third layout - Supply and demand of nike shoes - Week 6 BUS320: E-Commerce and E-Business - Coefficient of restitution units - Best buy income statement and balance sheet - Calusa mid back chair assembly instructions - Bcp brake pads review - Nova chlorinators and spares - Periodic inventory system income statement - 1220 katharine street helena valley - Projectile motion with air resistance examples - Swot analysis disney parks and resorts - Entering the academic conversation - Education Policy - Isbn 13 978 1496300232 - Conifer corp case study - Internet systems development - Egotism - Act 1 macbeth quotes - Shoreline stadium case study answers - Digital Forensics. assignment 15 - What is a nursing practice problem - Discussion 250 words. Make sure you provide 2 references and utilize APA style.. . - 2.2 lbs to kg - MKT457: E-Marketing - Target audience for hair extensions - Gomez runs a small pottery firm - Change Theory - Cat 950m operators manual - Discussion - What is the most populated state in australia - Amelia sung vsim - The blair reader 9th edition table of contents - The developing person through the lifespan chapter 1 - A disk with an initial angular velocity - Activities - Inf 103 week 1 discussion 2 - NEED IN 6 HOURS or LESS - Bono the monkey book - New heritage doll company capital budgeting excel - William henry ancient aliens necklace - NEED IN 15 HOURS or LESS - +27737189846®Sharjah WORKING=SAFE MISOPROSTOL & MIFEPRISTONE FOR SALE Sharjah®BUY MIFEGEST KIT, - The balance sheet for stud clothiers is shown below - Balanced equation for zinc acetate and sodium phosphate - Abc elmo stuck in spanish - Http www pbs org wgbh pages frontline storm view - Https www caremark com startnow - What does isol stand for - Cate bandel nina leonard - Suspense in the most dangerous game worksheet answers