Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Data table to complete Task 1, Task 2 and Task 3 Task 2: Conditional formatting. a) If the Sales or Cost is LESS than average
Data table to complete Task 1, Task 2 and Task 3 | Task 2: Conditional formatting. | |||
a) If the Sales or Cost is LESS than average | ||||
Year | Sales | Cost | Sales or Cost the format will be - | |
2001 | 923,859 | 755,087 | ||
2002 | 1,222,054 | 961,643 | a) If the Sales or Cost is MORE than average | |
2003 | 1,250,365 | 1,008,292 | Sales or Cost the format will be - | |
2004 | 1,176,787 | 925,430 | ||
2005 | 995,720 | 788,576 | ||
2006 | 1,324,534 | 1,067,627 | ||
2007 | 1,260,340 | 992,272 | ||
Task 1: Calculate the following. | ||||
Total Sales: | ||||
Average Sales: | ||||
Total Cost: | ||||
Average Cost: | ||||
Highest Sales: | ||||
Lowest Sales: | ||||
Highest Cost: | ||||
Lowest Cost: |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started