Super easy statistics question in Excel

Mathematics

GBC

Question Description

Super easy statistics question in Excel

Super easy statistics question in Excel

Super easy statistics question in Excel

Super easy statistics question in Excel


Unformatted Attachment Preview

Hotel Reps Commission for This Month Sales Rep Emily Rob Michael Francine Mircea Helena Bridget Paolo TOTAL $ $ $ $ $ $ $ $ $ Sales 25,000.00 19,000.00 27,500.00 14,000.00 33,300.00 41,800.00 17,300.00 23,800.00 201,700.00 Commission This Month Commission Rate 12.50% Student Name Student I.D Week 3. Assignment 1. Exercise 2 Absolute References Open the Excel File Steps: 1. In cell C4: a. Create a formula that calculates the commission each salesperson made this month. 2. If you change the commission rate to 15% what is the total commission earned by the salespeople a. Write that value to the right of the data with the following title: 15% Commission. b. Put a thick outside border around the title and the amount. 3. Rename the title of the data on the spreadsheet from “This Month” to “January”. 4. Sort the data by commission earned from smallest to greatest. 5. In cell C12: a. Create a formula that calculates the total commission earned in January by all salespeople. b. Add a thick line between the amount of commission earned by the highest earning salesperson and the total commission paid in January. ...
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.
Tags: GBC

This question has not been answered.

Create a free account to get help with this and any other question!

Similar Questions
Related Tags