AICT 1 15F‎ > ‎Spreadsheets‎ > ‎

Lesson 6

  1. You run a bakery where you make all sorts of cookies.
  2. Create a dataset of four columns and twelve rows.
  3. Label the columns with the types of cookies.
  4. Label the rows with the months of the year.
  5. Use the IF function to print "Yippee!" at the end of the row if it adds up to 16 (or some other number that you determine). 
    • At least one row should print "Yippee!"
  6. Use the IF function to print "Rats!" if it doesn't add up to 16 (or some other number that you determine).
    • At least one row should print "Rats!"
Comments