Save
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
Username is available taken
show password


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. Your email address is only used to allow you to reset your password. See 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
edit
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

Extras: Excel Formulas for Accounting

QuestionAnswer
Financial Functions: DB Calculates depreciation using the fixed-declining balance method.
Financial Functions: DDB Calculates depreciation using the double-declining balance method.
Financial Functions: FV Calculates the future value of an investment.
Financial Functions: IRR Returns the internal rate of return for a series of periodic cash flows.
Financial Functions: NPER Returns the number of periods for an investment.
Financial Functions: NPV Calculates the net present value of a series of cash flows.
Financial Functions: PMT Calculates loan payments based on constant interest rate and time.
Financial Functions: PPMT Returns the principal payment for a loan in a specific period.
Financial Functions: PV Calculates present value of an investment or loan.
Financial Functions: RATE Returns the interest rate per period of an investment or loan.
Financial Functions: SLN Returns the straight-line depreciation of an asset.
Financial Functions: SYD Calculates sum-of-years' digits depreciation.
Financial Functions: XIRR Returns IRR for cash flows that are not necessarily periodic.
Financial Functions: XNPV Calculates NPV for cash flows on specific dates.
Math & Trigonometry Functions: ABS Returns the absolute value of a number.
Math & Trigonometry Functions: CEILING Rounds a number up to the nearest specified multiple.
Math & Trigonometry Functions: FLOOR Rounds a number down to the nearest specified multiple.
Math & Trigonometry Functions: MOD Returns the remainder after division.
Math & Trigonometry Functions: PRODUCT Multiplies all numbers given as arguments.
Math & Trigonometry Functions: ROUND Rounds a number to a specified number of digits.
Math & Trigonometry Functions: ROUNDDOWN Rounds a number down towards zero.
Math & Trigonometry Functions: ROUNDUP Rounds a number up, away from zero.
Math & Trigonometry Functions: SIGN Returns the sign of a number (1, 0, or -1).
Math & Trigonometry Functions: SUM Adds all the numbers in a range.
Math & Trigonometry Functions: SUMIF Adds numbers that meet a single condition.
Math & Trigonometry Functions: SUMIFS Adds numbers that meet multiple criteria.
Math & Trigonometry Functions: TRUNC Truncates a number to an integer.
Logical Functions: AND Returns TRUE if all conditions are TRUE.
Logical Functions: IF Performs a logical test and returns different results based on TRUE or FALSE.
Logical Functions: IFERROR Returns a value if the formula results in an error; otherwise, returns the result.
Logical Functions: IFNA Returns a value you specify if the formula results in a #N/A error.
Logical Functions: NOT Reverses the logical value of its argument.
Logical Functions: OR Returns TRUE if any argument is TRUE.
Logical Functions: SWITCH Compares one value against a list of values and returns the result of the first match.
Logical Functions: XOR Returns TRUE if either (but not both) arguments are TRUE.
Date & Time Functions: DATE Returns a date from year, month, and day.
Date & Time Functions: DATEDIF Calculates the difference between two dates in days, months, or years.
Date & Time Functions: DAY Returns the day of the month from a date.
Date & Time Functions: EDATE Returns a date that is a specified number of months before or after a start date.
Date & Time Functions: EOMONTH Returns the last day of the month before or after a specified number of months.
Date & Time Functions: MONTH Returns the month as a number from 1 to 12.
Date & Time Functions: NOW Returns the current date and time.
Date & Time Functions: TODAY Returns the current date.
Date & Time Functions: YEAR Returns the year from a date.
Date & Time Functions: YEARFRAC Returns the fraction of a year between two dates.
Lookup & Reference Functions: CHOOSE Returns a value from a list based on an index number.
Lookup & Reference Functions: HLOOKUP Looks for a value in the top row of a table and returns a value in the same column from a row you specify.
Lookup & Reference Functions: INDEX Returns the value of a cell at the intersection of a specified row and column.
Lookup & Reference Functions: LOOKUP Searches a range for a value and returns a result from the same position.
Lookup & Reference Functions: MATCH Returns the relative position of an item in a range.
Lookup & Reference Functions: VLOOKUP Looks for a value in the first column of a table and returns a value in the same row from another column.
Lookup & Reference Functions: XLOOKUP Replaces VLOOKUP and HLOOKUP with more flexibility.
Lookup & Reference Functions: XMATCH Returns the relative position of an item in an array.
Text Functions: CLEAN Removes all non-printable characters from text.
Text Functions: CONCAT Joins text from two or more strings.
Text Functions: FIND Finds one text string within another (case-sensitive).
Text Functions: LEFT Returns a specified number of characters from the start of a string.
Text Functions: LEN Returns the number of characters in a string.
Text Functions: LOWER Converts all letters in text to lowercase.
Text Functions: MID Returns a specific number of characters from a text string, starting at the position you specify.
Text Functions: PROPER Capitalizes the first letter of each word in text.
Text Functions: RIGHT Returns a specified number of characters from the end of a text string.
Text Functions: SUBSTITUTE Substitutes new text for old text in a string.
Text Functions: TEXT Formats a number and converts it to text.
Text Functions: TEXTJOIN: Combines text from multiple ranges and/or strings using a delimiter.
Text Functions: TRIM Removes all spaces from text except single spaces between words.
Text Functions: UPPER Converts text to uppercase.
Text Functions: VALUE Converts text that appears in a number format into a number.
Created by: heavenlypure
Popular Accounting sets

 

 



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:

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