Microsoft Excel flashcards

Beschreibung

Year 11 Computing Karteikarten am Microsoft Excel flashcards, erstellt von christina Littlewood am 06/07/2020.
christina Littlewood
Karteikarten von christina Littlewood, aktualisiert more than 1 year ago
christina Littlewood
Erstellt von christina Littlewood vor mehr als 4 Jahre
1
0

Zusammenfassung der Ressource

Frage Antworten
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
Zusammenfassung anzeigen Zusammenfassung ausblenden

ähnlicher Inhalt

A level Computing Quiz
Zacchaeus Snape
Types and Components of Computer Systems
Jess Peason
Input Devices
Jess Peason
Output Devices
Jess Peason
Computing
Kwame Oteng-Adusei
Pack of playing cards answer
Karl Taylor
Code Challenge Flow Chart
Charlotte Hilton
Computer Systems
lisawinkler10
Computer science quiz
Ryan Barton
GCSE Computing - 4 - Representation of data in computer systems
lilymate
GCSE Computing: Hardware
Yasmin F