Question
Asked by:
$1.00 Excel Help
- From Computer-Science: General-CS
- Closed, but you can still post tutorials
- Due on May. 05, 2009
- Asked on May. 04, 2009 at 09:23:06AM
Q:using Excel pick one of the following situations below and share with us some ideas for formulas you could create to help you work smarterÂnot harder.
You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost.
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.
You have a list of contracts and due dates for annual maintenance fees. You wish to determine when you have a contract coming due in the next 45 days and provide a note that warns you that the payment is coming due.
Some of the concerns for a spreadsheet we will create for a user to interact with and input data are: clear instructions, input validation, error messages and cell/spreadsheet protection.
Let's explore why these are important issues when creating a spreadsheet for a user to use when inputting data?
--> How can we incorporate instructions into a spreadsheet?
--> What is input validation and what are some strategies to accomplish it?
--> How can error or warning messages be delivered to the user?
--> Why would one want to lock or protect a cell from a user? how is this accomplished?
