Shared by:
Categories
Tags
-
Stats
views:
5
posted:
7/4/2012
language:
pages:
39
Document Sample

```							                    Introduction to
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
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
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
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

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

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.
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
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?
• Center my spreadsheet on a page and change margins?
•

2
•
1
Change Paper to Landscape and/or Change the Print size

4
• Turn on gridlines and set print area?
• Format cells?
– decimal places, currency, date, accounting,….
• 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?
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
– 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?
• Choose Insert tab>
0011 0010 1010 1101 Footer

in the section you want the

1
2

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
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?
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

```
Related docs
Other docs by HC12070418841
PLANTILLA ACTA - DOC