Compléter Excel Vocabulary QuizVersion en ligne 7.01 Excel Vocabulary par Claudia Ponce 1 location changes storage Changes table data vertically DOES letter letter calculations intersection unit NOT rectangular basic number number Information box stored horizontally 1 . Formulas : Allow you to perform on entered into a spreadsheet . 2 . Data : ( values or numbers ; labels or text ; and date / time ) that is in a spreadsheet program . 3 . Spreadsheet : A used to store various types of data . 4 . Cells : The for data in a spreadsheet , and the point of a column and a row . Each is referred to as a cell . 5 . Rows : Rows run and are identified by a in the row header . 6 . Columns : Columns run and are identified by a in the column header . 7 . Cell Reference : The cell reference identifies the of a cell , and consists of the column and row that intersect at the cell ? s location . 8 . Relative Cell Reference : for all cell references . It identifies the location of a cell and when the formula is copied to other cells . In other words , it is relative to where it is in the spreadsheet . 9 . Absolute Cell Reference : In contrast to relative cell references , an absolute cell reference change when it is copied and pasted to other cells . In other words , it will absolutely reference the same cell no matter where it is in the spreadsheet .
Créer jeu