Spreadsheet

Introduction

A brief description of the spreadsheet environment.

Anatomy of a Spreadsheet

Learn about the different parts of a spreadsheet.

Create a Spreadsheet

Learn to create a new spreadsheet document.

Enter Data

Learn how to enter data into your spreadsheet.

Selecting a Cell

Learn how to select a single cell or a range of cells.

Number Format

Learn how to change the format of numbers, dates and times in a spreadsheet.

Sorting Cell Data

Learn to sort data in a spreadsheet.

Formulas

Learn how to add functionality to your spreadsheet by adding formulas to complete calculations.

Types of Formulas

Learn about formulas that calculate different operations.

Activities

Book Order Spreadsheet

Use what you have learned to create a simple spreadsheet to calculate the totals of a book order you are about to send in to a company. The spreadsheet will help you keep track of the amount each student ordered as well as calculate the total amount your entire class ordered. First, create a new spreadsheet. In cell A1, type “Name”--you will use this as a column heading. In cell B2, type “Amount”. Then type your students’ names down column A, and then type the total amount of each students’ book order down column B. Select the numeric data down column B, and change the format to currency. At the end of your students’ names, enter the label “Total”. At the end or your data in column B enter in the formula that looks something like this: =SUM(B2..B15). Be sure that this cell is formatted for currency. The total of your book order will appear.