Database formulas Flashcards by Lauren Riley

Q

SUM

A

Add up values in a range of cells

eg =sum(A3:C3)

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

AVERAGE

A

Calculated the average of certain values

eg =average(A3:C3)

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

MIN

A

Lowest value

eg =min(A3:C3)

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

MAX

A

highest value

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Round

A

Rounds to specified decimal place

eg 1 decimal place: =round(A1+A2,1)

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Round up

A

Rounds up a value

=roundup(A1/B3)

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Rank

A

Ranks selected cells

=rank(A3:C3)

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

IF

A

Displays statement depending on the value

=if(A3>C3,”YES”.”NO”)

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Conditional Formatting

A

Cell changes colour depending on content

eg yes = green, no = red

How well did you know this?

1

Not at all

2

3

4

5

Perfectly