1 / 19

Spreadsheet print screens

Spreadsheet print screens. I used my questionnaire questions for my spreadsheet. I used the data validation rule to validate each box so that no one can type irrelevant information into my spreadsheet. Testing validation.

harlow
Download Presentation

Spreadsheet print screens

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Spreadsheet print screens

  2. I used my questionnaire questions for my spreadsheet. I used the data validation rule to validate each box so that no one can type irrelevant information into my spreadsheet.

  3. Testing validation To test the validation for my spreadsheet I attempted to enter some random words in to my survey. The error box proves that my validation works because it won’t allow unrestricted words to be entered

  4. COUNTIF For countif I had to go to the small fx sign then search for the countif function. Once I had selected the countif function I had to enter the range or highlight the specific range e.g.. Foodpref or Healthy. Then I had to select the criteria I wanted such as “Meat” for Foodpref. I had to remember to put my criteria in speech marks so it would work.

  5. COUNTIFS For countif I had to go to the small fx sign then search for the countif function. Once I had selected the countif function I had to enter the range or highlight the specific range e.g. Foodpref or Healthy. Then I had to select the criteria I wanted such as “Meat” for Foodpref. I had to remember to put my criteria in speech marks so it would work. Then I had to repeat this again for Countifs.

  6. gender For each question I used the countif formula to collect my results then plotted them in graph form.

  7. age For each question I used the countif formula to collect my results then plotted them in graph form.

  8. Healthy? For each question I used the countif formula to collect my results then plotted them in graph form.

  9. Food preference For each question I used the countif formula to collect my results then plotted them in graph form.

  10. HEALTHY PORTION SIZES? For each question I used the countif formula to collect my results then plotted them in graph form.

  11. Eat 5 a day? For each question I used the countif formula to collect my results then plotted them in graph form.

  12. Water consumption For each question I used the countif formula to collect my results then plotted them in graph form.

  13. Keeping active? For each question I used the countif formula to collect my results then plotted them in graph form.

  14. How often? For each question I used the countif formula to collect my results then plotted them in graph form.

  15. How long? For each question I used the countif formula to collect my results then plotted them in graph form.

  16. Improving well being For each question I used the countif formula to collect my results then plotted them in graph form.

  17. How often? For each question I used the countif formula to collect my results then plotted them in graph form.

  18. Preferred activity For each question I used the countif formula to collect my results then plotted them in graph form.

  19. With friends or alone? For each question I used the countif formula to collect my results then plotted them in graph form.

More Related