Question and answer
In your financial planning worksheet, when might you use conditional formatting?
Conditional formatting allows you to select one or more cells, and create rules for when and how those cells are formatted. You can control the cell font, fill colour and border setting, based on the selected cell's contents, [ or based on the contents of another cell. If the rules (conditions) that you specified are met, then the formatting is applied. ]
Ask a question
Not a good answer? Get an answer now. (Free)
Original conversation
User: In your financial planning worksheet, when might you use conditional formatting?

Weegy: Conditional formatting allows you to select one or more cells, and create rules for when and how those cells are formatted. You can control the cell font, fill colour and border setting, based on the selected cell's contents, [ or based on the contents of another cell. If the rules (conditions) that you specified are met, then the formatting is applied. ]
sudo|Points 57|

User: if you were a financial planner what are some excel formulas that you might use

Weegy: 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). Read more: ]
smp0784|Points 3626|

User: what are some financial palnner what are some excel formulas that you might use or need please specify and explain

Weegy: You would need to know formulas for: 1.Future value 2.Present value 3.Compound or simple interest 4.Amortization/Depreciation To make your own financial calculator in Excel, start a new file or sheet and label fields for Rate, Nper, PMT, PV, [ [ [ and Type, and add some sample values. Choose the cell where you want the result for FV to go. Click Insert, then Function (or fx on the task bar) to open Insert Function window. In the left column, select "Financial". This will give you all the functions in financial calculation. ] ]
Expert answered|scijoe21|Points 1675|

Question
Asked 6/18/2012 5:50:29 PM
0 Answers/Comments
New answers
Rating

There are no new answers.

Comments

There are no comments.

Add an answer or comment
Log in or sign up first.
16,958,742 questions answered
Popular Conversations
What is the equation of the line described below written in ...
Weegy: The line passing through point (4, -1) and perpendicular to the line whose equation is 2x - y - 7 = 0 in slope ...
7/28/2014 12:38:02 PM| 7 Answers
beliefs of buddhism
Weegy: Read more: Buddhism: Basic Beliefs and Practices | Infoplease.com ]
7/28/2014 4:39:59 AM| 5 Answers
10. In general terms, the heart of any representative democracy is A. ...
Weegy: 10. In general terms, the heart of any representative democracy is suffrage.
7/28/2014 7:29:37 PM| 5 Answers
Which of the following is the solution set of 18 - 3n + 2 = n + 20 - ...
Weegy: n > 0.2, n User: Which of the following equations could be used to solve the given equation? 9x + 26 + 7x - 17 ...
7/28/2014 9:25:21 AM| 4 Answers
Find the product. (-7p)^3
Weegy: -21p User: Find the product. (n^3)^2 · (n^5)^4 Weegy: your question? User: Find the ...
7/28/2014 7:09:27 AM| 3 Answers
Given: 3x + y = 1. Solve for y. y = -3x + 1 y = -3x - 1 y = 3x ...
Weegy: Given: 2x + 3y = 6, the y-intercept is (0, 2) User: Given: 5x - 6y = 0. What is the x-intercept? (0, ...
7/28/2014 11:47:06 AM| 3 Answers
What is the solution set of the following equation? -8x + x + 15 = ...
Weegy: Answer is definitely c. B = (R - Ax)/x User: The slope of a line is -1/3. Find the slope of a line that is ...
7/28/2014 1:05:49 PM| 3 Answers
Exerts control over all parts of the body (Points : 4) Nervous ...
Weegy: 1. Peripheral nervous system registers information and controls movements outside the central nervous system. ...
7/28/2014 3:41:02 PM| 3 Answers
features of a simple network and the network infrastructure for alarg ...
Weegy: The simple network consists of two or more connected computers and the basic network components include ...
7/29/2014 5:02:00 AM| 3 Answers
Solve for x. 8 – 3x = 20 User: Juan buys 4 shirts on sale for $15 ...
Weegy: 4 tshirts 4 x $15.00 = $60.00 $78.00 - $60.00 = $18.00 6 pairs of socks is $18.00 $18.00 / 6 = $3.00 each ...
7/28/2014 7:55:02 AM| 2 Answers
Weegy Stuff
S
R
L
1
1
P
C
1
P
1
1
L
P
C
P
C
1
P
C
L
P
C
1
P
C
Points 2365 [Total 21365]| Ratings 1| Comments 2355| Invitations 0|Offline
S
L
P
C
P
C
1
L
P
C
L
P
C
P
C
P
C
Points 2177 [Total 17306]| Ratings 0| Comments 2177| Invitations 0|Offline
S
L
P
C
L
P
C
P
C
L
P
C
P
C
Points 2042 [Total 14597]| Ratings 1| Comments 2032| Invitations 0|Offline
S
L
1
Points 1653 [Total 3836]| Ratings 2| Comments 1633| Invitations 0|Offline
S
L
1
1
1
1
L
1
Points 1382 [Total 7559]| Ratings 2| Comments 1362| Invitations 0|Offline
S
1
L
Points 1145 [Total 3281]| Ratings 7| Comments 1075| Invitations 0|Offline
S
1
L
1
L
P
P
L
Points 960 [Total 10568]| Ratings 0| Comments 960| Invitations 0|Offline
S
1
L
Points 849 [Total 4525]| Ratings 2| Comments 829| Invitations 0|Offline
S
P
C
L
P
L
1
Points 798 [Total 5852]| Ratings 4| Comments 758| Invitations 0|Offline
S
R
R
Points 160 [Total 348]| Ratings 1| Comments 140| Invitations 1|Offline
Home | Contact | Archive | Blog | About | Terms | Privacy | Social | ©2014 Purple Inc.