Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
16 Cards in this Set
- Front
- Back
|
TIME()
|
This function would return the following time elements: 3:02 PM
|
|
|
HOUR()
|
This function would return the following time element: 11
|
|
|
NOW()
|
This function would return the following date and time elements: 5/3/2013 3:02
|
|
|
DAY()
|
This function would return the following date element: 18
|
|
|
TODAY()
|
This function would return the following date elements: 4/29/2013
|
|
|
DATE()
|
This function would return the following date elements: 8/5/2012
|
|
|
MOD
|
Returns a remainder after a number is divided
|
|
|
TEXT
|
Converts a value to text in a specific number format
|
|
|
IMSUB
|
Returns difference of two numbers
|
|
|
QUOIENT
|
returns integer portion of a division
|
|
|
#VALUE
|
Results from performing a mathematical operation containing text and values
|
|
|
IMDIV
|
Returns quotient of two complex numbers
|
|
|
SQRT()
|
The square root of a number
|
|
|
POWER
|
The result of a number raised to a power
|
|
|
ROUND()
|
Returns number to a specific number of digits
|
|
|
INT()
|
returns a number that is rounded down to nearest integer
|
