Level 4 Level 6
Level 5

Most Useful Excel functions III


11 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?
ROUND
Rounds a number to a specified number of digits
PROPER
Capitalizes the first letter in each word of a text value
UPPER
Converts text to uppercase
LOWER
Converts text to lowercase
INDEX
Uses an index to choose a value from a reference or array
MATCH
Looks up values in a reference or array
INDIRECT
Returns a reference indicated by a text value
DATE
Returns the serial number of a particular date
DATEVALUE
Converts a date in the form of text to a serial number
NOW
Returns the serial number of the current date and time
TODAY
Returns the serial number of today's date