2. Below the spreadsheet is where you will enter either aformula or function for each question. 3. Enter the Formula in theYELLOW HIGHLIGHTED cells only. Do not add any new data or any othercell IT NEEDS TO GO IN AN EXCEL WORKSHEET
Order Date Customer Region Sales Region Units
1/2/18AAJAAlaskaPacific US7351/7/18BJACGermanyEurope10001/12/18HIFIHawai’iPacific US32001/17/18JCRIGeorgiaAtlantic US9751/19/18WIMCWisconsinCentral US7161/22/18WA4GWashingtonPacific US40001/23/18AU9SAustriaEurope20001/23/18MITAMassachusettsAtlantic US62751/24/18MAPOMassachusettsAtlantic US14001/31/18FL95FloridaAtlantic US13252/1/18CASFCaliforniaPacific US12052/2/18OHMYOhioCentral US70002/4/18GAATGeorgiaAtlantic US40002/8/18TREXTexasCentral US49002/12/18PDOKUKEurope17652/14/18BJACGermanyEurope2002/16/18CDFMCaliforniaPacific US10002/22/18ILUIOhioCentral US16002/23/18GAOMGeorgiaAtlantic US20002/24/18AAJAAlaskaPacific US30003/7/18MIMCMichiganCentral US5003/8/18DMGRGermanyEurope17003/12/18AKFSAlaskaPacific US18003/17/18NCSTNorth CarolinaAtlantic US15003/28/18OKOKArkansasCentral US13503/29/18FLMIFloridaAtlantic US17003/30/18ARKSArkansasCentral US36504/2/18SWX2SwitzerlandEurope15004/7/18MAPOMassachusettsAtlantic US7504/9/18ATTXTexasCentral US10004/12/18SPTRHawai’iPacific US21005/1/18SWX1SwitzerlandEurope16005/7/18HV11SwitzerlandEurope20005/9/18S2SCTennesseeAtlantic US20505/9/18ORRCWashingtonPacific US2100
1) What is the Total Number of Units sold from Jan to May?
2) What is the Average Number of units sold from Jan to May?
3)
PayPal Gateway not configured
PayPal Gateway not configured