[Solved] Using Functions Nested Functions Must Use Functions Receive Credit B C Click Worksheet Ti Q37187631

Using IF Functions and Nested AND Functions. *You must use IF and AND functions to receive credit. a. b. c. Click on the worksheet titled “Field Profitability Report”. Apply filters to the data set. Sort the data by crops from A to Z. Insert an IF function in cell G2 to calculate the cost per acre of each crop based on the information given in the table in range J4:M8. Insert a mathematical formula in cell H2 to calculate the Profit Per Acre using the Yield from each field, the price for each crop, and the Cost Per Acre. Price of commodities is given to you in the table in range J4:M8. d. Filter the table to only display Cotton fields. Insert an IF Function with a Nested AND function in cell 12 to determine Profitable e. f. Cotton Farms. Hint: The Value if True argument is “Keep Farming” and the Value if False is “Stop Leasing Farm”.) .3 2.7 2 3 2 3 6 102 2 3 36 43 48 39 8 z 42 30. 82 ns Cr Co Co Co Co Co Co Co Co Co Co Co Co 96 42 SS 80 | 79-88 18 44 6 85 47 105 19 56 57 96 29 39 27-28 72 83 111 83 20 69-42 09 1 01-2 3 i i i i i 12-22-2 22 22 2 Cost per Acre Profit Per Acre Profitable Cotton Far 1 Price of Commodities CORN WHEAT COTTON SOYBEANS Cost Per Acre 3.35 Corn $4.85 |WHEAT $0.70 cOTTON 59.50 SOYBEANS $491.00 $414.00 $657.00 $406.00 Show transcribed image text Using IF Functions and Nested AND Functions. *You must use IF and AND functions to receive credit. a. b. c. Click on the worksheet titled “Field Profitability Report”. Apply filters to the data set. Sort the data by crops from A to Z. Insert an IF function in cell G2 to calculate the cost per acre of each crop based on the information given in the table in range J4:M8. Insert a mathematical formula in cell H2 to calculate the Profit Per Acre using the Yield from each field, the price for each crop, and the Cost Per Acre. Price of commodities is given to you in the table in range J4:M8. d. Filter the table to only display Cotton fields. Insert an IF Function with a Nested AND function in cell 12 to determine Profitable e. f. Cotton Farms. Hint: The Value if True argument is “Keep Farming” and the Value if False is “Stop Leasing Farm”.)
.3 2.7 2 3 2 3 6 102 2 3 36 43 48 39 8 z 42 30. 82 ns Cr Co Co Co Co Co Co Co Co Co Co Co Co 96 42 SS 80 | 79-88 18 44 6 85 47 105 19 56 57 96 29 39 27-28 72 83 111 83 20 69-42 09 1 01-2 3 i i i i i 12-22-2 22 22 2
Cost per Acre Profit Per Acre Profitable Cotton Far 1 Price of Commodities CORN WHEAT COTTON SOYBEANS Cost Per Acre 3.35 Corn $4.85 |WHEAT $0.70 cOTTON 59.50 SOYBEANS $491.00 $414.00 $657.00 $406.00

Expert Answer

---

Answer to Using IF Functions and Nested AND Functions. *You must use IF and AND functions to receive credit. a. b. c. Click on the… . . .