AO 4 Create a Spreadsheet to Analyse the Data

Task 1

Use formulae/functions to analyse the results of the questionnaire and present the results in tables on a separate sheet.

Format these tables to make them easier to read as they will be used in a presentation showing your findings.

Task 2

Produce graphs that clearly show your findings.

You will have to explain your results in a presentation later so make sure they graphs have all the correct labels and titles. You should use three different type of graph if possible.

Task 3

Give the spreadsheet a more user friendly appearance by adding formatting