Post Session Assessment Excel

The TRIM function removes extra spaces from:

• Leading and trailing spaces only
• Leading, trailing, and extra spaces between words
• Only trailing spaces
• Only leading spaces

What will =TRIM(' Excel Function ') return?

• ' Excel Function '
• 'Excel Function'
• 'Excel Function'
• ' Excel Function'

What will =UPPER('excel formulas') return?

• excel formulas
• Excel Formulas
• EXCEL FORMULAS
• ExCeL fOrMuLaS

Which function converts 'eXCeL' into 'Excel'?

• LOWER(A1)
• PROPER(A1)
• UPPER(A1)
• TRIM(A1)

Which function returns the row number of a reference?

• COLUMN
• INDEX
• MATCH
• ROW

If =MATCH(50, A1:A10, 0) is used, what does the '0' indicate?

• An exact match is required
• An approximate match is required
• The search range is in descending order
• The function will return the value 50

In VLOOKUP, what does the col_index_num argument represent?

• The row number to return
• The column number to return
• The total number of columns
• The number of rows to skip

What will =VLOOKUP(5, A2:D10, 3, FALSE) do?

• Look for the number 5 in the third column
• Search for 5 in column A and return the third column value
• Return the largest value in column 3
• Return an error if 5 is not found

How does HLOOKUP differ from VLOOKUP?

• HLOOKUP searches horizontally, VLOOKUP searches vertically
• HLOOKUP searches vertically, VLOOKUP searches horizontally
• HLOOKUP can return multiple values, VLOOKUP cannot
• There is no difference

Why would you use MATCH inside VLOOKUP?

• To dynamically find the column index number
• To find an approximate match
• To prevent errors
• To sum values instead of looking them up