Question: Calculation Bonus: Use if statement to calculate 5 % bonus for sales above 1 , 5 0 0 , 3 % bonus for sales between

Calculation Bonus: Use if statement to calculate 5% bonus for sales above 1,500,3% bonus for sales between 1,000 and 1,500,0% and No bonus for sales below 1,000.
(3 Marks)
Calculate the count for Smartphones, Laptop, and Tablets
(3 Marks)
Use formulas to calculate the Bonus will increase on the 10th Month by 6%
(2 Marks)
Calculate the highest and lowest number of sales records."
(2 Marks)
Create a 3D Pie chart to display monthly total sales trend (Add appropriate data labels, chart tities, and legends.)
(3 Marks)
Bold, Merge and center. "Richfield Sales & Financial Performance Analysis"
(2 Marks)
Apply Wrap text on the headings, 50 degrees add shade with blue colour.
(2 Marks)
Save the file as: [YourName]_ComprehensiveAnalysis.
(1 Marks)
Calculation Bonus: Use if statement to calculate

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!