Working with spreadsheets

Lab 4a: Working with spreadsheets

Introduction

Your activity is to learn Excel or Google Sheets by working through examples.

Learning Objectives

1. Become familiar with the interface of Microsoft Excel
2. Know how autocomplete works with dates and numbers
3. Format cells using dates, currency, numbers, and text
4. Apply what you learned by building a class schedule

Note: Ask your instructor if you should use Microsoft Excel or Google Sheets.

Assessment

To get full credit, you will need to:

1. Work through all five exercises in Excel Lab Manual - January 2013 University of Calgary.pdf
2. Create an Excel spreadsheet or Google Sheet that has your course schedule

Task 1: Get to Know Spreadsheets

Please note: The instructions are written for computers operating in English, localized for North America (American and Canadian English).

• Sunday may not auto-increment to Monday. However, Воскресенье should auto-increment to понедельник
• 1,000 might look like 1 000
• 1,000.00 might look like 1 000,00 or 1.000,00

This first task introduces you to prominent features in Excel.

1. Work through exercises 1-5 in Lab Excel Lab Manual - January 2013 University of Calgary.pdf.
   
   [pic 1]
2. When completed show or submit your document to your instructor

Task 2: Create your Class Schedule

You will practice what you learned by creating your weekly schedule

When completed, it will look something like:

[pic 2]

1. Create a new spreadsheet.

1. Give it a name, such as: Jimmy’s Schedule (using your name)

1. Enter the days of the week as the column header

1. Hint: You only need to type in Monday (or понедельник), the Excel will do the rest (See Auto-complete section Excel Basics

1. Enter the class times as the row headers

1. Such as in the image (but use your own class times)

1. Make the column and row headers bold
2. Fill in your class schedule

1. If you have a class, enter the class name
2. If you have a break during class time (a time when you do not have a class), fill the cell with a light-green color (or a color of your choice)

1. Merge cells that span multiple time periods
2. Put a border around all cells

1. Select all cells for your schedule
2. Click the drow-down glyph next to the border
3. Select ‘All borders’

1. Give the outside edge a dark border (Thick Outside Border)
2. When completed show or submit your document to your instructor