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

Rating

There are no new answers.

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

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

In Excel: You wish to calculate the total pay for an employee who receives regular time for 40 hours, time and a half for 40-50 hours, and double time for hours over 50.
**Weegy:** Here is a formula that would accomplish your goal. The formula assumes that hours are in A1, and base pay is in B2:
=A1*B1+MAX(0,MIN(50,A1)-40)*B1*0.5+MAX(0,MIN(50,A1)-50)*B1
(More)

Question

Expert Answered

Asked 11/5/2012 6:49:36 PM

0 Answers/Comments

22,414,624 questions answered

There are no comments.