Training Room 2

Project 3: Spreadsheet Skills

 

Training Room 2: Formatting Data and Content

 

Each training room you complete adds to the skill set you are developing in working with spreadsheets. In Training Room 2 you will manipulate the look of the worksheet and learn to select ranges of cells as well as navigate around the worksheet. You will begin to enter information in a variety of formats—such as text, dates, and times—as well as discover ways to format the information.

 

In this training room you will

• delete rows and columns
• insert rows and columns
• convert text to columns
• adjust column widths and row heights
• hide and unhide columns and rows
• adjust cell alignments
• center text across cells
• choose a theme for your document
• format table styles
• format cell styles

How to Do It

 

To successfully complete this training room, do the following:

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

You are now ready, once again, to start working in Microsoft Excel 2007. Open Training Room 2: Formatting Data and Content, and follow the instructions, starting with deleting rows and columns. Save your Training Room 2 in your INF2080 SS2 folder.

 

INF2080 Learn EveryWare © 2009 Alberta Education

Training Room 2: Formatting Data and Content

 

Time to Practise 2

 

Instructions

 

In this exercise you will apply all of the knowledge and skills covered in Training Room 2.

 

Read through the following instructions to see what you need to do to complete Time to Practise 2. You can either print these instructions or you can have them open alongside the Time to Practise 2 spreadsheet on your computer screen and work through them simultaneously.

 

Complete the following steps in order.

 

Step 1: Open Time to Practise 2.

 

Step 2: Center the Heading “Contact List” across the width of the table. Apply the Accent2 cell style, and change the font size to 20 point.

 

Step 3: Use the Text to Column Wizard to split the information in column B to Last Name and First Name. Remember to insert a blank column before column C first.

 

Step 4: Change the heading in column B to “LAST NAME,” and add the heading “FIRST NAME” to column C.

 

Step 5: Hide column A.

 

Step 6: Hide the row containing Ramid Marconi.

 

Step 7: Change the column widths so that all the information is showing.

 

Step 8: Change the height of row 5 to 30.00 (40 pixels).

 

Step 9: Center the headings in row 5 vertically and horizontally.

 

Step 10: Insert a column after the CITY column with the heading “PROVINCE”; then enter “AB” for each entry. Center all the data horizontally in that column.

 

Step 11: Apply the 60% - Accent2 cell style to the headings in row 5.

 

Step 12: Apply the 20% - Accent2 cell style to the rest of the data table.

 

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

 

Step 14: Open the Software Skills Checklist that you saved earlier 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 2 to your teacher for assessment.

 

If needed, revisit Training Room 2 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 3.

 

INF2080 Learn EveryWare © 2009 Alberta Education