# Spreadsheet Level 1 Formula and Functions

Flashcards by , created about 6 years ago

## Definitions and examples of the simple formula and functions

247
6
0
 Created by Linda (tutor) about 6 years ago
How to pass Reading in Functional English
Data Protection Act
Diary Management Software(DMS)
2014 GCSE History Exam Paper Setup
Core 1.3 Energy Generation, Storage and Use
NCEA Guide to Studying
Irregular Pasts in English - Study cards
GPS
Using articles: a/an, the, no article
ICT revision
 Question Answer Formula: Subtraction =A1-B1 Formula: Multiplication = A1 * B1 Formula: Division = A1 / B1 Function: to find the lowest (smallest) contents of a range of cells =Min(A1 : F1) Function: to find the largest contents of a range of cells =Max(A1 : F1) Function: to find the Average contents of a range of cells =Average(A1 : F1) MathsSymbolsSubtraction.jpeg (image/jpeg) The mathematical operator used to subtract cells in a formula MathsSymbolsDivide.jpeg (image/jpeg) The mathematical operator used to divide cells in a formula. Use / on your keyboard MathsSymbolsEquals.jpeg (image/jpeg) All formula and functions must start with = MathsSymbolsAddition.jpeg (image/jpeg) The mathematical operator to add cells together in a formula MathsSymbolsTimes.jpeg (image/jpeg) The mathematical operator used to multiply cells in a formula Formula: Addition = A1 + B1