1 / 5

Spread Sheet Evidence

Spread Sheet Evidence. Lucy Woods. Firstly I inputted all the results that I obtained from my questionnaire under the relevant column titles and insured I had a drop down box created by data validation for each individual cell.

nicola
Download Presentation

Spread Sheet Evidence

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. Spread Sheet Evidence Lucy Woods

  2. Firstly I inputted all the results that I obtained from my questionnaire under the relevant column titles and insured I had a drop down box created by data validation for each individual cell. Each cell had various options that could be imputed to avoid incorrect answers being entered.

  3. Testing the Validation Rule • By imputing a value that did was not acceptable for that specific field this warning notice appeared showing that my validation rule works.

  4. From the results I obtained I then had to find the percentage of people who gave each answer. This was achieved by using a ‘COUNTIF’ statement. A COUNTIF statement the range of cells that you want to count based on the criteria and gives less chance of human error. In this case to obtain the number of males that took park in the survey I did the equation =COUNTIF( gender, “Male”).

  5. I then decided to display my results in a pie chart and annotated them describing what the results showed.

More Related