SMC Computer Science Rosedale Landscape and Garden Discussion
Description
Check the following file: SalaryClick on the attached file to view it. Please carefully review it. Then create the same file using Excel 2019. Once you complete it, save it using the following name: YourInitial_Quiz2_Salary.xlsx. Start your work using the following file: Excel File Salary
Don’t forget to add your name at the bottom of the file.You must use formulas for Commission, Bonus, Total Compensation, Total (Sales and Compensation), Average (Sales and Compensation), Highest (Sales and Compensation), and Lowest (Sales and Compensation) to earn credit. Not using formulas, you will receive zero.
Hints:
Commission column: is 5%. Use absolute reference to cell B10.
Bonus column: Sales reps receives bonus if their Sales is more than $25,000.
Total Compensation column: Add Commission and Bonus and Base Salary.
Use the appropriate formulas for Total, Average, Highest, and Lowest.Please submit the following file:
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."