ICT Spreadsheet Theory 2.0 / 5 based on 1 rating ? ICTDatabasesASOCR Created by: Rachael JenkinsCreated on: 05-01-13 18:06 Spreadsheet Columns and rows that assist finacial modelling 1 of 17 Row Horizontal - Numers 2 of 17 Column Veritcal - Letters 3 of 17 Replication Copying of a cell either horizontialy or vertically 4 of 17 Variable Identifies cells, either with a cell reference or cell name 5 of 17 Formulae A way that a calculation is represented in a spreadsheet 6 of 17 Rules A procedure that must be followed 7 of 17 Functions Represents a formulae that is already programmed into the spreadsheet - SUM 8 of 17 SUM Adds a range of cells 9 of 17 MIN/MAX Shows the min value or max in selected data 10 of 17 COUNTIF Counts the number of cells within a range that meet a given critera 11 of 17 Worksheet A page of cells inside a work book 12 of 17 Work book The document that holds worksheets 13 of 17 Cell An individual data store 14 of 17 Range A group of cells within a worksheet I.E A1:A11 15 of 17 Relative Cell Referencing When the formula changes when copied to other cells 16 of 17 Absolute Cell Referencing When the formula stays the same when copied to other cels $$ 17 of 17
Comments
No comments have yet been made