Session 2

if you want to sum the amount from Cell A1 till A10

• =sum(A1,A10)

• sum(A1,A10)

• =sum(A1:A10)

• sum(A1:A10)

what's the shortcut for flash fill

• ctrl+E

• Ctrl+i

• Alt+E

• Alt+i

The Shortcut for Table

• Ctrl+U

• Ctrl+T

• Ctrl+I

• Ctrl+R

what's the first parameter of vlookup

• =vlookup(Lookup value

• =vlookup(Table

• =vlookup(number of column

• =vlookup(0

from which ribbon i can remove the duplicates

• Conditional Formatting

• Data

• A & B

• Non of the answers

from which option i can highlight the duplicates?

• Conditional Formatting

• Data

• A & B

• Non of the answers

choose the correct sytnax

• =if(5>7,True,False)

• if(5>7,True,False)

• =if(5>7,"True","False")

• =if(5>7,"True,False")

what's the maximum number of logical tests i can use with ifs?

• 2

• 3

• 4

• more than 4

when you use vlookup function the matched column in the lookup table must be

• Last column

• First Column

• A or B

• Doesn't matter the arrange

From which ribbon i can get text to column

• Insert

• Formulas

• Home

• Data