Question and answer
Using Excel, given a list of contracts and due dates for annual maintenance fees. You wish to determine when you have a contract due in the next 45 days and provide a note that warns you that the
payment is due.
One way of providing a note could be with a formula like this on the place where you want the note to appear: =IF(TODAY()+45>A1,"Warning: Payment is coming due","") Change the reference from A1 to the cell with the due date. [ You can format the cell as you want, to make sure that the note is visible. ]
Expert answered|unknown23|Points 60|
Question
Asked 11/12/2012 5:52:37 PM
0 Answers/Comments
Get an answer
New answers
Rating

There are no new answers.

Comments

There are no comments.

Add an answer or comment
Log in or sign up first.
Questions asked by the same visitor
what are the different features of Excel that make it a valuable business tool.
Weegy: Features of excel that make it good for buisness are A database table is simply a collection of data that is categorized into columns and rows. Because of its grid line format, making a database table in Excel is simple. [ Enter the data into the horizontal rows, which are labeled with numbers. Use the vertical columns on the spreadsheet, which are headed with letters, to separate data. Read more: Ways to Use Microsoft Excel | eHow.com ] (More)
Question
Expert Answered
Asked 11/5/2012 1:16:04 PM
0 Answers/Comments
what are the different features of Excel that make it a valuable business tool.
Weegy: Ways that make excel valuable are Spreadsheets make it easy to collect and present many types of data and especially numerical information. Making a spreadsheet is similar to making a database table. [ Columns and rows should be headed to describe what is in the spreadsheet, and data should be entered accordingly. Read more: Ways to Use Microsoft Excel | eHow.com ] (More)
Question
Expert Answered
Asked 11/5/2012 1:23:38 PM
0 Answers/Comments
why are Excel skills are so important in today’s job market
Weegy: Excel Skill are so important in today's job market for matching and analyzing cost. Validating and maintaining item/cost information, analyzing cost variances for inventory. Auditing/processing invoices. [ Excel spreadsheet is used to store quantitative data and to perform accurate and rapid calculations with results ranging from simple budgets to financial analyses and statistical analyzes. This will help us in decission making by looking on the data itself. ] (More)
Question
Expert Answered
Asked 11/5/2012 3:42:56 PM
0 Answers/Comments
are Excel skills are so important in today’s job market
Weegy: Yes it is still important in todays job market.TExcel spreadsheet is used to store quantitative data and to perform accurate and rapid calculations with results ranging from simple budgets to financial analyses and statistical analyzes. [ Excel is part of a user interface which is the meeting point between computer software and the person using it and provides the means for a person to communicate with a software program. All businesses rely on some form of number system to keep track of merchandise, customer service surveys, stocks and employees. A system of accounting is used to keep records of employees, merchandise, materials, and all aspects that has to do with that business. ] (More)
Question
Expert Answered
Asked 11/5/2012 3:45:18 PM
0 Answers/Comments
In Excel: You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost.
Weegy: I will assume that you have Cost numbers in column A, Sales numbers in column B. Try this formula in cell C1: =if(B1>=1.2*A1, 0.06*B1,"") (More)
Question
Expert Answered
Asked 11/5/2012 6:14:51 PM
0 Answers/Comments
17,929,805 questions answered
Popular Conversations
Manhattan Island is __________. A. the largest island in Canada B. ...
Weegy: the manhattan island is the most highly populated island in north america. letter D would be the best answer. ...
10/22/2014 8:51:05 AM| 9 Answers
what is micro
Weegy: A microorganism is a microscopic organism, which may be a single cell or multicellular organism. User: what ...
10/21/2014 7:38:45 PM| 3 Answers
Arabian glass, which authorities believe appeared in the second half ...
Weegy: Obsidian, which was used by early man to make arrowheads, is a naturally occurring glass. 'which was used by ...
10/22/2014 10:45:16 AM| 3 Answers
Solve the inequality. 2(4 + x) > 4(x + 4) A. x > 4 B. x > ...
Weegy: 2w + 3 > 14; 2w > 14 - 3; 2w > 11; w > 11/2 User: Solve the inequality. 5a + 12 6 B. a < 6 C. D.
10/21/2014 12:59:56 PM| 3 Answers
The type of life insurance often used as mortgage insurance is?
Weegy: The type of life insurance often used as mortgage insurance is: Decreasing term.
10/21/2014 1:58:43 PM| 3 Answers
Anime
10/21/2014 9:41:19 AM| 2 Answers
what are quadratic equations
Weegy: You can apply quadratic equation to cook marshmallows by following these steps: 1. Select a quadratic ...
10/21/2014 10:48:49 AM| 2 Answers
What is the solution set of 2x ^2 - 3x = 5?
10/21/2014 11:05:05 AM| 2 Answers
Simplify -(-2a + 13) + (-9a - 2) - (-7a - 3).
Weegy: -(-2a + 13) + (-9a - 2) - (-7a - 3) = (-7a - 15) - (-7a - 3) = -12
10/21/2014 11:12:50 AM| 2 Answers
Determine the solution set of (x + 1)2 = 25. {-8, 6} {-8, ...
Weegy: The answer is 77,520. There are 77,520 possible committees that can be formed.
10/21/2014 11:18:30 AM| 2 Answers
Weegy Stuff
S
L
1
1
1
1
L
1
L
Points 2316 [Total 14691]| Ratings 0| Comments 2316| Invitations 0|Offline
S
L
1
L
P
C
1
P
C
1
L
Points 1464 [Total 10945]| Ratings 3| Comments 1434| Invitations 0|Offline
S
1
L
1
L
P
P
L
Points 811 [Total 13040]| Ratings 0| Comments 811| Invitations 0|Offline
S
L
Points 487 [Total 1886]| Ratings 0| Comments 487| Invitations 0|Offline
S
Points 482 [Total 482]| Ratings 0| Comments 452| Invitations 3|Offline
S
1
L
L
Points 476 [Total 6270]| Ratings 3| Comments 446| Invitations 0|Offline
S
Points 357 [Total 358]| Ratings 4| Comments 317| Invitations 0|Offline
S
Points 207 [Total 207]| Ratings 1| Comments 197| Invitations 0|Offline
S
P
C
L
P
L
1
Points 48 [Total 6282]| Ratings 0| Comments 48| Invitations 0|Offline
S
Points 27 [Total 27]| Ratings 0| Comments 27| Invitations 0|Offline
Home | Contact | Blog | About | Terms | Privacy | Social | ©2014 Purple Inc.