cst-094 basic spreadsheet click your left mouse button to proceed... © delta college cst faculty
Post on 01-Apr-2015
215 Views
Preview:
TRANSCRIPT
CST-094 Basic SpreadSheet
Click your left mouse button to proceed . . .
© Delta College CST Faculty
SpreadSheets handle numbers
EXCEL
Click your left mouse button to proceed . . .
Organize numbers in rows and columns
Perform mathematical calculations – sum of numbers
The SpreadSheet
Click your left mouse button to proceed . . .
Columns are named A - B - C . . .
Click your left mouse button to proceed . . .
A B C D
Rows are numbered 1 - 2 - 3 . . .
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
Intersection of Row and Column is a CellCell Address is ColumnRow
Click your left mouse button to proceed . . .
The highlighted cell is the “Current Cell” or the “Active Cell”
A B C D1
2
3
4
5
Cell A1
Move from Cell to Cell with the Arrow Keys
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
Pressing the Down-Arrow Key moves one cell Down - from A1 to A2Cell A2
Move from Cell to Cell with the Arrow Keys
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
And . . . pressing the Right-Arrow Key moves one cell to the Right - from A2 to B2Cell B2
Or . . . Click the Left Mouse Button on a cell to make it the Current Cell
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
The Mouse Pointer was moved to Cell C4 and the Left Mouse Button was ClickedCell C4
Cells Contain DataText in a cell is called a Label
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
By default, labels in a cell are left-justified within the cell
Cell A1 contains the label: Delta
Delta
Labels automatically spill overto the next cell if needed
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
As long as cell B1 does not contain any data, the “spilled-over” text will display and print
Cell A1 now contains the label: Delta College
Delta College
Cells can also contain a Number
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
By default, numbers in cells are right-justified within the cell
Cell A1 contains the number: 123
123
Often, you need to format the number . . . . . . later
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
Sometimes, the number will not appear formatted -- until you make it look “pretty”
Cell A1 contains the number: 123.40
123.4
Cells can also contain a calculation, called a Formula
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
Cell A1 contains the number 15
Cell A2 contains the number 12
Cell A3 will contain the sum of these two numbers
15
12
Formulas operate on cell addresses
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
Cell A1 contains the number 15 Cell A2 contains the number 12 Cell A3 contains a formula
Cell A3 says “This cell equals the number in Cell A1 added to the number in Cell A2”
15
12
=A1 + A2
Formulas begin with an = sign.
The Result of the formula appears in the cell
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
Cell A1 contains the number 15 Cell A2 contains the number 12 Cell A3 contains a formula
Cell A3 says “This cell equals the number in Cell A1 added to the number in Cell A2”
15
12
27
Result
fx
Where is the formula shown?. . . In the Edit Line!
Click your left mouse button to proceed . . .
The Name Box displays the address of the current cell (A3)
NameBox
fx
Where is the formula shown?. . . In the Edit Line!
Click your left mouse button to proceed . . .
The Formula Bar displays what is really in the current cell (=A1+A2)
NameBox
FormulaBar
Correcting Misteaks
• During data entry– Backspace / Delete / Re-Key
• After data entry– Make cell active
• Re-Key
• In Contents Box: Backspace / Delete / Re-Key
Mistakes
Click your left mouse button to proceed . . .
Click your left mouse button to proceed . . .
Range of Cells
• Single Cell
• Adjacent Cells in a Row
• Adjacent Cells in a Column
• Adjacent Cells in a “Rectangle”
Click your left mouse button to proceed . . .
( A1 : A3 )
Colon( )Beginning
Cell Address
Ending Cell
Address
Click your left mouse button to proceed . . .
Range of Cells
• Single Cell
• Adjacent Cells in a Row
• Adjacent Cells in a Column
• Adjacent Cells in a “Rectangle”
( A1 : A1 )
( A1 : C1 )
( B1 : B5 )
( A1 : C3 )
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
Range of Cells• Single Cell ( A1 : A1 )
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
Range of Cells• Adjacent Cells in a Row ( A1 : C1 )
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
Range of Cells• Adjacent Cells in a Column ( B1 : B5 )
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
Range of Cells• Adjacent Cells in a “Rectangle” ( A1 : C3 )
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
The Mouse Pointer• Select a Cell – click within it• Pointer is an outlined PLUS sign• Selected cell is outlined & has box in lower right
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
The Mouse Pointer• Select multiple Cells – click within first one• Pointer is an outlined PLUS sign• Drag to select the rest
Multiple cells are surrounded by border and box is in lower right corner -- Starting cell remains original color
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
The Mouse Pointer• If pointer at the border of a cell and dragged• Pointer is an Arrow on top of a 4-way + arrow• Cell is MOVED to where you drop it
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
The Mouse Pointer• If pointer at the border of a cell and dragged• Pointer is an Arrow• Cell is MOVED to where you drop it
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
The Mouse Pointer• Select a Cell – click on box in lower right corner• Pointer is a regular PLUS sign• Drag to select multiple cells
Delta
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
The Mouse Pointer• Select a Cell – click on box in lower right corner• Pointer is an regular PLUS sign• Drag to select multiple cells – and automatically copy
Delta Delta
Click your left mouse button to proceed . . .
A B C D1
2
3
4
5
Range of Cells• Define a Range of Cells by Highlighting it
– Point and click WITHIN the first cell– Hold the mouse pointer and drag to the last cell
( A1 : C3 )
Important: Do not point at border of cell while defining a range
A B C D1
2
3
4
5
Click your left mouse button to proceed . . .
Range of Cells• Define a Range of Cells by Highlighting it
– Point and click WITHIN the first cell– Hold the mouse pointer and drag to the last cell– Release the mouse pointer
( A1 : C3 )
Important: Do not point at border of cell while defining a range
Click your left mouse button to proceed . . .
Key the function in Cell A3
Point at the Box in the lower right corner of Cell A3 – your mouse pointer is a PLUS sign
You can copy this function!
A B C D1
2
3
4
5
15
12
26
42=SUM(A1:A2)
Click your left mouse button to proceed . . .
Drag the box in the lower right corner from Cell A3 to Cell B3 to highlight the range (A3:B3)
You can copy this formula!
A B C D1
2
3
4
5
15
12
26
42=SUM(A1:A2)
Highlight the range for the copy . . .
Click your left mouse button to proceed . . .
You have copied the function
You can copy this formula!
A B C D1
2
3
4
5
15
12
26
42=SUM(A1:A2) =SUM(B1:B2)
The formula is automatically copied from the first cell to the rest of the cells in the range
Click your left mouse button to proceed . . .
Instead of summing Column A, you are summing Column B
You copied the function one column to the right
The Function Was Adjusted
A B C D1
2
3
4
5
15
12
26
42=SUM(A1:A2) =SUM(B1:B2)
The new formula is adjusted one column to the right
This is called Relative Addressing
A’s become B’s
Click your left mouse button to proceed . . .
This is called Relative Addressing because the formulas are adjusted “relative” to how they were copied
Of Course, the Cells Show the Results of the Formulas
A B C D1
2
3
4
5
15
12
26
42
27 68
Click your left mouse button to proceed . . .
Key the function in Cell C1 Select the range (C1:C2) using the corner box Drag the corner box down to copy
The Formula was copied down one row so the “1’s” become “2’s”
You Can Also Sum In A Row
A B C D1
2
3
4
5
15
12
26
42
=SUM(A1:B1)
=SUM(A2:B2)
1’sbecome
2’s
Click your left mouse button to proceed . . .
The Results of the calculations are shown in the cells
You Can Also Sum In A Row
A B C D1
2
3
4
5
15
12
26
42
41
54
Click your left mouse button to proceed . . .
The Asterisk (*) is used for multiplication
Here’s Some Multiplication
A B C D1
2
3
4
5
15
12
26
42
=A1 * B1The formula in Cell C1 says “I’m equal to the number in Cell A1 multiplied by the number in Cell B1.
Click your left mouse button to proceed . . .
The formula can be “Copied-Down” by dragging the corner box . . .
Here’s Some Multiplication
A B C D1
2
3
4
5
15
12
26
42
=A1 * B1The “1’s” become “2’s” so you end up multiplying Cell A2 by Cell B2 and putting that result in Cell C2
=A2 * B2
Click your left mouse button to proceed . . .
As usual, the results are in the cells
Here’s Some Multiplication
A B C D1
2
3
4
5
15
12
26
42
390
504
Math Symbols
• + Addition
• - Subtraction
• * Multiplication
• / Division
Click your left mouse button to proceed . . .
Click your left mouse button to return to the PowerPoint Viewer . . .
This Concludes Introduction to Excel
© Delta College CST Faculty
top related