Chapter 10 Flashcards Preview

IT > Chapter 10 > Flashcards

Flashcards in Chapter 10 Deck (9)
Loading flashcards...
1

IF

(condition, value if true, value if false)

2

SUMIFS

(where, what)

3

COUNTIFS

(where, what)

4

data validation

"rules" - to apply select circle invalid data

5

drop down list

data validation -> list

6

conditional formatting

new rule
- to specify a conditional format

7

data bars

shows bars inside cell

8

INDEX

(where,row,column)

9

MATCH

("what", where, 0)