Home

St. Martin-in-the-Fields Episcopal School
7136 Winnetka Avenue
Winnetka, CA  91306
Phone: (818) 340-5144   Fax: (818) 340-5882
E-mail: stmartinsschool@aol.com

Computer Lab

 Computers
About Us

Middle School

Elementary School

Preschool

Current School Families

Support Our School

Visit Our Church

Excel Basics -Review

Let's see if we remember what we've learned about Excel.  

  • Type your name and grade into the boxes below.
  • Visit the sites below and answer the questions in the boxes provided. The sites you visit will open up in a new window (or tab is you have a newer browser). Just close the window (or tab) to return to this page and continue. Don't close this page or you'll lose your answers!
  • After you have answered all of the questions click the Send Answers button to send the answers to your teacher.

Your Name:  
Your Grade:  

Name The Spreadsheet Parts: (Can't remember? Go back and review Lesson 1!)

Open the Mini Poster at http://www.ncwiseowl.org/kscope/techknowpark/MiniPosters/Poster15.html and starting with the box pointing to D13 and proceeding counter-clockwise (that means you'll identify the pink bar under Grocery Item next, the last answer will be the box pointing to the =SUM(D....)) name the parts of the spreadsheet. Use the words at the top of the spreadsheet!

  1. Spreadsheet Part 1:
  2. Spreadsheet Part 2:
  3. Spreadsheet Part 3:
  4. Spreadsheet Part 4:
  5. Spreadsheet Part 5:
  6. Spreadsheet Part 6:
  7. Spreadsheet Part 7:
  8. What is the box outlined in red called? (This is not in the word selection on the mini poster):

Analyzing Spreadsheet Data:

Open the Mini Poster at http://www.ncwiseowl.org/kscope/techknowpark/MiniPosters/Poster16.html and answer the questions below.

  1. What is the cell address for the Tax on Dawson Creek CDs?
  2. What is the Total Cost of the order for Cruel Intention CDs?
  3. If you change the Qty of Shrek CDs, which other cells will likely change as a result?
  4. How much does 1 copy of a Forrest Gump CD cost?
  5. Which cell is active?
  6. What is the total cost for this order of CDs? 
  7. Purchasing 3 Bridget Jones Diary CDs will cost how much (make sure to include tax)?
  8. How much tax do you pay on an order of 3 Dawson Creek CDs?
  9. What is the formula in cell F6?
  10. What is the formula in cell H13?

Formulas & Functions:

  1. What is the formula in cell D7?
  2. What is the formula in cell D8?
  3. What is the formula in cell D9?
  4. What is the formula in cell D10?
     
  5. What Excel function would you use to calculate your average typing speed?
  6. If you have a row of numbers in cells B1, C1, D1, E1 & F1, what are 3 ways you could add these numbers together?
    Option 1:
    Option 2:
    Option 3:

Back to Computer Lab

St. Martin-in-the-Fields Episcopal School
 7136 Winnetka Avenue
Winnetka, CA  91306
Phone: (818) 340-5144   Fax: (818) 340-5882
E-mail: stmartinsschool@aol.com

Contact Our Webmaster.

 Home