Title: Microsoft Word – Word Processing



MS Excel - Spreadsheets

Excel allows you to create spreadsheets that can perform automatic calculations. Each Excel file is a workbook that can hold many worksheets. The worksheet is a grid of columns (designated by letters) and rows (designated by numbers). The letters and numbers of the columns and rows (called labels) are displayed in gray buttons across the top and left side of the worksheet. The intersection of a column and a row is called a cell. Each cell on the spreadsheet has a cell address that is the column letter and the row number. Cells can contain either text, numbers, or mathematical formulas.

[pic]

To create a spreadsheet:

1. Label your columns by typing in the first cells across the spreadsheet (ex. If creating a grade book you may have last name, first name, assignments, etc.)

2. Enter any other necessary labels you need (ex. Type the students names and grades in the appropriate cells)

3. Enter formulas in the cells where you want calculations to occur

Formula Basics:

1. All formulas must start with the “=” sign

2. Standard symbols are – addition “+”, subtraction “-“, multiplication “*”, and division “/”

3. You must use the cell address (the column letter and row number) of the cell you wish to work with then the mathematical symbol followed by the next cell address

4. In the example below, the formula both multiplies to get the total price then adds to get the subtotal. This formula would be placed in the subtotal box (where you want that number to appear)

[pic]

Creating a graph:

1. Enter the data into the worksheet and highlight all the cells that will be included in the chart including headers.

2. Click the Chart Wizard button on the standard toolbar to view the first Chart Wizard dialog box.

3. Chart Type - Choose the Chart type and the Chart subtype if necessary. Click Next.

4. Chart Options - Enter the name of the chart and titles for the X- and Y-axes. Click Next.

5. Chart Location - Click As new sheet or select As object in if the chart should be embedded in an existing sheet.

6. Finish

Discovery:

Spend some time in Microsoft Excel practicing these skills.

Application:

Create a spreadsheet and graph showing how many birthdays a group of people has in each month. (You can just make up this data)

1. Label all your columns across the top

2. Type in all appropriate data needed (ex. Months, and number of birthdays)

3. To practice your formulas – have a subtotal cell at the bottom and add the number of birthdays from all the months. Have this total appear next to the subtotal label

4. Create a graph using this data (You should NOT highlight the subtotal cells when creating the graph)

List ideas for use in the media center below:

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download