Farmers+Market

=You are keeping inventory for the local Farmer’s Market. Below are the six local farmers that bring produce to the market. You need to create a spreadsheet that reflects (shows) all the data for the **Farmer’s Market.**= = = = 14 Ears of Corn = = 13 Pecks of Peppers = || Farmer Johnson  20 Bushels of Beans = 16 Ears of Corn = = 15 Pecks of Peppers = || Farmer Newton  8 Bushels of Beans = 7 Ears of Corn = = 5 Pecks of Peppers = || = 12 Ears of Corn = = 19 Pecks of Peppers = || Farmer Steimer  15 Bushels of Beans = 22 Ears of Corn = = 6 Pecks of Peppers = || Farmer Henderson  22 Bushels of Beans = 7 Ears of Corn = 13 Pecks of Peppers || = = =Sort out the information before going to the computer by asking yourself the following questions?= = = = ü What is your title of your spreadsheet going to be?= = = = ü What are your ** Co **** l **** umn ** Headings going to be? //(**Remember: Column Headings are at the TOP of the COLUMN!)//= = = = ü What are your **Row** Headings going to be? //(**Remember: Row Headings are at the BEGINNING of your ROW!)//= = = = ü You will need a **Total** for Each Farmer. What function will you use? MUST USE FORMULAS = = = = ü You will also need a **Min, Max,** and **Average** for ** all of the produce. ** What will your functions be? MUST USE FORMULAS = = = = = = = =Now create the above data into your excel spreadsheet, last name_Farmer.= = = = = = = = = = = = = = = = = = = = = = = = = = =
 * Farmer Smith 12 Bushels of Beans
 * Farmer Saxton 14 Bushels of Beans