User: If you were a financial planner, what are some Excel formulas that you might use or need?

Weegy: I would use the financial formulas to interest rate calculations like: pmt (calculate payments) rate (calculate rate) fv (future value) pv (present [ value) I would make use of if, sumif, countif, sumifs, etc to calculate and filter data while calculing. Hope it helps. http://answers.yahoo.com/question/?qid=20111208203539AAnZFlk ]
Auto answered|Score 1

User: In your financial planning worksheet, when might you use conditional formatting? Please specify and explain.

Weegy: Excel 2010's conditional formatting lets you change the appearance of a cell based on its value or another cell's value. [ You might use conditional formatting to locate dates that meet a certain criteria to call out the highest or lowest values in a range, or to indicate values that fall under, over, or between specified amounts. ]
Auto answered|Score 1|scijoe21|Points 1605|