Question

if you were a financial planner,what are some Excel formulas that you might use or need? please specify and explain

Answer 1

SUM, AVERAGE, IF, HYPERLINK, COUNT, MAX, SIN, SUMIF, and STDEV.
SUM- adds all the numbers in a range of cells.
AVERAGE- Returns the average of its argument, which can be numbers or names, arrays, or references that contain numbers.
IF- Checks whether a condition is met and returns one value if TRUE and another value if FALSE.
HYPERLINK- Creates a shortcut or jump that opens a document stored on your hard drive, a network server, or on the Internet.
COUNT- Counts the number of cells in a range that contain numbers.
MAX- Returns the largest value in a set of values. Ignores logical values and text.
SIN- Returns the sine of an angle.
SUMIF- Adds the specified by a given condition or criteria.
PMT- Calculates the payment for a loan on constant payments and a constant rate.
STDEV- Estimates standard based on a sample (ignores logical values and text in the sample).