New Perspectives Excel 2016 Module 3: Textbook Project Ashley collins 1

New Perspectives Excel 2016 Module 3: Textbook Project

Ashley collins

1. Making Workbooks User-Friendly

To enter data on the sample plot.

To calculate the area of the sample plot.

To calculate the market weight of the corn.

To project the farm's total yield and revenue.

To apply cell styles to input values and calculated values.

2.  Using Excel Functions

To count the number of years in the corn yield history.

To analyze the corn yield history.

To calculate the minimum and maximum yield.

To find the median corn yield.

3. Non-graded - Performing What-If Analyses

4. Non-graded - Interpreting Error Values

5. AutoFilling Formulas and Data

To use AutoFill to extend a series of labels.

To copy the formula with the dates for the growing season with AutoFill.

To change the planting date.

6. Exploring Cell References

To correct the stage dates formulas with absolute cell references.

To calculate the GDD value.

7. Summarizing Data with the Quick Analysis Tool

To calculate a running total of GDD.

8. Working with Dates and Date Functions

To display the current date.

9. Using Lookup Functions

To use the VLOOKUP function to find yield information for hybrid CS6478.

To display other information about the hybrid CS6478.

10. Working with Logical Functions

To enter the IF function to specify whether the corn is ready for harvesting.

To display the harvest date for the corn crop.