Level 3 Level 5
Level 4

Most Useful Excel functions II


10 words 0 ignored

Ready to learn       Ready to review

Ignore words

Check the boxes below to ignore/unignore words, then click save at the bottom. Ignored words will never appear in any learning session.

All None

Ignore?
TRIM
Removes spaces from text
SUBSTITUTE
Substitutes new text for old text in a text string
TEXT
Formats a number and converts it to text
VLOOKUP
Looks in the first column of an array and moves across the row to return the value of a cell
HLOOKUP
Looks in the top row of an array and returns the value of the indicated cell
IF
Specifies a logical test to perform
AND
Returns TRUE if all of its arguments are TRUE
OR
Returns TRUE if any argument is TRUE
MAX
Returns the maximum value in a list of arguments
MIN
Returns the minimum value in a list of arguments