Computer Skills/Basic/Spreadsheets

From Wikiversity
Jump to: navigation, search

Basic spreadsheets includes recognizing user interface elements and entering data.

Objectives and Skills[edit]

Objectives and skills for basic spreadsheets include:[1]

  • Recognize structure and purpose
  • Recognize the active cell
  • Know how to enter data
  • Interpret simple spreadsheets and data
  • Conduct a search in a simple database

Multimedia[edit]

  1. YouTube: Excel 2010: Navigating Excel 2010
  2. YouTube: Excel 2010: Environment
  3. YouTube: Excel 2010: Creating Workbooks
  4. YouTube: Excel 2010: Cell Basics
  5. YouTube: Excel 2010: Modifying Cells, Rows, and Columns
  6. YouTube: Excel 2010: Format Cells
  7. YouTube: Excel 2010: Saving
  8. YouTube: Excel 2010: Printing
  9. YouTube: How to Find and replace data in Excel 2010

Activities[edit]

These activities may be completed using any spreadsheet application (Microsoft Excel, LibreOffice Calc, Google Spreadsheet, Apple Numbers, etc.):

  1. Start your spreadsheet application. It should automatically open with a new, blank spreadsheet.
  2. Identify columns (letter labels) and rows (number labels).
  3. Identify the active cell (A1). Use the cursor keys to move around the spreadsheet and continue to identify the active cell.
  4. Return to cell A1. Enter your name in cell A1.
  5. Move to cell A2. Enter your age in cell A2. If you prefer not to enter your age, you can enter the number for the month you were born (January = 1, etc.).
  6. Use Print Preview to see the page layout for your spreadsheet.
  7. Print your spreadsheet.
  8. Save your spreadsheet.
  9. Review Excel-Easy: Find & Select. Download the find-select.xls file and complete the activities listed.
  10. To interpret simple spreadsheets and data, identify the fastest car and model and the most expensive car and model in the Find & Select Sheet1 worksheet.

See Also[edit]

References[edit]