Computing Spreadsheet Key Knowledge Key Vocabulary Cell Reference
Computing – Spreadsheet Key Knowledge Key Vocabulary Cell Reference The name of an individual cell (The coordinates to a cell) Row A range of cells that go across (horizontal) the spreadsheet. Rows have a number. Column A vertical range of cells. Columns have a letter. Cell A rectangular box that can contain any value Sheet A single page in a spreadsheet document Workbook A collection of sheets Formula A mathematical operation performed on values in the spreadsheet Tab The button that changes which sheet you are looking at Formatting The appearance of the cell (Colour, font size, type and colour. Borders Conditional Formatting This changes the format of a cell based on what condition you enter. If Statement A function that sees if a condition is met. If it is met a true value is returned if not a false. Cell Replication Copying of data in a cell to another cell Validation Where the computer checks your data entry to see if it is allowed. Absolute Cell Reference Makes the cell static (Will not change when copying a formula) Colon : Defines a range of cells. Colon in effect means to e. g A 2: D 5 Static Cell A cells value that has to be changed manually Dynamic Cell A cell value changes automatically based on contents from another cell. Key Formulas =Sum Adds the values of a cell range =Average Finds the average value of a range =Max Finds the maximum value in a range =Min Finds the minimum value in a range =IF Used to create an IF statement
- Slides: 1