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 makes Excel such a valuable business tool
Weegy: We can store so many data and can add,multiply, divide, subtract the data as we wish. Important tools like formulas can be easily employed to find out analytical result. Easy and convenient to create daily / weekly / monthly records (More)
Question
Expert Answered
Asked 11/5/2012 12:51:16 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
17,359,171 questions answered
Popular Conversations
a line has a slope of -3/5
Weegy: The slope of the line between the points (-3, 5) and (5, 1) is -1/2. Solution: m = y2-y1/x2-x1; m = (1 - ...
9/14/2014 11:26:31 AM| 2 Answers
what opens the insert dialog box in excel
9/14/2014 2:36:49 PM| 2 Answers
Prior to Muhammad’s teachings, Arabs were polytheistic.
Weegy: TRUE. Prior to Muhammad s teachings, Arabs were polytheistic. User: One Thousand and One Nights is a famous ...
9/14/2014 3:41:04 PM| 2 Answers
The National Response Framework (NRF) presents the guiding principles ...
Weegy: Provide the structure and mechanisms to ensure effective Federal support of State, tribal, and local related ...
9/14/2014 6:18:29 PM| 2 Answers
Who is the individual responsible for all incident activities, ...
Weegy: The Incident Commander is the individual responsible for all incident activities, including the development of ...
9/14/2014 6:42:56 PM| 2 Answers
What is the slope of the line whose equation is 12 = 4x – 6y? ...
Weegy: Points A and B lie on the graph of the equation y = 7x. The y-coordinates for each point is: Point A: (-2, -14) ...
9/14/2014 10:52:00 PM| 2 Answers
what is Land Ordinance of 1785?
Weegy: An advantage of the Land Ordinance of 1785 because it provided a systematic division of the land survived at a ...
9/14/2014 11:22:56 PM| 2 Answers
5x-13=3x+15
Weegy: 3x + 17 = 5x - 13; 17 + 13 = 5x - 3x; 30 = 2x; x = 30/2; x = 15 User: 142+8x-1
9/14/2014 11:41:07 PM| 2 Answers
HELLO WEGGY
Weegy: Yes? May i help you? "Weegy is an online artificial being, powered by an advanced search engine and live ...
9/14/2014 12:49:55 AM| 1 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
P
C
P
C
L
Points 1580 [Total 25979]| Ratings 4| Comments 1540| Invitations 0|Offline
S
L
1
L
P
C
1
Points 1543 [Total 8074]| Ratings 8| Comments 1463| Invitations 0|Online
S
L
1
1
1
1
L
1
L
Points 1109 [Total 10889]| Ratings 0| Comments 1109| Invitations 0|Offline
S
L
P
C
L
P
C
P
C
L
P
C
P
C
P
C
Points 1006 [Total 18178]| Ratings 2| Comments 986| Invitations 0|Offline
S
L
C
P
C
1
L
L
P
C
1
Points 974 [Total 16913]| Ratings 8| Comments 894| Invitations 0|Online
S
1
L
1
L
P
P
L
Points 394 [Total 11640]| Ratings 0| Comments 394| Invitations 0|Offline
S
L
P
C
P
C
1
L
P
C
L
P
C
P
C
P
C
P
C
Points 351 [Total 18882]| Ratings 0| Comments 351| Invitations 0|Online
S
1
L
L
Points 342 [Total 5466]| Ratings 4| Comments 302| Invitations 0|Offline
S
L
Points 340 [Total 1010]| Ratings 0| Comments 340| Invitations 0|Offline
S
P
C
L
P
L
1
Points 45 [Total 6102]| Ratings 1| Comments 35| Invitations 0|Offline
Home | Contact | Blog | About | Terms | Privacy | Social | ©2014 Purple Inc.