Question: Can you explain what excel formulas are needed to answer the questions below Using the provided spreadsheet find the answers to the following. The answers

Can you explain what excel formulas are needed to answer the questions below
Using the provided spreadsheet find the answers to the following. The answers must be on the spreadsheet with the formulas in the cells specified. Using cell F2, what is the total of all sales transactions? Using cell F3, what is the total of sales in June? Using cell F4, how many sales were made in August? Using cell F5, how many sales of transaction type 24 were made? Using cell F6, what is the average sales for all transactions? Using cell F7, what is the average sales for transactions in March? Using cell F8, what is the largest sales transaction? Using cell F9, what is the smallest sales transaction? Cust_ID Sales Transaction 3 $769.04 4 $246.74 4 $434.58 4 $180.63 1 $136.16 10 $474.66 4 $799.35 7 $623.58 1 $424.36 7 $847.26 3 $141.13 2 $274.34 7 $466.18 8 $580.43 0 $614.88 1 $915.87 6 $966.37 10 $889.54 8 $391.99 10 $979.63 0 $192.49 8 $633.51 8 $945.00 $811.16 7 $595.93 5 $829.87 8 $371.59 0 $605.53 7 $486.76 9 $242.35 2 $376.12 $647.86 3 $277.08 0 $432.43 3 $107.72 Month of Transaction August April October April April November January November October June October September September February March May April April September February August April October April March February August February October August April November February November August Type of Trans 8 25 4 32 18 24 18 41 74 5 11 71 70 56 32 51 98 11 51 26 14 7 1 68 79 42 26 71 27 5 62 2 39 29 53 NO 0000 Using the provided spreadsheet find the answers to the following. The answers must be on the spreadsheet with the formulas in the cells specified. Using cell F2, what is the total of all sales transactions? Using cell F3, what is the total of sales in June? Using cell F4, how many sales were made in August? Using cell F5, how many sales of transaction type 24 were made? Using cell F6, what is the average sales for all transactions? Using cell F7, what is the average sales for transactions in March? Using cell F8, what is the largest sales transaction? Using cell F9, what is the smallest sales transaction? Cust_ID Sales Transaction 3 $769.04 4 $246.74 4 $434.58 4 $180.63 1 $136.16 10 $474.66 4 $799.35 7 $623.58 1 $424.36 7 $847.26 3 $141.13 2 $274.34 7 $466.18 8 $580.43 0 $614.88 1 $915.87 6 $966.37 10 $889.54 8 $391.99 10 $979.63 0 $192.49 8 $633.51 8 $945.00 $811.16 7 $595.93 5 $829.87 8 $371.59 0 $605.53 7 $486.76 9 $242.35 2 $376.12 $647.86 3 $277.08 0 $432.43 3 $107.72 Month of Transaction August April October April April November January November October June October September September February March May April April September February August April October April March February August February October August April November February November August Type of Trans 8 25 4 32 18 24 18 41 74 5 11 71 70 56 32 51 98 11 51 26 14 7 1 68 79 42 26 71 27 5 62 2 39 29 53 NO 0000