MOD 7 and 8 Flashcards
1
Q
formula for functions
A
=FUNCTION(range)
2
Q
average if formula
A
=AVERAGE(range)”criteria”(averagerange)
3
Q
function that counts cells if they contain something and its formula
A
countif function
=COUNTIF(range, “criteria”)
4
Q
range of cells to look for criteria
A
range
5
Q
value of label determining if a cell is part of the range
A
criteria
6
Q
actual range of cells that will be averaged or counted
A
average/countrange
7
Q
elevate data by providing visual representation to numeric values
A
charts and graphs
8
Q
most basic, display data point values and duration of time
A
graph
9
Q
more complex, allow comparison of data
A
chart
10
Q
types of charts
A
column
bar
line
pie
doughnut
