Microsoft Excel flashcards

Descrição

Year 11 Computing FlashCards sobre Microsoft Excel flashcards, criado por christina Littlewood em 06-07-2020.
christina Littlewood
FlashCards por christina Littlewood, atualizado more than 1 year ago
christina Littlewood
Criado por christina Littlewood mais de 4 anos atrás
1
0

Resumo de Recurso

Questão Responda
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

Semelhante

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