The instructions are attached for the excel worksheets which are also attached. Just complete the assignment and save and upload the completed excel back into study pool. 🙂
Excel 2021 Skills Approach – Ch 6 Challenge Yourself 6.3 – SIMnet
1 of 5
https://coastalcarolina.simnetonline.com/sp/assignments/projects/details…
Print Info
Student Name: Cromedy, Ashauna
Student ID: abcromed1@coastal.edu
Username: abcromed1@coastal.edu
Excel 2021 Skills
Approach – Ch 6
Challenge Yourself 6.3
Personal Assignment? Yes
COURSE NAME CSCI*110*D3 Enterprise Business Applicatns 23/FA | CSCI 110 Fall 2023 – Section D3
Start Date:
11/07/202312:00 AM
US/Eastern
Due Date:
12/12/202311:59 PM
US/Eastern
End Date:
12/12/202311:59 PM
US/Eastern
Challenge Yourself 6.3
These instructions are compatible with both Microsoft
Windows and Mac operating systems.
In this project, you are an accountant for National Pharmaceutical Sales. You
want to make a spreadsheet that contains each sales associate’s statistics.
Because the company has over 100 sales associates, only a partial
12/10/23, 9:25 PM
Excel 2021 Skills Approach – Ch 6 Challenge Yourself 6.3 – SIMnet
2 of 5
https://coastalcarolina.simnetonline.com/sp/assignments/projects/details…
spreadsheet will be provided. Please follow the steps below to complete the
partial spreadsheet.
Skills needed to complete this project:
!”Extracting Text with RIGHT, LEFT, and MID (Skill 6.1)
!”Using the IFS Function (Skill 6.13)
!”Rounding with Functions (Skill 6.2)
!”Finding the Middle Value with MEDIAN (Skill 6.7)
!”Calculating the Standard Deviation (Skill 6.8)
!”Using SUMIF and SUMIFS (Skill 6.4)
!”Using AVERAGEIF and AVERAGEIFS (Skill 6.5)
!”Using Database Functions (Skill 6.20)
!”Managing Errors with the IFERROR Function (Skill 6.21)
!”Analyzing Complex Formulas Using Evaluate Formula (Skill 6.22)
Steps to complete this project:
Mark the steps as checked when you complete them.
1.
Open the start file EX2021-ChallengeYourself-6-3. The file will be
renamed automatically to include your name.
2.
If the workbook opens in Protected View, click the Enable Editing button
in the Message Bar at the top of the workbook so you can modify the
workbook.
3.
On the Sales Data worksheet, enter a formula in cell J4 to find the sales
associate’s region by extracting the first three characters of the sales
associate’s ID in cell C4. Use cell references where appropriate. Fill the
formula down through cell J64.
4. On the Sales Data worksheet, calculate the commission rate and
commission paid for each sales associate.
a.
Beginning in cell F4, enter a formula using the IFS function to calculate
the commission rate based on the following table. Hint: Do not include
comma separators in numerical values in formulas. Excel interprets
commas as function argument separators.
IF ANNUAL SALES ARE:
THEN THE COMMISSION RATE IS:
12/10/23, 9:25 PM
Excel 2021 Skills Approach – Ch 6 Challenge Yourself 6.3 – SIMnet
3 of 5
b.
https://coastalcarolina.simnetonline.com/sp/assignments/projects/details…
>=225,000
7%
>=175,000
5%
>=100,000
3%