Assignment 3: Spreadsheet Basics
featuring:

To find Excel, first look in the Applications folder, and inside that in the Microsoft Office 2004 folder.

When you open Excel, it will bring you to the “Project Gallery”, where you should select “Excel Workbook”.

An Excel Workbook is a collection of “Sheets”. You can see at the bottom that you start out with three sheets. But you can add more by using the Insert-> Worksheet command.

A spreadsheet is a grid of boxes, called “cells”. Each cell has a column (labeled A, B, C...), and a row labeled 1,2,3...).

Try the following:

1. Put the number 34 in cell C4. Put your first name in cell D4.
2. Select a range of cells with the top left being A5 and the bottom right being E12.
3. Give this block of cells a blue background, with yellow text.
4. Type the number 12.27 in cell A15. Highlight from cell A15 to A20, and then use the menu Edit-> Fill->Down to fill in all the cells with 12.27. (See picture at right).
5. Use Format-> Cells and choose the number tab. (below left). Experiment with the choices there to make your column of 12.27’s look like the one at right below using only the choices in the Format->Cells Number tab. Why is the bottom one on the left side of its cell.

Calculations: Go to “Sheet 2”. Put the list of grades below into a column.

• 89
• 94
• 77
• 67.5
• 93
• 88
• 90

Make a cell that finds the average grade. Label it.

Make a cell that finds the total of these grades. Label it.

Make a graph or chart with this list of grades. Label it.

 

"I believe that we are solely responsible for our choices,
and we have to accept the consequences of every deed,
word, and thought throughout our lifetime."
- Elisabeth Kübler Ross