Using Spreadsheets - Classroom Questions


Spreadsheet Sample Questions

  1. Use the Muffins spreadsheet: What is the formula for determining how much Honey is needed to make 24 muffins?

[Use a pair of keys together, Control and Tilde (ctrl tilde), to change the display to formula view to make it easier to read and find the answer. Using those keys again toggles back to the results or calculation view.]


     


     
     

  1. Use the U.S. Debt spreadsheet: If the population in 1990 had been 1 billion greater, what would be the per capita debt in 1990 dollars?

[Make the spreadsheet do the work. Change one number in the spreadsheet to being 1 billion larger, then note the change to the per capita debt and record that answer.]


     

     
     
     

  1. Use the Bowling Scores spreadsheet: If Sam Thomas had bowled a 300 in Week 5, how much would this have brought up the team average for the week? What formula is needed to determine team average for week 5? [Trick questions but the info you need to understand and compute the answer in the spreadsheet.] What formula is used to find the team's overall average? How much would Sam's new score have brought up their average from all games?

  2.  

     
     
     

  3. Use the Nutrient spreadsheet: How milligrams of Vitamin C are in 5 servings of Cooked Fresh Carrots and 5 servings of Apples?

[Read the spreadsheet carefully. Only enter numbers in one column and zero out the calculator before each new problem.]


     

     
     
     

  1. Use the Nutrient spreadsheet: What is the total number of milligrams of Protein in a meal for the hungry campers: 4 servings of hamburger patty, 8 servings of chicken drumsticks,a dn 4 servings of baked potato?

  2.  

     
     
     

  3. Use the Nutrients spreadsheet: In addition to 1 serving of Baked potato, one serving of which food would provide the greatest total amount of Vitamin C?

  4.  

     
     
     

  5. How many servings of Chicken Drumsticks will give the same amount of Protein as 72 servings of Cooked Fresh Carrots?

  6.  

     
     
     

  7. The trail guide says that you need a meal that provides 162 milligrams of calcium. Which combination of two items of two servings will provide you at least with these nutrient totals? You can choose from Spinach, Cooked Fresh Carrots and Raw Cabbage?

  8.  

     
     
     


Return to the top of this page.


[Up] [Pageauthor Houghton] [College] [University]


Dr. Robert S. Houghton, Copyright, 1994-present.