Creado por christina Littlewood
hace más de 4 años
|
||
Pregunta | Respuesta |
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 |
¿Quieres crear tus propias Fichas gratiscon GoConqr? Más información.