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

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?