Training Room 3

Project 3: Spreadsheet Skills

 

Training Room 3: Functions and Formulas in Spreadsheets

 

Each training room you complete adds to the skill set you are developing in working with spreadsheets. In Training Room 3 you will advance your knowledge of formulas by using more functions within the AutoSum function, by making use of date and time formulas, and by applying logic and financial formulas.

 

In this training room you will

• study common functions
• work with minimum and maximum formulas
• calculate averages
• use functions to find minimum, maximum, and average
• summarize data using subtotals
• create formulas for dates and time
• use functions to count both text and numbers
• use functions to calculate monthly payments, interest rates, and present value
• use conditional logic in a formula (e.g., IF statements)
• format text using text functions
• look up data using formulas
• protect cells

How to Do It

 

To successfully complete this training room, do the following:

• Read and watch instructional videos of topics covered in the training room.
  
• Use help and online references should you require additional instruction or software assistance.
  
• Complete the Time to Practise 3 exercise.

You are now ready, once again, to start working in Microsoft Excel 2007. Open Training Room 3: Functions and Formulas in Spreadsheets, and follow the instructions, starting with common functions. Save your Training Room 3 in your INF2080 SS2 folder.

 

INF2080 Learn EveryWare © 2009 Alberta Education

Training Room 3: Functions and Formulas in Spreadsheets

 

Time to Practise 3

 

Instructions

 

In this exercise you will apply all of the knowledge and skills covered in Training Room 3. Read through the following instructions to see what you need to do to complete Time to Practise 3.

 

Complete the following steps in order.

 

Step 1: Open Time to Practise 3.

 

Step 2: Complete the four worksheets in this exercise: Functions 1, Functions 2, IF Statements, and TEXT & LOOKUP. Instructions are provided within each worksheet.

 

Step 3: Save the document as Time to Practice 3 in your INF2080 SS2 folder.

 

Step 4: Open the Software Skills Checklist, and complete the chart for the skills you developed in this training room.

 

 

Once you are finished and have saved your work, submit your Time to Practise 3 to your teacher for assessment.

 

If needed, revisit Training Room 3 to review any of the skills in which you had difficulties. If you are confident in your skills and abilities, then move on to Training Room 4.

 

INF2080 Learn EveryWare © 2009 Alberta Education