SPA 101 Week 5 Quiz 5 Summer A 2019

In VLOOKUP, the "V" represents a vertical table.

• True

• False

The IFERROR function can be used to avoid an error message.

• True

• False

Excel allows you to change the case of text in cell with tools on the HOME ribbon.

• True

• False

This function returns a "TRUE" if the condition is met.

• IF

• OR

• AND

• NOT

This function returns a "TRUE" if just one of the conditions are met.

• IF

• OR

• AND

• NOT

This function returns a "TRUE" only if all the conditions are met.

• IF

• OR

• AND

• NOT

This function reverts the values of its arguments.

• IF

• OR

• AND

• NOT

The names on my worksheet are all lowercase. I need to adjust the names so the first letter of each word is capital. Which function should I use?

• UPPER

• LOWER

• PROPER

• MID

I need to find the total of all sales made in March. Which function should I use?

• SUM

• SUMIF

• SUMIFS

• None

The first names are in Column A, and the last names are in Column B. I need to combine the two in one cell. Which function should I use?

• VLOOKUP

• HLOOKUP

• CONCATENATE

• TRIM