Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show the formula in excel Division West West East North South West East South North North State Arizona Arizona Utah Utah Utah Arizona Arizona
Please show the formula in excel
Division West West East North South West East South North North State Arizona Arizona Utah Utah Utah Arizona Arizona Arizona Utah Arizona Employee Adam Hal Sam Carol Debbie Fred Alex Arron Max Jim January 23 54 65 34 56 76 43 9 89 56 February 32 33 55 87 90 78 71 23 56 76 March 56 78 34 52 25 79 9 4 56 April 12 14 16 65 34 88 76 54 34 67 May 12 56 78 66 54 32 21 23 63 21 June 12 54 78 47 64 24 23 35 78 43 July 34 76 89 23 102 21 67 53 23 96 August Septembe October November December 23 22 44 23 27 54 65 98 54 65 87 78 78 67 45 23 91 58 87 76 65 15 73 55 44 24 65 46 32 34 87 36 88 17 34 54 32 64 32 76 35 12 32 85 34 77 45 46 45 67 7 Use the AVERAGEIF function to calculate average April sales for employees in the South division Use the AVERAGEIFS function to calculate average March sales for employees in the North division of Utah Using the VLOOKUP function, create an equation that will show the January sales for an employee whose name is typed in the green box belowStep 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