![wingait soybean excel 2016 review chegg wingait soybean excel 2016 review chegg](https://www.coursehero.com/thumb/57/12/571250436491ab9e52c12263cde7275d900fe08f_180.jpg)
![wingait soybean excel 2016 review chegg wingait soybean excel 2016 review chegg](https://www.coursehero.com/thumb/05/b8/05b85cd34cf421914a8a6846a51721736a948672_180.jpg)
Calculate the following values for soybean yield and revenue:a. In cell B19, estimate the farm’s soybean yield in bushels per acre by dividing the number of bushels in the plot sample by the area of the sample in acres. Display the value to four decimal places.f. In cell B18, convert the weight to bushels by dividing the weight in pounds by the number of pounds of soybeans in one bushel (cell H6). Display the value to two decimal places.e. In cell B17, calculate the weight of the sample in pounds by dividing the number of seeds by the number of seeds in one pound (cell H5). In cell B16, calculate the total number of seeds harvested in the sample.d. Display the result to four decimal places.c. In cell B11, convert the sample area to acres by dividing the value in cell B10 by the number of square inches in an acre (cell H4). In cell B10, calculate the area of the plot sample in inches.b. Using the equations described in the Formulas worksheet, enter the following calculations:a. Apply the Input cell style to cells B4, B7:B9, and B14:B15.7. Enter these values in the B14:B15 range.6. Within the plot, the farm has harvested 400 soybean pods with an average of 2.5 soybeans per pod. The soybean sample comes from a plot of 4 rows each 7.5 inches wide and 21 inches long. Enter this value in cell B4 of the Yield worksheet.4. The size of the soybean crop is 72 acres. In the Documentation worksheet, enter your name in cell B3 and the date in cell B4.3. Open the Soybean workbook located in the Excel3 > Review folder, and then save the workbook as Soybean Crop in the location specified by your instructor.2. The workbook should also track the soybean growth from planting to harvest. The workbook should estimate the total yield and revenue from a small plot sample and compare that yield to the farm’s historic norms. Jane wants you to create a workbook for the soybean crop similar to the workbook you created for the corn crop. By New Perspectives Microsoft Office 365 & Excel 2016 (1st Edition) Edit edition Solutions for Chapter 3.2 Problem 1RA: Data File needed for the Review Assignments: Soybean.xlsxAnother cash crop grown at Wingait Farm is soybeans.