Practice Formulas for Spreadsheets
Create a spreadsheet with formulas to solve the equations for you.  5 of each, Addition, subtraction, Multiplication and Division.
Attach the file to the assignment in JupiterGrades when finished.


Steps, please follow carefully;
  1. Open Numbers
  2. Create a new file
  3. In column A list addition, subtraction, multiplication and division as show below
  4. In Columns B - F enter data - for example in the graphic below, I entered; "5" in cell B2 and "3" in cell B3.
  5. When entering the formula, type the = sign to get the formula bar, for example, in the graphic below, I entered the following in cell B4;  =(this brings up the formula bar) sum(B2+B3) and press the return or enter key or the green check mark, your sum will appear in cell B4.
  6. Continue the addition formulas across Columns B, C, D, E, and F using your own data.
  7. Then create 5 of each for subtraction, multiplication and division.
  8. Use + for addition, - for subtraction, * for multiplication and / for division signs.
  9. Please refer to the links to the help pages and user guides at the bottom of this page to assist you.
  10. Note - this is usually a one day in-class lesson.  However, I realize that this is a difficult concept so we will spend the entire week on it.
  11. There is also a video below to show you how to create and enter formulas.
  12. When this is graded, I will look not at the answers, but at the formulas that are entered.  For example, in the graphic below the correct answer is  (B2+B3) not the number "8".



Here is a video sample
 

User guides and help pages
Getting started with Numbers for iCloud
Numbers User Guide for iCloud
Numbers User Guide for Mac

Back to RCMS Lab