Excel Assignments

Charts Assignments
Resource page provides you with information on formulas and symbols used in mathematical operations.
Complete assignments in the order that they appear in the table below as assignments get more difficult
as you progress through this unit.
Resource Page
Chart Assignments

  • Video Assignment

  • Class Assignment

  • Interest Analysis Assignment

  • Payroll Assignment Instructions
  • Budget Assignment

  • Territory Sales Assignment

    • Excel Spreadsheet Resources

    Mathematical Operators

    +

    		Addition

    -

    		Subtraction

    *

    		Multiplication

    /

    		Division

    (cell:cell)

    		Range
    Example of a range  (B1:B12)

    Formulas and Functions


    Formulas always begin with the "=" sign.
    This symbol tells Excel that a calculation is required.
    Formulas do not include spaces, and can include
    values and/or references to other cells.
    Formulas and Functions
    To add:=cell+cell+cell or
    =sum(range)
    To Subtract:=cell-cell
    To Multiply:=cell*cell
    To Divide:=cell/cell
    To Average:=average(range)
    To find the Lowest Number:=min(range)
    To find the Highest Number:=max(range)
    To Count #s:=count(range)
    To Count Labels:=counta(range)