Document Sample

```					Digital Communication Systems

Spreadsheet . . .
a program that allows you to use ROWS and COLUMNS of data to
manage, predict, and present information.

A         B
2
4    CD Player     \$48.00
5    Nike Jacket   \$99.75
6    Gap Jeans     \$59.00
Computer                ROW
7    Game           \$68.50
8    Three CD's     \$31.25
9
10   Total Cost    \$306.50

COLUMN

 Fast and Accurate

 Can answer “What Is….?”

 Can Answer “What If….?”
Can Answer “What Is….?”
 students’ current grade (school)

 individual athlete statistics (sports)

 transportation schedules (business)

 current \$ available for spending (personal)

 census results
Can Answer “What If….?
 student population increases (school)

 win/loss record changes (sports)

 product sales decrease (business)

 hourly wage rate changes (personal)
Uses of Computer
 School
 payroll
 class sizes
 schedules         Sports
 individual and team
statistics
 current and future budgets
Uses of Computer Spreadsheets,
cont’d
 Personal
 checkbook
 household expenses
 investments
 income taxes
   payroll
   investments
   inventory
   product sales
   delivery
Uses of Computer

 Government
 Taxes
 Census
 Loans
 Investments
 budgets
Title Bar                 Menu Bar
Cell Reference Box

Toolbar
Formatting toolbar

Formula bar
Active Cell

Worksheet Tabs

Status Bar                  Scroll Bars     Task Plane

 Active Cell - The cell ready for data entry.
 Alignment - When data is entered into a cell,
the default alignment is labels to the left and
values to the right.
 Cell - Intersection of a row and column and is
identified by a cell reference.
 Cell range - A selected group of cells that
form a rectangle

 Cell reference - The column letter and the
row number. Example: B12
 Column - Identified by letters that appear at
the top of the spreadsheet. (Vertical)
 Formula - Equations with symbols for math
operations. Example =B6+B7+B8+B9
 Function - Special formulas that do not use
operators to calculate a result. i.e. A shortcut
formula. Example: =sum(A6:A9)
 Label - Text, symbols, dates, or numbers not
used in calculations.
 Rows - Identified by numbers on the left side
of the spreadsheet. (Horizontal)
 Spreadsheet - A program that allows you to
use rows and columns of data to manage,
predict, and present information.
 Value - A number entered into a spreadsheet
cell that will be used for calculations
A         B
1       BIRTHDAY GIFTS                  Cell (B3)
2                              Intersection of a row and a
3        GIFT        COST                column
4    CD Player       \$48.00
5    Nike Jacket     \$99.75
6    Gap Jeans       \$59.00
Value
Computer
A number entered on a
7     Game             \$68.50
spreadsheet and used for
8     Three CD's       \$31.25          calculations
9
10    Total Cost      \$306.50

Label                              Formula
Text, Symbols, dates, or             An equation with symbols
numbers not used in                  for math operations
calculations                     B4+B5+B6+B7+B8
More Terms
A         B
2
4    CD Player        \$48.00
5    Nike Jacket      \$99.75
6    Gap Jeans        \$59.00    Range (B4:B8)
A block of cells
Computer
7    Game              \$68.50
8    Three CD's        \$31.25
9
Functions
10   Total Cost       \$306.50   Shortcut formulas
Sum(B4:b8)
Average….averages the range
Is it a Value, Label, Function, or Formula?
22
Number
A3*D6
\$2,300.00
355-6961
AVG(C6:C10
27834 (zip code)
Social Security Number
NAME
The total of expenses
Commission * Rate
The sum of the range G2-G25
15%
522 S. Saunders Street
Writing a Formula
Text                                 What is the formula?
 Multiply F3 times C4                    =F3 * C4
 Add A2 and A3.                          =A2+A3
 Subtract D4 from D3.                    =D3-D4
 Divide E3 by C1.                        =E3/C1
 Add the range B2-B10                    =sum(B2:B10)
 Add C6 through C10 then subtract C5.    =sum(C6:C10)-C5
 Add A3 and A4 then divide by C10        =(A3+A4)/C10
 Find the average of D1through D10.      =average(D1:D10)
Formulas . . .
A tool for making calculations with the numbers

Four Basic Calculations
Subtract            -            C3-D4
Multiply            *            B6*A2
Divide              /            F1/F3
Order of Operations

You can also use parenthesis in your calculations
where the order of operations is completed first:
(A1+A2)*(B7/D4)
(7+11)*(4/2)
18*2
36
Function-Shortcut formula

SUM function will add all
numbers in a range
2
4   CD Player         \$48.00
5   Nike Jacket       \$99.75
6   Gap Jeans         \$59.00
Range=(B4:B8)
Computer
7    Game              \$68.50
8    Three CD's        \$31.25
9
10   Total Cost     sum(B4:B8)

Function
Function-Shortcut formula

1        BIRTHDAY GIFTS            Average (avg) function
2                                 averages all numbers in a
range
4    CD Player        \$48.00
5    Nike Jacket      \$99.75
6    Gap Jeans        \$59.00
Computer                         Range
7    Game                \$68.50
8    Three CD's          \$31.25
9
10   Total Cost    avg(B4:B8)

Function

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 10 posted: 2/17/2012 language: English pages: 20