Flashcards
Microsoft Excel flashcards
Cards in this deck (15)
- 1A function within Microsoft Excel that adds together the contents of a number of cells.AUTOSUM
- 2A function within Microsoft Excel that calculates the mean (average) of a list of numbers.AVERAGE
- 3A collection of records where each record is made up of fields for the individual data items (e.g. name, address, etc.).DATA FILE
- 4A function within Microsoft Excel that looks at the cells within a given range and counts the number of these cells that meet a given condition.COUNTIF
- 5A set of instructions used to perform a calculation in a spreadsheet. A formula can include cell references, numbers, mathematical symbols and, in some cases, pre-defined functions.FORMULA
- 6A function within Microsoft Excel that looks at a given condition and performs an operation if the condition is met, or a different operation if the condition is not met.IF
- 7A function within Microsoft Excel which looks up data using the first row or the first column of a range of cells and returns a relative value.LOOKUP
- 8Consisting of numbers: real, integer or fixed decimal.NUMERIC DATA
- 9Function within Microsoft Excel that rounds a number up to a specified number of decimal placesROUND
- 10Function within Microsoft Excel that returns a number between 0 and 59 as the number of seconds shown on a clock from a given timeSECOND
- 11Software used for performing calculations and for modelling situations using data arranged in a grid consisting of rows and columnsSPREADSHEET
- 12Function within Microsoft Excel that looks at the cells within a given range and adds the total from those cells that meet a given conditionSUMIF
- 13Function within Microsoft Excel that looks up data using data organised in vertical columnsVLOOKUP
- 14A single sheet in an excel fileWORKSHEET
- 15A set of sheets in an Excel fileWORKBOOK
Information
- Description
- Year 11 Computing Flashcards on Microsoft Excel flashcards, created by christina Littlewood on 06/07/2020.
- Created by
- christina Littlewood
- Views
- 11
- Tags
- Rating