art 3 COMPLETION ( 28 points) Given the cash flow of the company is $3,000,000, show the formula using nested I with only one = sign) to formulate the following condition: a. if the cash flow is at le you will buy this company, if not, then if the cash flow is at least $285,000, then you this company, if these two conditions all failed, then you will decide not to buy this excel spreadsheet to test your result first before copying them to the space below of you have more than one equal sign, that means you are not doing it correctly, point, Nested IF we did in class has only one = sign and multiple if statements] =IF(AND(B6>=C3,B6=C2,B2,B4)) 2. Write the complete excel formula for each of the following: A. Subtract the contents of cell F6 from cell F5. (3 points) B. Add the contents of cells A5, A7, and A9. (3 points) C. Multiply the contents of cell B12 by the contents of cell A6. (4 points) 3. Name the command that does each of the following: A. Copies cell formatting from one cell to another. (2 points) B. Adds all values in the column directly above the selected cell. (2 points) C. Creates a single cell from multiple selected cells. ( 2 points) art 3 COMPLETION ( 28 points) Given the cash flow of the company is $3,000,000, show the formula using nested I with only one = sign) to formulate the following condition: a. if the cash flow is at le you will buy this company, if not, then if the cash flow is at least $285,000, then you this company, if these two conditions all failed, then you will decide not to buy this excel spreadsheet to test your result first before copying them to the space below of you have more than one equal sign, that means you are not doing it correctly, point, Nested IF we did in class has only one = sign and multiple if statements] =IF(AND(B6>=C3,B6=C2,B2,B4)) 2. Write the complete excel formula for each of the following: A. Subtract the contents of cell F6 from cell F5. (3 points) B. Add the contents of cells A5, A7, and A9. (3 points) C. Multiply the contents of cell B12 by the contents of cell A6. (4 points) 3. Name the command that does each of the following: A. Copies cell formatting from one cell to another. (2 points) B. Adds all values in the column directly above the selected cell. (2 points) C. Creates a single cell from multiple selected cells. ( 2 points)