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

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 science quiz
Ryan Barton
GCSE Computing - 4 - Representation of data in computer systems
lilymate
Data Structures & Algorithms
Reuben Caruana
GCSE Computing: Hardware
Yasmin F