Excel Flashcards

1
Q

a number format that is used for accounting

A

Accounting Number Format

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

the angle at which a text is displayed

A

Orientation

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

a function used to count the cells with content in a range

A

Count

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

a function used to compute for the summation of the number of a range

A

Sum

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

a function used to compute for the average of the number of a range

A

Average

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

a function used to count the cells with a specified content within a range

A

COUNTIF

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

a function used to compute for the summation of a range if a certain condition is met

A

SUMIF

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

a function used to compute for the average of a range if a certain condition is met

A

AVERAGEIF

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

the range of cells where you want to look for the criteria

A

Range

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

a value or label that determines if a cell is part of the range to be averaged

A

Criteria

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

the actual range of cells that will be averages, if omitted, the range will be used instead

A

Average Range

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