# Home Organizing Worksheet - Excel by nnd20824

VIEWS: 7 PAGES: 12

• pg 1
```									1. Organizing Your worksheet
a. Copy and Paste
i. Do not highlight entire range
1.   Home Tab, Clipboard group, cop
2.   Right click
3.   Control C or Control V
4.   Move: cut which is Control X

b.Drag and Drop
i. Move or Copy (Ctrl)
c.Fill Command using Fill handle
i.     Auto Fill Options button
ii. Adjacent cells – Up, down, lef
iii. Pull the little black box – short
2. Insert/Delete rows and columns
c. Home tab, cell, Insert or Delete
3. Freezing titles
a. Why?
b.View tab, Window group, Freeze
c. Row: select the row below
d. Column: select column to the right of the co
4. Spell check
a. Review tab, Proofing group, spelling
5. Printing
a. All or choose page range
b.Print what?
1. selection
2. active sheet
3. entire workbook
c.number of copies
6. Page Setup
a. Margins: also center page horizontally and ver
b.Sheet:
1. print area
2. repeat titles
3. collapse buttons
4. gridlines
c.Page: fit to one page, orientation – landscape
7. Page Layout tab, Margins, tab, Margin or Orient
8. Splitting a Window
* View different parts of a large work
at the same time.
* Breaks into 2 or 4 parts.
* Split horizontally or vertically.
Row/column, window, split
* view tab, window group, split button
a. Insert, text group, Header and Foote

Formulas: equations used to calculate values in a cell
Excel recognizes a formula when _____________ is the first ch

6
8
Operand                   14

Operator
+                              =B3-5
-
*
/
^

Order of Evaluation:

1.   Parentheses
2.   Exponentiation             =38-9*(2+4)
3.   Multiplication or division
5.   Positive or negative
6.   Left to right

Relative Cell References      345        456
Absolute Cell References      322        433
667
Mixed Cell References

How to get formulas into your worksheet:
1. type the formulas in               2
2. Point and Click                    2
4. AutoSum

F9   manual calculation

34
45
145
345
=SUM(D98:D101)

Equal sign; Function Name; Argument

Enter Function Formulas
1. Fx button
2. Formulas tab, Function Library group, Insert Function
3. Type it in

Mathematical & Trigonometric Functions: SUM, SQRT, ROUN
Manipulates quantitative data in a worksheet.

Statistical Functions: AVERAGE, COUNT, MAX, MIN, STDEV,
Describe large quantities of data

Financial Functions: FV, PV AND PMT
Used to analyze loans and investments.

Date, Time and Text Functions

Logical Functions: IF
ght entire range
oard group, copy/paste button

s Control X

y (Ctrl)

ns button
s – Up, down, left, right
black box – short cut – turns into a plus sign
he right of the colum you want to freeze

pelling
rizontally and vertically

tion – landscape or portrait
Margin or Orientation, Size, Print Area

s of a large worksheet

vertically.
ndow, split
, split button

der and Footer

es in a cell
_____ is the first character in the cell.

9*(2+4)

2
4
6
8
p, Insert Function

UM, SQRT, ROUND, LN
a worksheet.

MAX, MIN, STDEV, VAR

56
60
ments.                 89
93
43

```
To top