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.