BIS155 Course Discussions Week 2

$4.50

BIS155 Course Discussions Week 2
One of the benefits of Excel is the ability to use formulas and functions…

SKU: BIS 155 Formulas and Functions Categories: , Tags: , , ,

Description

BIS155 Course Discussions Week 2

BIS155 Course Discussions Week 2

All Students Posts – 48 Pages 

Formulas and Functions

One of the benefits of Excel is the ability to use formulas and functions. Discuss the differences between formulas and functions. Pick a function in Excel and discuss how that function is used to calculate results in your worksheets. Using the following scenarios, discuss how you would apply the Excel functions or create a formula to solve the scenario.

  • 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 due in the next 45 days and provide a note that warns you that the payment is due.

A Formula is just what it sounds like.  A formula is used to calculate cells, rows, or data within the spreadsheet.   You can create a formula to do exactly what you want it to do.

A Function is a formula that is already loaded in Excel so you don’t have to figure out the formula yourself.   A good example of one would be the SUM function.  One function in Excel that I would use would be the SUM function.  When you use the SUM it can figure out a whole row of numbers and give you the total with out you putting a long formula in the cell…