Home Organizing Worksheet - Excel by nnd20824

VIEWS: 7 PAGES: 12

More Info
									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
   a. Rows add above
   b.Columns added to left
   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
             5. row and column headings
        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
     9. Headers and Footers
           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
          4.   Addition or subtraction
          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
     3. Use your arrow                     4
     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