Messages
Proposals
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
BUS 180:301
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
| Writer | Writer Name | Amount | Client Comments & Rating |
|---|---|---|---|
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! |
Custom Original Solution And Get A+ Grades
Custom Original Solution And Get A+ Grades
Custom Original Solution And Get A+ Grades
| Writer | Writer Name | Offer | Chat |
|---|---|---|---|
ONLINE |
Helping HandI am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements. |
$110 | Chat With Writer |
ONLINE |
Homework GuruHi dear, I am ready to do your homework in a reasonable price and in a timely manner. |
$112 | Chat With Writer |
ONLINE |
Top Essay TutorI have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades. |
$115 | Chat With Writer |
ONLINE |
Best Coursework HelpI am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements. |
$110 | Chat With Writer |
ONLINE |
University Coursework HelpHi dear, I am ready to do your homework in a reasonable price. |
$112 | Chat With Writer |
ONLINE |
Calculation GuruI see that your standard of work is to get content for articles. Well, you are in the right place because I am a professional content writer holding a PhD. in English, as well as having immense experience in writing articles for a vast variety of niches and category such as newest trends, health issues, entertainment, technology, etc and I will make sure your article has all the key pointers and relevant information, Pros, Cons and basically all the information that a perfect article needs with good research. Your article is guaranteed to be appealing, attractive, engaging, original and passed through Copyscape for the audience so once they start reading they keep asking for more and stay interested. |
$105 | Chat With Writer |
Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.