Intro to Excel

1
Intro to Excel

• Introduction to Computers

2
Spreadsheets

• Excel is a spreadsheet program
• A spreadsheet is a matrix of row and ________
  data.
• Columns (top to bottom) are labeled with letters.
• Rows (left to right) are labeled with _________.

3
Excel as a Spreadsheet Program

• Excel calls spreadsheets worksheets.
• An Excel ___________ has 3 worksheets by default.
• For all Excel assignments in this class you must
  delete all blank worksheets. Just right click on
  the sheet tab at the bottom to delete/rename.
• Like a Word file is called a document, an Excel
  file is called a ________.
• A document has the file _________ doc, a
  workbook has the file _________ xls.

4
Selecting Cells

• Select an entire _______.
• Select all the cells in the worksheet.
• Select an entire row
• Switch to different _________.
• The gray lines that separate cells do not appear
  when printed.

5
Cells

• Cells are typically used to hold number
  information and formulas.
• You can change the background color of a cell
  using the pattern tab of the _______ Cell
  window
• You can change the border thickness, type and
  color using the borders tab of the Format Cell
  window.

6
Format Cell Window - Border

• First, select your style and color.
• Then select where you want the borders using the
  ________ or the buttons around the Text sample.

7
Format Cell Window - Patterns

• Set the color at the top to change the background
  color.
• Use the Pattern _________ to change other
  options of the cell. (leave it blank most of the
  time)

8
Format Cells Window Merge Cells

• Select the cells that you want to _______ and
  open the Format Cells window.
• Check the Merge cells box at the bottom and
  click OK.