Moving Around Excel

• ARROW



  AN ARROW MOUSE POINTER WILL ALLOW YOU TO SELECT COMMANDS IN THE RIBBON

  
• THICK CROSS


  A THICK CROSS POINTER WILL ENABLE YOU TO SELECT A CELL OR A RANGE OF CELLS

  
• I BEAM


  AN I BEAM MOUSE POINTER TO SELECT A TEXT WITHIN A FORMULA BAR

  
• FILL HANDLE


  A FILL HANDLE MOUSE POINTER IS USED TO COPY CELL CONTENT

  
• DOUBLE HEADED ARROW


  THE DOUBLE HEADED ARROW ALLOWS YOU TO ADJUST THE COLUMNS WIDTH AND ROW HEIGHTS

  
• LABELS


  ARE TEXT ENTRIES WHICH DO NOT HAVE A VALUE ASSOCIATED WITH THEM. LABELS ARE USED TO IDENTIFY DATA IN YOUR WORKSHEET.
• VALUES


  ARE NUMERIC DATA USED IN CALCULATIONS INCLUDING DATES. DATA IS CONSIDERED AS A VALUE IF IT BELONGS TO ANY TYPE OF NUMERIC DATA
• FORMULAS


  ARE COMPOSED OF VALUES, CELL REFERENCE, ARITHMETIC OPERATORS AND SPECIAL FUNCTIONS
• 3 BASIC TYPES OF ENTRIES

  • LABELS
  • VALUES
  • FORMULAS
• Examples of Labels

  • PROBLEM
  • ROW
  • MANAGE
  • COLOR
  • CELL
• EXAMPLES OF VALUES

  • 125
  • 12987
  • 7854
• EXAMPLES OF FORMULAS

  • =SUM()
  • =C56*B89
  • =TODAY()
  • =A2+B2
  • =NOW()
• MATHEMATICAL AND LOGICAL OPERATION SYMBOLS

  • OPERATORS ENCLOSED IN A PARENTHESIS
  • ()
  • PERCENTAGE
  • %
  • EXPONENTIAL
  • ^
  • MULTIPLICATION
  • *
  • DIVISION
  • /
  • ADDITION
  • +
  • SUBTRACTION
  • -
• SAVE

  • ALLOWS YOU TO SAVE YOUR WORKBOOK
  • SAVE YOUR WORK FREQUENTLY TO UPDATE THE FILE AND AVOID THE LOSS OF DATA
  • BY DEFAULT, FILES ARE BEING SAVED INSIDE THE DOCUMENTS FOLDER
  • THE DEFAULT NAME EXCEL ASSIGNS IN THE NEWLY CREATED WORKBOOK IS BOOK 1
  • CTRL+S
• OPEN

  • TO OPEN AN EXISTING WORKBOOK
  • CTRL + O
• NEW

  • TO CREATE A NEW WORKBOOK
  • CTRL + N
• EXIT/ CLOSE

  • TO CLOSE THE CURRENT WORKBOOK
  • TO EXIT MS EXCEL
  • CTRL + W
  • ALT + F4
• CUT

  • MOVING DATA FROM ONE LOCATION TO ANOTHER
  • CTRL + X
• COPY

  • TAKING A COPY OF THE DATA TO ANOTHER LOCATION
  • CTRL + C
• PASTE

  • DATA IS PASTED AT THE SELECTED LOCATION
  • CTRL + V
• CLIPBOARD

  • IS LIKE A SCRATCH PAD THAT ALLOWS PIECES OF INFORMATION TO BE TEMPORARILY STORED
  • THERE ARE 24 ITEMS THAT YOU CAN COLLECT FROM ANY APPLICATION AND STORE IN THE CLIPBOARD
• UNDO

  • IS USED TO REVERSE ANY ACTION SUCH AS SPELLING, FORMATTING AND EDITING CHANGES
  • YOU CAN REVERSE UP TO 16 PREVIOUS ACTIONS
  • CTRL + Z
• REDO

  • REVERSES THE ACTIONS OF THE UNDO COMMAND
  • TO REPEAT THE ACTION THAT YOU UNDID
  • CTRL + Y