Save Busy. Please wait.
or Don't have an account?  Sign up
or taken why

Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account.
We do not share your email address with others. It is only used to allow you to reset your password. For details read our Privacy Policy and Terms of Service.

Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.
focusNode
Didn't know it?
click below

Knew it?
click below
Don't know
Remaining cards (0)
Know
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

Normal Size     Small Size show me how

# Excel Formulas

TermDefinition
=DB Returns the straight line depreciation amount of an asset for a given period
=FV Returns the future value of an investment based on periodic, constant payments and a constant interest rate
=PMT Calculates the payment for a loan based on constant payments and a constant interest rate
=PV Returns the present value of an investment. The total amount that a series of future payments is worth now
=TIME Returns the number that represents a particular time
=TODAY Today’s date
=RAND Returns a random number greater than or equal to 0 and less than 1, evenly distributed
=RANDBETWEEN Returns a random number between the numbers you specify
=ROUND Rounds a number to a specified number of digits (Not only how to do it, but what is does.  This impacts when you have to foot and cross foot something in excel.  Easy to be off a dollar.)
=ROUNDDOWN Rounds a number down, toward zero
=ROUNDUP Rounds a number up, away from zero
=SUM Adds all the numbers in a range of cells (We use this a LOT to roll up trial balances and sub ledgers)
=SUMIF Adds the cells specified by a given criteria (We use this a LOT to roll up trial balances and sub ledgers)
=SUMIFS Adds the cells specified by a given set of criteria or conditions (We use this a LOT to roll up trial balances and sub ledgers)
=AVERAGE Returns the average of its arguments, which can be numbers or names, arrays, or references that contain numbers.
=AVERAGEIF Finds average for the cells specified by a given condition or criteria
=AVERAGEIFS Finds average for the cells specified by a given set of conditions or criteria
=CORREL Returns the correlation coefficient between two data sets
=COUNT Counts the number of cells in a range that contain numbers
=COUNTIF Counts the number of cells within a range that meet the given condition
=COUNTIFS Counts the number of cells specified by a given set of conditiosn or criteria
=LARGE Returns the k-th largest value in a data set
=MAX Returns the maximum value in a list of arguments
=MEDIAN Returns the median, or the number in the middle of the set of given numbers
=MIN Returns the smallest value in a list of arguments
=RANK Ranks the rank of a value within a list of values
=SMALL Returns the k-th smallest value in a data set
=COLUMN Returns the column number of a reference
=GETPIVOTDATA Returns data stored within a PivotTable
=HLOOKUP Looks for a value in the top row of a table or array of values and returns the value in the same column for a row you specify
=INDIRECT Returns the reference specified by a text value
=ROW Returns the row number of a reference
=TRANSPOSE Converts a vertical range of cells to a horizontal range, or vise versa
=VLOOKUP Looks for the value in the leftmost column of a table, and then returns a value in the same row from a column you specify.
=CONCATENATE Joins several text strings into one text string
=LEFT Returns the specified number of charters from the start of a text string
=LEN Returns the number of characters in a text string
=MID Returns a specific number of characters from a text string starting at the position you specify
=TRIM Removes all spaces from text string, except for single spaces between words
=AND Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE
=IF Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE
=IFERROR Returns value_if_error if expression is an error and the value of the expression itself otherwise
=IFNA Returns the value you specify if the formula returns the #N/A error value; otherwise returns the result of the formula.
=OR Checks whether any of the arguments are TRUE, and then returns TRUE or FALSE. Returns FALSE only if all arguments are FALSE
=ISBLANK Checks whether a reference is to an empty cell, and returns TRUE or FALSE
=ISERROR Checks whether a value is an error, and returns TRUE or FALSE
=ISEVEN Returns TRUE if the number is even
=ISODD Returns TRUE if the number is odd
Created by: atpierce87

Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

• SPACEBAR - flip the current card
• LEFT ARROW - move card to the Don't know pile
• RIGHT ARROW - move card to Know pile
• BACKSPACE - undo the previous action

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

# Pass complete!

 "Know" box contains: Time elapsed: Retries:
restart all cards