Download and open the file named exploring_e02_grader_a1.xlsx, and then save the file as exploring_e02_grader_a1_LastFirst.
Create a named range for cell B4 named Sales_Goal.
Insert a function in cell B24 to calculate the total sales for Q1 in column B.
Copy the total function into the range C24:E24 to calculate the totals of Q2 through Q4.
Insert functions in column F to calculate the sales totals of each individual sales rep.
Copy the function down to populate the remaining portion of column H. Be sure to use absolute or mixed referencing when necessary.
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.
Copy the function down to populate the remaining portion of column I. Be sure to use absolute or mixed referencing when necessary.
Insert a function in cell B28 to calculate Median of all sales in column F.
Insert a function in cell B29 to calculate average sales dollar amounts.
Insert a function in cell B30 to calculate the total number of sales reps.
Format the values in the range B11:E11 with Accounting Number Format.
Format the values in the range B12:E23 with Comma Style.
Insert a function in cell B3 to display the current date.
Format the totals in cells F11:F23 with Accounting Number Format.
Save the file and close Excel. Submit the file as directed.
We value our customers and so we ensure that what we do is 100% original..
With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.Read more
The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.Read more
The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.Read more
By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.Read more