Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

MIS Test 1 > Excel > Flashcards

Excel 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 (10 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions