Transcript mynde.sean.dale

Spreadsheets
Mynde
Sean
Daley
And maybe zombie john
What can a spreadsheet do
Store data
Sort data
Make calculations
Make graphs and charts
Data validation
Use macros to navigate to other pages or places of the spreadsheet
•
Spreadsheet s allows us to collect data and then calculate this data using
formulas.
•
A spreadsheet can create a various amount of charts and graphs from
varying range of data.
•
A spreadsheet is arranged in rows and columns.
Who are the main users of
spreadsheets





Accountants – They need to keep track of all the
money coming into the business and all the payments
going out.
Teachers – Need to keep track of marks given for
homework ect.
Engineers – Need to perform calculations when
designing bridges, buildings, aeroplanes, cars ECT.
sales people – They use spreadsheet to keep track of
the items they sell.
The main users of spreadsheets would be business
organizations and also schools and colleges
How can spreadsheets be used to
solve problems?

The way that spreadsheets solve problems is by using
formulas.

Excel has input functions that allow you to calculate
data such as SUM and COUNT.
•
The way that spreadsheets solve complex problems is
by using a variety of formulas which allows quick and
accurate calculations by using a range of fields.
•
Also pivot tables and also by using what IF scenarios
can be used.
How can organisations use
interpretation methods to analyse
data?


It analyses data by using charts, such as pie, line and bar
charts.
These charts can display patterns and trends.
•
With charts and trends businesses are able to analyse data.
•
These include pie charts, bar charts and line graphs.
•
Organizations are able to tell very easily between patterns
and trends and are easily able to make these charts and
graphs by using the chart wizard that is integrated within MS
Excel.