GoConqr hat ein neues Design! Sag uns, wie es dir gefällt.

Kostenlos registrieren

Karteikarten

Microsoft Excel flashcards

christina Littlewood Computing Year 11 Englisch 15 Karten

Karten in diesem Stapel (15)

  1. 1A function within Microsoft Excel that adds together the contents of a number of cells.AUTOSUM
  2. 2A function within Microsoft Excel that calculates the mean (average) of a list of numbers.AVERAGE
  3. 3A collection of records where each record is made up of fields for the individual data items (e.g. name, address, etc.).DATA FILE
  4. 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
  5. 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
  6. 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
  7. 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
  8. 8Consisting of numbers: real, integer or fixed decimal.NUMERIC DATA
  9. 9Function within Microsoft Excel that rounds a number up to a specified number of decimal placesROUND
  10. 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
  11. 11Software used for performing calculations and for modelling situations using data arranged in a grid consisting of rows and columnsSPREADSHEET
  12. 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
  13. 13Function within Microsoft Excel that looks up data using data organised in vertical columnsVLOOKUP
  14. 14A single sheet in an excel fileWORKSHEET
  15. 15A set of sheets in an Excel fileWORKBOOK

Informationen

Beschreibung
Year 11 Computing Karteikarten am Microsoft Excel flashcards, erstellt von christina Littlewood am 06/07/2020.
Aufrufe
11
Bewertung

Feedback

Worum geht es?

Wie gefällt dir das neue Design?

Dein Eindruck