Exploring Excel Chapter 2 Assessment Project 1 Formulas and Functions
- Vpqnrqhwk
- Rating : 40
- Grade : A+
- Questions : 2
- Solutions : 1079
- Blog : 0
- Earned : $19352.58
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
[Solved] Exploring Excel Chapter 2 Assessment Project 1 Formulas and Functions
- This solution is not purchased yet.
- Submitted On 20 May, 2017 02:34:31
- Vpqnrqhwk
- Rating : 40
- Grade : A+
- Questions : 2
- Solutions : 1079
- Blog : 0
- Earned : $19352.58
Exploring Access 7 H1 | Complete Solution
BTM8107-8 week 2 understanding and exploring assumptions correct answers
BTM8107-8 | Week: 2 | Activity: Understanding and Exploring Assumptions | Rated A+
For the variable “Day 1”:
From the histogram of the variable Day 1 we see that the histogram of day 1 looks like normal distribution but it’s curve is slightly above the normal curve so it is leptoku...
Test Bank for Exploring Psychology 12th Edition Myers
Test Bank for Exploring Psychology 12th Edition Myers
The benefits of buying study notes from CourseMerits
Assurance Of Timely Delivery
We value your patience, and to ensure you always receive your homework help within the promised time, our dedicated team of tutors begins their work as soon as the request arrives.
Best Price In The Market
All the services that are available on our page cost only a nominal amount of money. In fact, the prices are lower than the industry standards. You can always expect value for money from us.
