# Types And Purposes Of Graphic Representations

1024 Words5 Pages
Types and purposes of graphic representations
18. What is a graphic representation?
A graphic representation is a illustrative diagram that shows interdependencies between variables.
19. List seven different types of graphic representations.
Column charts, area charts, pie charts, bar charts, line charts, bubble charts and scatter diagrams
20. Describe when each of these seven graphic representations would best be used.
Column charts – to show us how the data may change over time or show us the difference between two items.
Area charts – to point out the amount of transformation over time and to highlight the entire value of a trend
Pie charts – to show proportional relationships and compare parts of a whole at a given time
Bar charts –
What is the purpose of a condition formula?
To assess whether the circumstances are true or false and make reasonable evaluations between expressions.
24. What is the purpose of a look up formula?
To gain a value from a table (in a range) by searching up another value.
25. What is the difference between a function and a formula?
Functions are formulas that are already set that complete calculations by using given values ( called arguments) in a specific order. Functions can be used to achieve simple or hard calculations.
26. What is the advantage of sorting data?
Sorting your data in a specific way helps you find the data you want much easier.
27. What is the advantage of filtering data?
The advantage of filtering the data, is that it breaks down your information so you can get to the main bit of information quicker.
28. Provide an example of when a person may use one of the mathematical functions of a spreadsheet.
A person may use a spreadsheet to keep track of the kilometres he travelled to work for taxation purposes.
29. Provide an example of when a person may use one of the financial functions of a spreadsheet.
A person might use a spreadsheet for financial functions in case he need to prepare a quote for a customer.
30. Provide an example of when a person may use one of the statistical functions of a spreadsheet.
A person might use a spreadsheet for statistical functions to find out how many students study a VCE subject within a school

Design elements
31. What