1. Training Room 2

INF2080

Project 3: Spreadsheet Skills

 

Training Room 2: Formatting Data and Content

 

A picture shows a woman working at a computer with a mouse.

© Dmitriy Shironosov/shutterstock

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.