Excel Flashcards
a number format that is used for accounting
Accounting Number Format
the angle at which a text is displayed
Orientation
a function used to count the cells with content in a range
Count
a function used to compute for the summation of the number of a range
Sum
a function used to compute for the average of the number of a range
Average
a function used to count the cells with a specified content within a range
COUNTIF
a function used to compute for the summation of a range if a certain condition is met
SUMIF
a function used to compute for the average of a range if a certain condition is met
AVERAGEIF
the range of cells where you want to look for the criteria
Range
a value or label that determines if a cell is part of the range to be averaged
Criteria
the actual range of cells that will be averages, if omitted, the range will be used instead
Average Range