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: create simple spreadsheets, combined with powerful automation, graphing, ... Learn the Excel features that automate your work, prevent errors, make data entry ... You can learn the valuable skills that will help you: ... [ multiple lists or tables from different departments into one consolidated table (THAT IS WHY) ] (More)
Question
Expert Answered
Asked 11/5/2012 12:39:29 PM
0 Answers/Comments
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
21,116,080 questions answered
Popular Conversations
What is the numerator of the remainder in the division of: (x^3 ...
Weegy: 3x - 4 = 2x - 10 3x - 2x = -10 + 4 x = -6 User: Kyler is looking at the polynomial function f (x) = x^3 - ...
5/28/2015 8:17:45 AM| 3 Answers
immigration
Weegy: Net immigration is the amount by which the number of immigrants (= people arriving to live in a country) is ...
5/28/2015 7:49:14 AM| 2 Answers
The measure of disorder in a system is its ...
Weegy: The measure of disorder in a system is its enthalpy. User: Pressure has an effect on boiling point because ...
5/28/2015 8:52:32 AM| 2 Answers
When looking up at the clouds, you can usually make out different ...
Weegy: Stratus clouds indicate possible precipitation. User: A front forms when _____. warm air begins to rise and ...
5/28/2015 10:25:17 AM| 2 Answers
Impressionist music used a technique that was the opposite of harmony ...
Weegy: Impressionist music used a technique that was the opposite of harmony and that used disagreeable sounds. This ...
5/28/2015 10:42:20 AM| 2 Answers
Slang and colloquialism are synonymous. True False
Weegy: Slang and colloquialism are synonymous. FALSE. User: The manner in which a writer uses vocabulary and ...
5/28/2015 11:28:10 AM| 2 Answers
Factor completely. -5x2y + 10xy - 15xy2
Weegy: -5x2y + 10xy - 15xy2 = 5xy (-x + 2 - 3y) User: 81a2 + 36a + 4 User: -2k - k3 - 3k2
5/28/2015 1:55:48 PM| 2 Answers
An electric heater uses 3/ 5 watts of power each hour. How many ...
Weegy: The unit of power is the watt. TRUE. User: Write the decimal 0.006 as a fraction. A. 6/10 B. 6/1,000 C. 6/100 ...
5/28/2015 3:55:37 PM| 2 Answers
Weegy Stuff
S
Points 759 [Total 767]| Ratings 1| Comments 749| Invitations 0|Offline
S
L
Points 706 [Total 1236]| Ratings 2| Comments 686| Invitations 0|Offline
S
1
L
Points 614 [Total 1006]| Ratings 3| Comments 584| Invitations 0|Offline
S
L
P
Points 450 [Total 2927]| Ratings 1| Comments 440| Invitations 0|Offline
S
P
C
L
P
L
1
P
P
1
P
1
Points 248 [Total 8994]| Ratings 0| Comments 248| Invitations 0|Offline
S
Points 182 [Total 202]| Ratings 0| Comments 182| Invitations 0|Offline
S
1
L
L
Points 84 [Total 8267]| Ratings 0| Comments 84| Invitations 0|Offline
S
L
1
R
Points 80 [Total 1367]| Ratings 0| Comments 80| Invitations 0|Offline
S
L
Points 56 [Total 3810]| Ratings 2| Comments 36| Invitations 0|Online
S
Points 13 [Total 13]| Ratings 0| Comments 13| Invitations 0|Offline
Home | Contact | Blog | About | Terms | Privacy | Social | ©2015 Purple Inc.