exploring_ecap_grader_c2_Transactions_LastFirst. solution Homework | Page 5

11 On the June2015 worksheet, in cell I7, sum the values
9 in E7: E24 if the purchase in column C is groceries; in cell I8, average the values in E7: E24 if the purchase in column C is groceries; in cell I9, calculate the number of times groceries were purchased during the month.
12 On the June2015 worksheet, in cell I11, calculate the
9 total amount spent on groceries using a credit card; in cell I12, calculate the average spent on groceries using a credit card; in cell I13, calculate the number of times groceries were purchased using a credit card during the month.
13 On the June2015 worksheet, in cell F7, nest an AND
6 function within an IF 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 in the AND function, the function should return the text ​Flag​. For all others, the function should return the text ​OK​. Copy the function down through cell F24.