f2

• MS Excel


  A computer program used to create electronic spreadsheets
• MS Excel


  • Allows user to organize data, create charts, and perform calculations
  • Convenient program that allows creating large spreadsheets, referencing information, and better storage of information
  • Operates like other Microsoft Office programs and has many of the same functions and shortcuts
• Workbook


  Microsoft Excel consists of workbooks
• Worksheet


  Within each workbook, there is an infinite number of worksheets
• Cell


  Where a column and a row intersect is called a cell. For example, cell D5 is located where column D and row 5 meet
• Tabs


  The tabs at the bottom of the screen represent different worksheets within a workbook. You can use the scrolling buttons on the left to bring other worksheets into view
• Ribbon


  There are seven tabs across the top of the Excel window, which contain groups of related commands
• Copying and pasting cell contents

  1. Select the cell or cells you wish to copy

  2. Click the Copy command

  3. Select the cell or cells where you want to paste the information

  4. Click the Paste command
• Cutting and pasting cell contents

  1. Select the cell or cells you wish to cut

  2. Click the Cut command

  3. Select the cell or cells where you want to paste the information

  4. Click the Paste command
• Formatting text


  1. Left-click a cell to select it or drag cursor over text in formula bar to select it

  2. Click the Bold, Italics or Underline command

  3. Left-click the drop-down arrow next to the Font Style box and select a font style

  4. Left-click the drop-down arrow next to the Font Size box and select a font size

  5. Click the drop-down arrow next to the Borders command and select a border option

  6. Left-click the drop-down arrow next to the Text Color command and select a color

  7. Click the Fill command and select a color
• Applying conditional formatting


  1. Select the cells you would like to format

  2. Select the Home tab

  3. Locate the Styles group

  4. Click the Conditional Formatting command and select formatting options
• Removing conditional formatting


  1. Click the Conditional Formatting command

  2. Select Clear Rules

  3. Choose to clear rules from the entire worksheet or the selected cells
• Managing conditional formatting


  1. Click the Conditional Formatting command

  2. Select Manage Rules from the menu

  3. Edit a rule, delete a rule, or change the order of rules
• Applying new conditional formatting


  1. Click the Conditional Formatting command

  2. Select New Rules from the menu

  3. Apply different rules to differentiate particular cells
• Inserting rows and columns


  1. Select the row below where you want the new row to appear, then click the Insert command

  2. Select the column to the right of where you want the column to appear, then click the Insert command
• Fill handle


  The lower right-hand corner of the active cell, which can be used to copy or fill a series
• Filling cells


  1. If you have one cell selected, clicking and dragging the fill handle will copy the contents to other cells

  2. If you have two cells selected, Excel will fill in a series based on the pattern
• Sorting data

  1. Select a cell in the column you want to sort

  2. Click the Sort & Filter command

  3. Select Sort A to Z or From Smallest to Largest
• Relative cell reference


  A cell reference like A1 that is based on the relative position of the cell, so it changes if the cell position changes
• Absolute cell reference


  A cell reference like $A$1 that always refers to a specific cell location, so it doesn't change if the cell position changes
• Mixed cell reference


  A reference with either an absolute column and relative row, or absolute row and relative column, like $A1 or A$1
• DATEDIF function


  Calculates the difference between two dates in days, months, or years
• SUMIF function


  Sums values in a range that meet a specified criteria
• IF function


  Returns one value if a logical test is true, and another value if the test is false
• Count functions


  • COUNT
  • COUNTA
  • COUNTBLANK
  • COUNTIF
• Text functions

  • LOWER
  • UPPER
  • PROPER
  • LEFT
  • RIGHT
  • MID
• Other functions

  • NOW
  • TODAY
  • MOD
  • LEN
  • SUM