Unit 42 | [Author Name]
UNIT: 42 How can spreadsheets be used to solve complex problems
Contents
Task 1 ................................................................................................................................................................................................ 2
Analysis of data ......................................................................................................................................................................... 1
Data mining.................................................................................................................................................................................. 2
Supporting decision making ..................................................................................................................................................... 2
Cash flow forecasting ................................................................................................................................................................ 2
Budget control ............................................................................................................................................................................. 2
Trend analysis ............................................................................................................................................................................. 3
Task 2 ................................................................................................................................................................................................ 4
How organizations can use interpretation methods to analyze data ............................................................................ 4
Figure 1 (data-ink, n.d.)
Spreadsheets are very useful when you need to collect and analyze a lot of data at once. Unlike word that just
organizes data, Spreadsheets have complex formulas that able you to compute and calculate complex
problems from your data quickly and efficiently. It can be used for business, everyday activities, or finance.
Data from these sheets can be presented in graphs, posters and infographics to better understand the
information where you can physically see what the trends are.
1|Page
UNIT: 42 How can spreadsheets be used to solve complex problems
Contents
Task 1 ................................................................................................................................................................................................ 2
Analysis of data ......................................................................................................................................................................... 1
Data mining.................................................................................................................................................................................. 2
Supporting decision making ..................................................................................................................................................... 2
Cash flow forecasting ................................................................................................................................................................ 2
Budget control ............................................................................................................................................................................. 2
Trend analysis ............................................................................................................................................................................. 3
Task 2 ................................................................................................................................................................................................ 4
How organizations can use interpretation methods to analyze data ............................................................................ 4
Figure 1 (data-ink, n.d.)
Spreadsheets are very useful when you need to collect and analyze a lot of data at once. Unlike word that just
organizes data, Spreadsheets have complex formulas that able you to compute and calculate complex
problems from your data quickly and efficiently. It can be used for business, everyday activities, or finance.
Data from these sheets can be presented in graphs, posters and infographics to better understand the
information where you can physically see what the trends are.
1|Page
