Spreadsheet - An electronic document in which data is arranged in rows and columns of a grid and can be used to make calculations, Formula - An 'equation' that helps make calculations within a cell; will always start with an = sign, VLOOKUP - used to compare a cell value to range of cells and return a value that matches the location of the value in the range, =VLOOKUP(A1,B1:B5,2,False) - VLOOKUP syntax, =ROUNDUP() - Rounds the value up to a specified number of decimal places, =CONCATENATE - combines blocks of text, Active Cell - A cell that you are working on, or is selected, and usually has highlighted borders when selected, absolute cell reference - Cell reference that does not adjust to the new cell location when copied or moved,

KS3 End of year IT Project

Tisk
Vložit

Výsledková tabule/Žebříček

Vizuální styl

Možnosti

Přepnout šablonu

Obnovit automatické uložení: ?