Working with Functions Flashcards

1
Q

a predefined formula that performs
calculations using specific values in a particular order.

A

Function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Each function has
a specific order called _______

A

Syntax

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

to create a formula with a function is to insert an

A

=

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

can refer to both individual cells and
cell ranges and must be enclosed within
parentheses.

A

arguments

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

This function adds all of the values of the
cells in the argument.

A

Sum

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

This function determines the average
of the values included in the argument.

A

Average

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

This function counts the number of cells
with numerical data in the argument.

A

Count

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

This function determines the highest cell
value included in the argument.

A

Max

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

This function determines the lowest cell
value included in the argument.

A

Min

How well did you know this?
1
Not at all
2
3
4
5
Perfectly