Open main menu

Computer Skills/Basic/Spreadsheets

Basic spreadsheets includes recognizing user interface elements and entering data.

Objectives and SkillsEdit

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

MultimediaEdit

ActivitiesEdit

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 AlsoEdit

ReferencesEdit