Introduction to Spreadsheets

Uses of Spreadsheets?

• Prepare budgets• Maintain student grades• Prepare financial statements• Analyze numbers• Manage inventory• Make forecasts

Advantages of Spreadsheets

• Forecasting and making decisions• Fast and efficient• Automatically recalculates

What-if AnalysisA spreadsheet tool used to play out different situations to determine the outcome

Parts of the Spreadsheet Window

Active cell

Column C

Row 5

Cells

Entering Data into a Spreadsheet• Labels• Alphabetical text

• Values• A number

• Formulas• Statement that performs a calculation

• Functions• Built-in formula that is a shortcut for common

calculations

Identifying Data Type - Labels or Values

Labels Values

Identifying Formulas and Functions

Formula

Function

The result of the formula

The result of the function

Identifying Parts of a Spreadsheet Formula

=B2+C2+D2

Equal sign—first part of any spreadsheet formula

Mathematical operators

Cell reference/address—made up of the column heading and the row number

Identifying Parts of a Spreadsheet Function

=SUM(B2:B6)

equal sign

name of function range

Mathematical Operators

+ addition- subtraction* multiplication (asterisk)/ division (slash or diagonal)

Function Name DescriptionAVERAGE Average of arguments.COUNT Counts the number of cells in a range.IF Specifies a logical test to perform; then

performs one action if test result in true and another if it is not true.

MAX Maximum value of range of cells.MIN Minimum value of range of cells.ROUND Rounds a number to a specified

number of digits.SUM Totals a range of cells.

Spreadsheet Functions

Changing Column Width

1. Position cursor between column headings.

2. Make sure your cursor changes to cross-hairs.

3. Click and drag to the right.

Shortcut: double-click between the column headings!

Changing Row Height

1. Position cursor between row headings.

2. Make sure your cursor changes to cross-hairs.

3. Click and drag down.

Shortcut: double-click between the row headings!

Formatting Cells with Enhancements

bold bordersfont size

shading

underline

Numeric Formatting

generalcurrency

decimal

Print Orientations• Portrait• A paper orientation that is

taller than it is wide.

• Landscape• A paper orientation that is

wider than it is tall.

Print Options

without gridlines

with gridlines

Printing Column and Row Headings

with column and row headings

without column and row headings

Print Showing Formulas

formulas displayed

formulas NOT

displayed

Printing Selected Areas

highlight desired area, choose option to print

selected area (according to your

software)