CRITERIA A:                                                           16/3/2017

Answer the following questions
What is a spreadsheet? A spreadsheet is an electronic based document in which your data is arranged in rows and columns and can be used to in calculations. 

 What are the various types of spreadsheets? Google Sheets, iWork Numbers - .LibreOffice Lotus 1-2-3Lotus Symphony - Microsoft Excel. OpenOffice and VisiCalc are some of the type of spreadsheets.

Who would use spreadsheets? Accountants, teachers, engineers, sales people, scientists, supermarkets and market researchers are some people who would use spreadsheets. 

For example accountants would need to use spreadsheets because they are the ones who will manage the money that will go in and out of the bank and they are the ones who look at how much wages each worker will get.

Another example would be a Scientist. A scientist would need a spreadsheet when they are doing an experiment. This helps them record the data to analyse what they did.

This is a different example which is a supermarket. A supermarket would need a spreadsheet the most because the need to see what products are been sold the most and what are not and depending on that they can increase or decrease they amount of money the product is sold for.

How is it beneficial to students, adults and businesses? Spreadsheets are an electronic based document in which your data is arranged in rows and columns and can be used in calculations. This can be used for students when they are doing statistics, for adults to keep the data of their company in and for buissness to show statistics of the company or data which can be stored in many ways for you or your company to use when you want.

What is the Global Context? Scientific and technical innovation is the global ontext which relates to this subject the most.  

ATL skills you would require for this topic? In my opinion I think that research skills will be most needed for a spreadsheet.

FEATURES OF SPREADSHEETS:

1.    Excel formulas

2.    Cell

3.    Pivot tables

4.    Lookup formulas

5.    Excel charts

6.    Sorting and Filtering data

7.    Conditional formatting

8.    VBA and macros

9.    Excel Tables & structural references

10.                       Power Pivot, data 

Excel formulas: A formula is combination of operators, operands, and functions. It can be used for solving math.

Cell:  A can be used to solve math and it can be used to write data in.

Pivot tables: Pivot tables are the perfect tools for managers & analysts.

Lookup formulas:  By knowing how to write lookup formulas, you can make various dashboards, interactive charts and  create effective models 

Excel charts help you communicate information very easily. By choosing your charts wisely and formatting them cleanly, you can convey a lot.

If Microsoft ever needs few extra billions of cash, they just have to turn sorting & filtering features in Excel to pay-per-use. These ad-hoc analysis features are so powerful & simple that any aspiring analyst must be fully aware of them.

Conditional formatting is a feature in Excel that can make your work great. Just add something to highlight your data and you will turn boring into interesting. With new features like data bars, color scales & icon sets, conditional formatting is even more better.

Macros, little VBA programs are what you write to achieve this. Learning VBA can be quite fun, challenging. Once you learn VBA, thanks to all this you will save a lot of time.

Excel tables, a new feature added in Excel 2007 is a very powerful way to structure, maintain & use data. With tables, you can add or remove data as you like.

Although Excel in itself is quite cool, it struggles to analyse some specific types of data such as combining multiple tables and using them to create reports, processing data from different sources.