Chapter 10 Flashcards
1
Q
IF
A
(condition, value if true, value if false)
2
Q
SUMIFS
A
(where, what)
3
Q
COUNTIFS
A
(where, what)
4
Q
data validation
A
“rules” - to apply select circle invalid data
5
Q
drop down list
A
data validation -> list
6
Q
conditional formatting
A
new rule
- to specify a conditional format
7
Q
data bars
A
shows bars inside cell
8
Q
INDEX
A
(where,row,column)
9
Q
MATCH
A
(“what”, where, 0)
