ICT Unit 3 revision
Key vocabulary
Spreadsheets: use to perform calculations
App used for spreadsheet: Excel
Cell: one box in spreadsheet
Row: a line going horizontally, Ex: row 8
Column: a line going vertically, Ex: column A
Worksheet: one sheet in a spreadsheet
Workbook: several worksheets
Gridlines: Lines around the boxes
Formula bar: where you type a formula
Formula: these are made up by math operations (-/*+)
Functions: uses paratheses, don't use math operations
Chart & graphs
Charts & graph: visual representation of data
Pie chart: for percentage (out of 100%) per data
Column chart: for statistics
Bar chart: same as column chart, for statistics
Line graphs: for changes of data over time
Area graph: for showcasing the data
Scatter graph: for quantitative data visualization
Manipulation
Conditional formatting: formats a cell with a condition, Ex: if cell contains text: … then color red
Bold: making the text thicker (bolder)
Fill: to repeat the formula of a cell by dragging it down
Italics: making the text slightly right (italics)
Drop-down list: a list that goes down, for choosing options
Sorting: sort data in range, in numerical order or alphabetical order
Operators
-: minus
+: add
/: divide
*: multiply
Functions
=sum: add all the numbers in a cell range
Absolute cell referencing keeps the cell the same when filling
=if: checking whether the statement is correct or not
=average: find the average in a cell range
=min: find the lowest number in a cell range
=max: find the highest number in a cell range
=count: count all of the cell that has numbers
=counta:count all of the cell that has text
=VLOOKUP: match the data in a cell within a range