Statistical functions

Description

UK CAT Computer Studies Flashcards on Statistical functions, created by Joyce Wood on 01/08/2017.
Joyce Wood
Flashcards by Joyce Wood, updated more than 1 year ago
Joyce Wood
Created by Joyce Wood almost 7 years ago
0
0

Resource summary

Question Answer
What is the function that takes numbers in b3 to b5 inclusive and works out the total =Sum(b3:b5)
What calculation takes the numbers in b3 to b5 and works out the average =Average (b3:b5)
What calculation takes the numbers in b3 to b5 and works out the smallest number =Min(b3:b5)
What calculation takes the numbers in b3 to b5 and works out the biggest number =Max(b3:b5)
What is the symbol is used as a quick way to add numbers up Autosum
Show full summary Hide full summary

Similar

Translations and transformations of functions
Christine Laurich
Split text into columns using Functions
faulkner.j
Nested IF Functions and Conditional Functions
faulkner.j
Food Technology - Functions of ingredients
evie.daines
computer systems and programming quiz
Molly Batch
Respiratory System
Addeana
Algebra Quiz
Norman McBrien
Functions of a Political Party
Phoebe Fletcher
Flash cards on cardiovascular system
offintowonderland
AVERAGE_IF_IFS
faulkner.j
Excel spreadsheet key terms
Mrs Johnson