LAB 4


 

This lab contains material on Microsoft Excel . Herein we will look at how to create and use a basic spreadsheet. This page has an overview of the materials we will be covering in the lab, as well as links to a small tutorial and a few exercises. You are encouraged to experiment with the Excel platform on your own once you have become more comfortable manipulating commands in Excel.


This lab will again consist of two parts. The first exercise will introduce you to a sample spreadsheet. Using those as a guide, you can familiarize yourself with some basic commands in Excel . The topics include: learning how to edit cells, changing cell formats, using and copying formulas, and sorting data.


The second exercise will start building your spreadsheet abilities further by introducing you to the Chartmaking utilities in Excel. You will create a new spreadsheet that will allow you to learn how to create and use a chart, as well as the Autoincrement function. Lastly, you will modify and chart some of the worksheet seen in Exercise 1.

Also, keep in mind that there may be a few additional exercises (practice or otherwise) that will be covered as we begin to cover the material in this lab.


Note: If you are unfamiliar with Excel, it is recommended that you go through the short introduction provided below. Otherwise, you are free to work on the exercises which follow in turn.

You may now go to the Excel introduction page.

Introduction to Microsoft Excel

Return to 1001 Home Page