MIS Test 1 > Excel > Flashcards

Excel Flashcards

(2 cards)

Study These Flashcards
1
Q

Vlookup

A

=VLOOKUP(celltobelookedup,Table:oflookup,whichcolumnofthelookuptableanswerwiollbefoundin)

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

describe a nested if statement

A

IF(B9>18,”Adult”, IF(B9>12, “Teen”,”Chlid”))

IF(condition,”Txtiftrue”,IF(condition,”Txtiftrue”,”Txtiffalse”))

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
MIS Test 1
flashcards
Decks in class (10)
# Cards
Brainscape helps you reach your goals faster, through stronger study habits.
© 2026 Bold Learning Solutions. Terms and Conditions