Level 5 Level 7
Level 6

Most Useful Excel functions IV


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?
SUMIF
Adds the cells specified by a given criteria
COUNTIF
Counts the number of cells within a range that meet the given criteria
COUNTIFS
Counts the number of cells within a range that meet multiple criteria
NOT
Reverses the logic of its argument
ROW
Returns the row number of a reference
COLUMN
Returns the column number of a reference
MID, MIDBs
Returns a specific number of characters from a text string starting at the position you specify
VALUE
Converts a text argument to a number
EXACT
Checks to see if two text values are identical
IFERROR
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula