BNB Intermediate

Which is NOT an MS EXCEL FUNCTION?

• UPPER

• EXACT

• VLOOKUP

• CONDITIONAL FORMATTING

What is lacking in the Formula?

What are the functions used to look up values from other cell/ sheet/ workbook?

• VLOOKUP

• ULOOKUP

• INDEX MATCH

• PLOOKUP

What is the correct formula to calculate your age?

• =INT((TODAY ()-BDATE)/365.20))

• =INT(TODAY ()-BDATE)/365.25)

• =INT((TODAY ()-BDATE)/365.25))

• =INT((DATE()-BDATE)/365.25))

• BAR

• LINE

• STOCK

• COMBO

• COMBO

• BAR

• LINE

• HIERARCHY

John wants to identify the exact value that each column in his chart represents. Which option should he choose?

• Gridelines
• Arrows
• Pictures
• Labels

Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type would he create?

• Bar
• Column
• Line
• Pie

This function removes unwanted spaces from a piece of text. The spaces before and after the text will be removed completely. Multiple spaces within the text will be trimmed to a single space

• ABS

• CONCATENATE

• CLEAN

• TRIM

This function counts the number of numeric or text entries in a list. It will ignore blanks.

• COUNT

• COUNTA

• COUNTBLANK

• COUNTIF