Cengage Learning, Cengage Learning

4/8/2019 Print Preview
https://ng.cengage.com/static/nb/ui/evo/index.html?eISBN=9781305880733&id=451147811&snapshotId=1108938&dockAppUid=101&nbId=1108938& 1/6
Chapter 3: Performing Calculations with Formulas and Functions: 3-15 Chapter Review
Book Title: New Perspectives Microsoft Office 365 & Excel 2016 Comprehensive
Printed By: Chenyan Xu (chenyan.xu@stockton.edu)
© 2017 Cengage Learning, Cengage Learning
3-15 Chapter Review
3-15a Practice: Review Assignments
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
Download the Soybean workbook from Blackboard, open it and then save it 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
4/8/2019 Print Preview
https://ng.cengage.com/static/nb/ui/evo/index.html?eISBN=9781305880733&id=451147811&snapshotId=1108938&dockAppUid=101&nbId=1108938& 2/6
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.
7
Using the equations described in the Formulas worksheet, enter the following
calculations:
In cell B10, calculate the area of the plot sample in inches.
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). Display the
result to four decimal places.
In cell B16, calculate the total number of seeds harvested in the sample.
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).
Display the value to two decimal places.
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 four decimal places.
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
4/8/2019 Print Preview
https://ng.cengage.com/static/nb/ui/evo/index.html?eISBN=9781305880733&id=451147811&snapshotId=1108938&dockAppUid=101&nbId=1108938& 3/6
sample in acres. Display the value as an integer.
8
Calculate the following values for soybean yield and revenue:
In cell B20, calculate the farm’s average soybean yield using the values
in column E. Use the ROUND function to round that average value to
the nearest integer.
In cell B21, calculate the farm’s median soybean yield from the values in
column E.
In cell B24, calculate the farm’s total production of soybeans in bushels
by multiplying the bushels per acre value by the total number of acres
that the farm devotes to soybeans. Display the value as an integer.
In cell B25, calculate the total revenue from the soybean crop by
multiplying the total bushels harvested by the current price per bushel
(cell H7). Display the value using the Accounting format style.
9
Apply the Calculation style to the range B10:B11,B16:B21,B24:B25.
10
Use Goal Seek to determine what value in cell B4 (the number of acres
devoted to soybeans) will result in a total soybean revenue of $40,000.
11
In the Growth worksheet, in cell B5, enter a formula with a function to display
the current date.
12
4/8/2019 Print Preview
https://ng.cengage.com/static/nb/ui/evo/index.html?eISBN=9781305880733&id=451147811&snapshotId=1108938&dockAppUid=101&nbId=1108938& 4/6
Use AutoFill to insert the text strings Day 1 through Day 112 in the range
D5:D116.
13
In cell G5, calculate the Growing Degree Days (GDD) for the first day of the
season using the formula described in the Formulas worksheet and the
temperature range values in the range L6:M9. (Hint: Use the same formula
used in the tutorial for corn, but enter the T , T , and base values directly min max
in the formula. Be sure to use absolute references for the temperature range
values.)
14
Copy the formula in cell G5 to the range G5:G112.
15
Use the Quick Analysis tool to calculate the cumulative total of the GDD
values from the range G5:G112, placing those values in the range H5:H112.
16
In cell B9, enter 5/12/2017, which is the date the farm will start planting the
soybean crop.
17
In cell J5, enter a formula to display the date from cell B9. In cell J6, enter a
formula to increase the date in cell J5 by one day. Copy the formula in cell J6
to the range J6:J112 to enter the dates for the growing season.
18
In cell B8, enter M070 as the maturity group for the current soybean hybrid.
4/8/2019 Print Preview
https://ng.cengage.com/static/nb/ui/evo/index.html?eISBN=9781305880733&id=451147811&snapshotId=1108938&dockAppUid=101&nbId=1108938& 5/6
19
In cell B10, use the VLOOKUP function to retrieve the cumulative GDD value
for the M070 hybrid. (Hint: The range L12:M21 displays the cumulative GDD
for each maturity group.)
20
In cell I5, enter an IF function that tests whether the cumulative GDD value in
cell H5 is greater than the maturity value in cell B10. Use an absolute
reference to cell B10. If the condition is true, return the text string “Ready”;
otherwise, return the text “Not Ready”. Copy the formula to the range I5:I112.
21
In cell B11, insert a VLOOKUP function using the values in the columns I and
J that returns the date on which the Harvest Ready value is first equal to the
text string “Ready”.
22
In cell B12, calculate the number of days between planting and harvesting by
subtracting the planting date (cell B9) from the harvest date (cell B11).
23
Save and close the workbook, and then submit it onto Blackboard.
Chapter 3: Performing Calculations with Formulas and Functions: 3-15 Chapter Review
Book Title: New Perspectives Microsoft Office 365 & Excel 2016 Comprehensive
Printed By: Chenyan Xu (chenyan.xu@stockton.edu)
© 2017 Cengage Learning, Cengage Learning
© 2019 Cengage Learning Inc. All rights reserved. No part of this work may by reproduced or used in any form or by any means – graphic, electronic, or mechanical, or in any other
manner – without the written permission of the copyright holder.

Fountain Writers
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.

See all services