PAPER 1 of notes

Question 1

Find average

Answer 1

=Average(Range)

Question 2

Average if more than one criteria

Answer 2

=Averageifs(averagerange;range1;criteria1…)

Question 3

Sum with more than one criteria

Answer 3

=sumifs(Sumrange;range1;criteria1;range…)

Question 4

calculate the mean taken by excluding a percentage of data points from the top and bottom tails of a data set

Answer 4

=trimmean(range;percentage)

Question 5

calculate standard deviation

Answer 5

=STDEV.P(range)

Question 6

median?

Answer 6

=median(range)

Question 7

finding quartile

Answer 7

=quartile.inc(range;quartile)

Question 8

the k-th percentile of values in a range, inclusive

Answer 8

=percentile.inc(range;percentage)

Question 9

the most frequently occurring number in a numeric data set.

Answer 9

=Mode.SNGL(range)

Question 10

correlation

Answer 10

=correl(range1;range2)

Question 11

a numeric value based on its position in a list when sorted by value in ascending order.

Answer 11

=SMALL(range;rank)

Question 12

find a particular number in a range

Answer 12

=LARGE(range;rank)

Question 13

extracts a specified number of characters from the beginning of a text string.

Answer 13

=LEFT(text;nmbrofcharacters)

Question 14

retrieve a chosen amount of characters, counting from the right side of an Excel cell

Answer 14

=RIGHT(text;nmbrofcharacters)

Question 15

designed to pull a substring from the middle of the original text string.

Answer 15

=MID(text;start position; nmbr of characters)

Question 16

Number of characters

Answer 16

=LEN(text)

Question 17

find what return the position of a specific character or substring within a text string.

Answer 17

=FIND(character;text;startposition)

Question 18

putting text in uppercase

Answer 18

=UPPER(text)

Question 19

putting text in lowercase

Answer 19

=LOWER(text)

Question 20

first letter in uppercase and the rest in lower case

Answer 20

=PROPER(text)

Question 21

removing all of the spaces in a text except for single space between words

Answer 21

=TRIM(text)