Computer Skills/Basic/Spreadsheets
< Computer Skills | Basic
Basic spreadsheets includes recognizing user interface elements and entering data.
Objectives and Skills
editObjectives 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- YouTube: Excel 2010: Navigating Excel 2010
- YouTube: Excel 2010: Environment
- YouTube: Excel 2010: Creating Workbooks
- YouTube: Excel 2010: Cell Basics
- YouTube: Excel 2010: Modifying Cells, Rows, and Columns
- YouTube: Excel 2010: Format Cells
- YouTube: Excel 2010: Saving
- YouTube: Excel 2010: Printing
- YouTube: How to Find and replace data in Excel 2010
Activities
editThese activities may be completed using any spreadsheet application (Microsoft Excel, LibreOffice Calc, Google Spreadsheet, Apple Numbers, etc.):
- Start your spreadsheet application. It should automatically open with a new, blank spreadsheet.
- Identify columns (letter labels) and rows (number labels).
- Identify the active cell (A1). Use the cursor keys to move around the spreadsheet and continue to identify the active cell.
- Return to cell A1. Enter your name in cell A1.
- 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.).
- Use Print Preview to see the page layout for your spreadsheet.
- Print your spreadsheet.
- Save your spreadsheet.
- Review Excel-Easy: Find & Select. Download the find-select.xls file and complete the activities listed.
- 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.