Microsoft Excel flashcards

Description

Year 11 Computing Flashcards on Microsoft Excel flashcards, created by christina Littlewood on 06/07/2020.
christina Littlewood
Flashcards by christina Littlewood, updated more than 1 year ago
christina Littlewood
Created by christina Littlewood over 4 years ago
1
0

Resource summary

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
Show full summary Hide full summary

Similar

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
Computing Hardware - CPU and Memory
ollietablet123
Computer Systems
lisawinkler10
Computer science quiz
Ryan Barton
Input, output and storage devices
Mr A Esch