Create a workbook for the soybean crop

Reference no: EM132323151

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.

Figure - Documentation sheet data
Cell	Text
A1	Game Card
A3	Author
A4	Date
A5	Purpose
B3	your name
B4	current date
B5	To record game acquisitions for Game Card

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.

Reference no: EM132323151

Questions Cloud

Future trends in general american culture and sub cultures : Future trends and patterns in general American culture and sub-cultures. What do you believe are the most significant general U.S. cultural patterns? Why?

Worked hard on multiple levels of communication : This quarter you have worked hard on multiple levels of communication. Describe 3 personal scenarios in which you have utilized some of learning from quarter.

Based on insight from the emirate case : Based on insight from the Emirate case, what is your analysis of the actions and responses undertaken by competing firms in the Airline industry?

The separation between social or ethnic groups is called : The separation between social or ethnic groups is called. The area surrounding a service from which customers are attracted is the market area or

Create a workbook for the soybean crop : CS245 Management Application And Information Systems Assignment, Fisher College, USA. Create a workbook for the soybean crop

Write a scenario how you would you a logical function : How/or when would you use this function. Write a scenario how/or when you would you a Logical function (do not write an equation)

Outline areas of high legal risk for organisations : BULAW5911 - Demonstrate understanding of the legal/regulatory environment and relevant laws as well as economic, ethical, social/cultural, international

Challenges faced by international student in english : Challenges faced by international student in English language in Australia - Business Research Project Assignment - Business Research Project Report

Write pseudo code - biorythm 1 : Two programs biorythm 1 and BIORYTHM 2 with cos and sin, you only need to write throry section which is written in the word file table

User Account

All Pages