We have detected that Javascript is not enabled in your browser. The dynamic nature of our site means that Javascript must be enabled to function properly. Please read our terms and conditions for more information.

Next up

Translations and transformations of functions

Christine Laurich

Copy and Edit

Statistical functions

Description

UK CAT Computer Studies Flashcards on Statistical functions, created by Joyce Wood on 01/08/2017.

Flashcards by Joyce Wood, updated more than 1 year ago

	Created by Joyce Wood almost 8 years ago

(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 Image: Autosum (binary/octet-stream)

Show full summary Hide full summary

0 comments

There are no comments, be the first and leave one below:

To join the discussion, please sign up for a new account or log in with your existing account.

Want to create your own Flashcards for free with GoConqr? Learn more.

Similar

Split text into columns using Functions

faulkner.j

Nested IF Functions and Conditional Functions

faulkner.j

computer systems and programming quiz

Molly Batch

Food Technology - Functions of ingredients

evie.daines

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

Browse Library