128+32+8+4=172
Unit | Size |
---|---|
1 bit | 1 bit (0 or 1) |
1 nibble | 4 bits |
1 byte (B) | 8 bits |
1 kilobyte (KB) | 1,000 bytes (1,000 B) |
1 megabyte (MB) | 1,000 kilobytes (1,000 KB) |
1 gigabyte (GB) | 1,000 megabytes (1,000 MB) |
1 terabyte (TB) | 1,000 gigabytes (1,000 GB) |
1 petabyte (PB) | 1,000 terabytes (1,000 TB) |
SUM - Adds up numbers in a cell range
MAX - Finds the largest value in a cell range
MIN - Finds the smallest value in a cell range
AVERAGE - Finds the mean of numbers in a cell range
IF - Checks if data matches a condition, the result depends on the match being true or false.
VLOOKUP - Displays data from a table in another part of the spreadsheet
Charts - Displays data in a visual way, these include Bar Graphs, Line Graphs, Scatter Graphs and Pie Charts
Sort - Arranges the data into a more suitable order eg. Highest to lowest, alphabetically
Filter - Shows only the data that the user has specified.
Conditional Formatting -The format of a cell is automatically changed if its contents meet certain conditions.
### National Curriculum Links
I can design, use and evaluate computational abstractions that model the state and behaviour of real-world problems and
physical systems
I can undertake creative projects that involve selecting, using and combining multiple applications to achieve challenging goals,
including collecting and analysing data and meeting the needs of known users.