Get documents about "Introduction to Spreadsheets
Shared by: HC12070418841
-
Stats
- views:
- 5
- posted:
- 7/4/2012
- language:
- pages:
- 39
Document Sample
Introduction to
Spreadsheets
0011 0010 1010 1101 0001 0100 1011
1
2
4
Computer Technology
Terms you need to know
(need to know these for use in the program and on a test)
0011 0010 1010 1101 0001 0100 1011
• Rows • Labels
• Columns • Numeric Labels
1
2
• Range • Values
• Cells • Mathematical
4
• Active Cell Operators
• Cell Address • Orders of Operation
• Workbook • Equation Formula
• Worksheet • Function Formula
Microsoft Excel
0011 0010 1010 1101 0001 0100 1011
• A program which allows your to perform
complex mathematical operations in an
1
2
organized manner without using a handheld
calculator.
4
Microsoft Excel Layout
0011 0010 1010 1101 0001 0100 1011
Tabs Ribbon
1
2
4
Groups
What is a Spreadsheet?
0011 0010 1010 1101 0001 0100 1011
• A Spreadsheet is a grid of rows and
columns containing numbers and text.
Columns
1
2
R
o
w
s
4
The Size of the Spreadsheet
0011 0010 1010 1101 0001 0100 1011
• Number of Rows
–65536
• Number of Columns 1
2
–256
4
Some terms
0011 0010 1010 1101 0001 0100 1011
• Workbook • Worksheet
– An Excel file that – One page in an
1
2
contains single or Excel workbook
multiple
4
worksheets
Rows vs. Columns
0011 0010 1010 1101 0001 0100 1011
• Rows • Columns
– Identified by – Identified by
1
2
1,2,3, etc. and A,B,C and goes
goes across the across the
4
spreadsheet spreadsheet
horizontally vertically.
Cell
0011 0010 1010 1101 0001 0100 1011
• This is where a row and column meet. Each
cell has a cell coordinate.(Isn’t it romantic!)
1
2
Examples of this are A1, C5, Z34
4
Label-Value-Range
0011 0010 1010 1101 0001 0100 1011
• Label- Alphanumeric data that describes the
values that follow and cannot be used in a
1
2
calculation.
• Value - Numeric data that can be used in
4
calculations
• Range-A rectangular group of adjacent
cells.
Columns
Active Cell
0011
R 0010 1010 1101 0001 0100 1011
o
Range
w
(A3:A6)
s
1
2
Range (A8:C8)
4
Cell Address
0011 0010 1010 1101 0001 0100 1011
Label
1999-2000 Numeric
1
2
Label
4
0011 0010 1010 1101 0001 0100 1011
Numeric Label
Label
1
2
Value
4
Label Value
Label Value
Label Value
Value
0011 0010 1010 1101 0001 0100 1011
What is this
called? 1
2
4
0011 0010 1010 1101 0001 0100 1011
• It is called the active
cell…...
1
2
4
0011 0010 1010 1101 0001 0100 1011
• One page of your work in an
Excel workbook is called…..
1
2
4
• A Worksheet…..
0011 0010 1010 1101 0001 0100 1011
1
2
4
Notice that there are multiple
worksheets in this workbook. You
should have 6 worksheets in one
workbook for CT-4.
To Insert a new worksheet right click on the tab
and choose Insert.
0011 0010 1010 1101 0001 0100 1011
1
2
4
To change the name of a worksheet
right click on the tab and select
Rename. Use the Insert tab to add
worksheets so there are 6.
0011 0010 1010 1101 0001 0100 1011
Last Question…...
1
2
4
0011 0010 1010 1101 0001 0100 1011
• Numeric data that can be used
in calculations are called…..
1
2
4
0011 0010 1010 1101 0001 0100 1011
Values
1
2
4
Mathematical
Operators
0011 0010 1010 1101 0001 0100 1011
• Addition
1
2
• Subtraction
• Multiplication
• Division /
*
4
Orders of Operation
0011 0010 1010 1101 0001 0100 1011
1. Parenthesis
2. Exponents
3.
4.
Multiplication
Division 1
2
5.
6.
Addition
Subtraction
4
Two Types of Formulas
0011 0010 1010 1101 0001 0100 1011
• A formula is an instruction to calculate a
number.
• All Formulas begin with an equal sign
1
2
=
4
• Equation Formulas
– Use mathematical operators (+, -, *)
• Function Formulas
– Use function names (SUM, AVERAGE, MAX)
Equation Formulas
To add
0011 0010 1010 1101 0001 0100 1011
To multiply
=cell+cell+cell =cell*cell
To subtract To Divide
2
=cell-cell = cell/cell
Or any combination of math 1
4
operators:
A1 = 10
Example = A1*10 B3 = 2
Example: =(A1 + B3)*B7+10
B7 = 5
Function Formulas
0011 0010 1010 1101 0001 0100 1011
• =function name(cell:cell)
• Function Names
1
2
– SUM - adds a range of cells
– AVERAGE - finds the average of a range of cells
4
– MIN - lowest value in a range
– MAX - highest value in a range
– COUNT - number of cells filled with a value
– COUNTA - number of cells filled with a label
Examples of Function Formulas
0011 0010 1010 1101 0001 0100 1011
• To add a range of cells
=sum(A1:A250)
• To find the average
=average(A1:B25) 1
2
• To count a range of values
=count(B50:H100)
4
How Do I…
0011 0010 1010 1101 0001 0100 1011
• Use function formulas?
• Add/delete columns or rows?
• Center my spreadsheet on a page and change margins?
•
2
Insert a header or footer on my spreadsheet?
•
1
Change Paper to Landscape and/or Change the Print size
of my spreadsheet
4
• Turn on gridlines and set print area?
• Format cells?
– decimal places, currency, date, accounting,….
• Add Borders and Shading?
• Merge cells?
• Fill Down a column?
Function Formulas
0011 0010 1010 1101 0001 0100 1011
• The first step to using formulas it to think
about what mathematical operation you want
to accomplish. It helps sometimes to write the
math problem on paper first.
1
2
• Next click on the cell where you want the
answer to the formula to appear.
• Choose the formula you want from the drop
4
down menu next to the Sum icon.
• Select the cells you want to include in the
operation. If Excel guesses the cells for you,
MAKE SURE TO VERIFY THAT THOSE
ARE THE CELLS YOU WANT! EXCEL
IS NOT ALWAYS RIGHT!!
Back to: How Do I?
Add/Delete Columns or Rows
0011 0010 1010 1101 0001 0100 1011
• Select the column or row where you’d like
to add one or select the column you wish to
2
delete.
• Use the following keyboard shortcuts.
1
– To add use Ctrl+ (hold control and strike the
4
plus key it’s best to use the + on the number
pad)
– To delete use Ctrl- (hold control and strike the
minus key)
Back to: How Do I?
Center a Spreadsheet on a Page and
Change Margins
0011 0010 1010 1101 0001 0100 1011
• Page Layout tab>Page
Setup
• Change margins in
1
2
designated boxes.
• Click the horizontally (if
4
you want it centered
between the left and right
margins or vertically (if
you want it centered
between the top and
bottom margins) box(es). Back to: How Do I?
Insert Header or Footer
• Choose Insert tab>
Header & 0001 0100 1011
0011 0010 1010 1101 Footer
• Header/Footer tab
• Type the desired header
in the section you want the
1
2
header to appear.
Back to: How Do I? 4
Portrait or Landscape Portrait
0011 0010 1010 1101 0001 0100 1011
• What is Portrait or
Landscape?
– They are terms that
1
2
describe the paper Landscape
orientation.
• Choose Page Layout
4
tab.
• On the Page Tab, you
can choose portrait or
landscape orientation
Back to: How Do I?
Gridlines and Print Area
0011 0010 1010 1101 0001 0100 1011
• Page Layout tab>
Page Setup
2
• Check the gridlines
box to turn them on.
• To set print area, click 1
4
here, then drag to
select the area you
want to print.
Back to: How Do I?
Format Cells
0011 0010 1010 1101 0001 0100 1011
• Select the cells you wish
to format
• Choose Home tab>
1
2
Number
• Choose the desired format.
4
• Select the additional
desired options (number
of decimals, 1000
separator) and click OK
Back to: How Do I?
Merge Cells
1. Select the 2. Click the
range needed
0011 0010 1010 1101 0001 0100 1011 Merge Cells
button
1
2
Back to: How Do I? 4
Entering Formulas using the Fill Handle
When you want to copy the contents of one cell into the cells
above or below or to the right or left, you can drag the small black
fill handle in the bottom corner
0011 0010 1010 1101 0001 0100 1011 of the active cell. Use this
technique instead of typing the same formula many times.
1
2
Click and Drag
4
the Fill Handle
in the bottom
corner of the
activated cell
with the correct
formula.
Back to: How Do I?
Add Borders and Shading
0011 0010 1010 1101 0001 0100 1011
• Activate the cells that you
want borders around
1
2
• Select the Font Group and
Border tab
• Select the Border, Style and
4
Color of the lines you wish.
• For shading select the Fill
tab.
Back to: How Do I?
0011 0010 1010 1101 0001 0100 1011
1
2
4
