Question: Provide the formula Q3: 10 points Your manager has given you a table of raw data to perform analysis on. You have been tasked to
Provide the formula
| Q3: 10 points | Your manager has given you a table of raw data to perform analysis on. You have been tasked to | ||||||||||||||||||
| find a flexible way to show the average Sales Revenue in different months for different regions. | |||||||||||||||||||
| Use Subtotalalong with the filter to show theaverage sales revenue in March for the south region in cell H5. | |||||||||||||||||||
| Average | |||||||||||||||||||
| Store | Month | Region | Sales Revenue | ||||||||||||||||
| RSE001 | Jan | East | $ 1,690.00 | ||||||||||||||||
| RSE001 | Feb | East | $ 1,830.00 | ||||||||||||||||
| RSE001 | Mar | East | $ 1,569.00 | ||||||||||||||||
| RSE001 | Apr | East | $ 2,046.00 | ||||||||||||||||
| RSE002 | Jan | East | $ 1,974.00 | ||||||||||||||||
| RSE002 | Feb | East | $ 4,212.00 | ||||||||||||||||
| RSE002 | Mar | East | $ 3,256.00 | ||||||||||||||||
| RSE002 | Apr | East | $ 3,478.00 | ||||||||||||||||
| RSN001 | Jan | North | $ 1,976.00 | ||||||||||||||||
| RSN001 | Feb | North | $ 2,109.00 | ||||||||||||||||
| RSN001 | Mar | North | $ 1,946.00 | ||||||||||||||||
| RSN001 | Apr | North | $ 2,963.00 | ||||||||||||||||
| RSN002 | Jan | North | $ 1,922.00 | ||||||||||||||||
| RSN002 | Feb | North | $ 1,876.00 | ||||||||||||||||
| RSN002 | Mar | North | $ 2,127.00 | ||||||||||||||||
| RSN002 | Apr | North | $ 3,365.00 | ||||||||||||||||
| RSS001 | Jan | South | $ 2,089.00 | ||||||||||||||||
| RSS001 | Feb | South | $ 2,221.00 | ||||||||||||||||
| RSS001 | Mar | South | $ 2,082.00 | ||||||||||||||||
| RSS001 | Apr | South | $ 1,565.00 | ||||||||||||||||
| RSS002 | Jan | South | $ 2,070.00 | ||||||||||||||||
| RSS002 | Feb | South | $ 2,089.00 | ||||||||||||||||
| RSS002 | Mar | South | $ 1,983.00 | ||||||||||||||||
| RSS002 | Apr | South | $ 2,146.00 | ||||||||||||||||
| RSS003 | Jan | South | $ 2,120.00 | ||||||||||||||||
| RSS003 | Feb | South | $ 1,999.00 | ||||||||||||||||
| RSS003 | Mar | South | $ 2,107.00 | ||||||||||||||||
| RSS003 | Apr | South | $ 1,782.00 | ||||||||||||||||
| RSS004 | Jan | South | $ 1,457.00 | ||||||||||||||||
| RSS004 | Feb | South | $ 1,560.00 | ||||||||||||||||
| RSS004 | Mar | South | $ 2,136.00 | ||||||||||||||||
| RSS004 | Apr | South | $ 1,956.00 | ||||||||||||||||
| RSW001 | Jan | West | $ 1,880.00 | ||||||||||||||||
| RSW001 | Feb | West | $ 2,135.00 | ||||||||||||||||
| RSW001 | Mar | West | $ 2,728.00 | ||||||||||||||||
| RSW001 | Apr | West | $ 2,024.00 | ||||||||||||||||
| RSW002 | Jan | West | $ 1,993.00 | ||||||||||||||||
| RSW002 | Feb | West | $ 1,289.00 | ||||||||||||||||
| RSW002 | Mar | West | $ 1,649.00 | ||||||||||||||||
| RSW002 | Apr | West | $ 2,003.00 | ||||||||||||||||
| RSW003 | Jan | West | $ 1,882.00 | ||||||||||||||||
| RSW003 | Feb | West | $ 2,760.00 | ||||||||||||||||
| RSW003 | Mar | West | $ 2,249.00 | ||||||||||||||||
| RSW003 | Apr | West | $ 4,863.00 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help