Spreadsheet Level 1 Formula and Functions

Linda (tutor)
Flashcards by , created about 6 years ago

Definitions and examples of the simple formula and functions

Eye 247
Pin 6
Balloon left 0
Tags
Linda (tutor)
Created by Linda (tutor) about 6 years ago
How to pass Reading in Functional English
sprogers63
Data Protection Act
isabel.nemitz
Diary Management Software(DMS)
10syeda
2014 GCSE History Exam Paper Setup
James McConnell
Core 1.3 Energy Generation, Storage and Use
T Andrews
NCEA Guide to Studying
Kerrin _
Irregular Pasts in English - Study cards
Esther Alabart
GPS
Hammo
Using articles: a/an, the, no article
Elisabeth Emmott
ICT revision
ben goddard
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