excel chapter 2 grader* project [assessment 1]
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