On the June2017 worksheet, in cell 17, sum the values in E7:E24 if the purchase in column C is groceries. 13 In cell 18, average the values in E7:E24 if the purchase in column C is groceries In cell 19, calculate the number of times groceries were purchased during the month. On the June2017 worksheet, in cell 111, calculate the total amount spent on groceries using a credit card. 14 In cell 112, calculate the average spent on groceries using a credit card. In cell 113, calculate the number of times groceries were purchased using a credit card during the month Updated: 03/20/2017 Current Office 2016-myitlab:grader-Instructions Step Instructions On the June2017 worksheet, in cell F7, enter a nested function to determine if the transaction was paid using a credit card and the amount of the transaction is less than -100. If both conditions are met, the function should return the text Flag. For all others, the function should return the text OK. 15 Copy the function down through cell F24 On the June2017 worksheet, use the Advanced filter to display only the credit card transactions. Set the filter to copy the data to the range A31:E31 In cell 117, use the DAVERAGE function to determine the average amount spent for transactions meeting the criteria in the range A27:E28 16 On the June2017 worksheet, in cell 17, sum the values in E7:E24 if the purchase in column C is groceries. 13 In cell 18, average the values in E7:E24 if the purchase in column C is groceries In cell 19, calculate the number of times groceries were purchased during the month. On the June2017 worksheet, in cell 111, calculate the total amount spent on groceries using a credit card. 14 In cell 112, calculate the average spent on groceries using a credit card. In cell 113, calculate the number of times groceries were purchased using a credit card during the month Updated: 03/20/2017 Current Office 2016-myitlab:grader-Instructions Step Instructions On the June2017 worksheet, in cell F7, enter a nested function to determine if the transaction was paid using a credit card and the amount of the transaction is less than -100. If both conditions are met, the function should return the text Flag. For all others, the function should return the text OK. 15 Copy the function down through cell F24 On the June2017 worksheet, use the Advanced filter to display only the credit card transactions. Set the filter to copy the data to the range A31:E31 In cell 117, use the DAVERAGE function to determine the average amount spent for transactions meeting the criteria in the range A27:E28 16