Lecture 3

Question 1

what are functinos

Answer 1

pre wrtitten equations and actions designed to speed up calculation

Question 2

what do functions begin with

Answer 2

=

Question 3

give examples of 5 functions

Answer 3

= sum()
=min()
=avg()
=median
=mode

Question 4

what does large (A13:B24,3) mean

Answer 4

finds the 3rd largest value in that array

Question 5

what does =SMALL(A2:A48,6)

Answer 5

finds 6th smallest numerical value in that array

Question 6

when are conditional functions used

Answer 6

to perform calculations or make decisions based on specified conditions.

Question 7

what are the numerical conditional function

Answer 7

A
IF
IFS

Question 8

what does A do e.g COUNTA

Answer 8

counts all non empty cells

Question 9

what does IF mena e.g SUM IF

Answer 9

sums all values in an array of cells which meet certain criterion e.g costs <4%

Question 10

what does ifs mean e.g AVERAGE IFS

Answer 10

calclates mean values of an array of cells which meet mroe than one criteria e.g costs more than £4 , yields more than £5

Question 11

explain what =SUMIF(B2:B5,”John”, C2:C5)