24125491
Description
Flashcards by christina Littlewood, updated more than 1 year ago
|
Created by christina Littlewood
over 4 years ago
|
|
| Question | Answer |
| A function within Microsoft Excel that adds together the contents of a number of cells. | AUTOSUM |
| A function within Microsoft Excel that calculates the mean (average) of a list of numbers. | AVERAGE |
| A collection of records where each record is made up of fields for the individual data items (e.g. name, address, etc.). | DATA FILE |
| A 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 |
| A 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 |
| A 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 |
| A 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 |
| Consisting of numbers: real, integer or fixed decimal. | NUMERIC DATA |
| Function within Microsoft Excel that rounds a number up to a specified number of decimal places | ROUND |
| Function within Microsoft Excel that returns a number between 0 and 59 as the number of seconds shown on a clock from a given time | SECOND |
| Software used for performing calculations and for modelling situations using data arranged in a grid consisting of rows and columns | SPREADSHEET |
| Function within Microsoft Excel that looks at the cells within a given range and adds the total from those cells that meet a given condition | SUMIF |
| Function within Microsoft Excel that looks up data using data organised in vertical columns | VLOOKUP |
| A single sheet in an excel file | WORKSHEET |
| A set of sheets in an Excel file | WORKBOOK |
Want to create your own Flashcards for free with GoConqr? Learn more.