Create a workbook for the soybean cropCreate a workbook for the soybean crop

Management Application And Information Systems Assignment –

Excel Chapter 1 –

There are no Data Files needed for the Review Assignment. Game Card also buys and resells used games and gaming supplies. Peter wants to use Excel to record recent used purchases made by the store. The workbook should list every item the company has ordered, provide information about the item, and calculate the total order cost. Complete the following:

1. Create a new, blank workbook, and then save the workbook as Game List in the location specified by your instructor.

2. Rename the Sheet1 worksheet as Documentation, and then enter the data shown in Figure 1-42 in the specified cells.

3. Set the font size of the title text in cell A1 to 28 points.

Excel Chapter 2 –

Data Files needed for the Review Assignments: Menu.xlsx

Carol created a workbook that tracks the sales of individual items from the Morning Bean menu to share at an upcoming conference. She has already entered most of the financial formulas but wants you to calculate some additional values. She also asks you to format the workbook so that it will look professional and be easy to read and understand. Complete the following:

1. Open the Menu.xlsx workbook you downloaded from Blackboard and then Save as Menu Sales.

2. In the Documentation sheet, enter your name in cell B4 and the date in cell B5.

3. Change the theme of the workbook to Retrospect.

Excel Chapter 3 –

Data File needed for the Review Assignments: Soybean.xlsx

Another cash crop grown at Wingait Farm is soybeans. Jane wants you to create a workbook for the soybean crop similar to the workbook you created for the corn crop. The workbook should estimate the total yield and revenue from a small plot sample and compare that yield to the farm’s historic norms. The workbook should also track the soybean growth from planting to harvest. Complete the following:

1. Open the Soybean workbook you downloaded from Blackboard and then Save the workbook as Soybean Crop.

2. In the Documentation worksheet, enter your name in cell B3 and the date in cell B4.

3. The size of the soybean crop is 72 acres. Enter this value in cell B4 of the Yield worksheet.

4. The soybean sample comes from a plot of 4 rows each 7.5 inches wide and 21 inches long. Enter these values in the range B7:B9.

5. Within the plot, the farm has harvested 400 soybean pods with an average of 2.5 soybeans per pod. Enter these values in the B14:B15 range.

6. Apply the Input cell style to cells B4, B7:B9, and B14:B15.