Understanding Microsoft Excel Lesson 1 Microsoft Excel 2010

  • Slides: 12
Download presentation
Understanding Microsoft Excel Lesson 1 – Microsoft Excel 2010

Understanding Microsoft Excel Lesson 1 – Microsoft Excel 2010

What is Excel? • Lets you put numbers into a spreadsheet so that you

What is Excel? • Lets you put numbers into a spreadsheet so that you can do things such as calculations, graphs, and statistical analysis quickly. • Uses: – Logging my daily workouts – Creating a household budget – Calculating grades

Starting Excel Clicking on an Icon on the Desktop Using the Start Menu What

Starting Excel Clicking on an Icon on the Desktop Using the Start Menu What else? ? ?

Spreadsheet Terms • Spreadsheet – The type of program that is used to perform

Spreadsheet Terms • Spreadsheet – The type of program that is used to perform calculations. • Worksheet – A blank page in a spreadsheet file. • Workbook – A collection of worksheets.

More Spreadsheet Terms Name Box Title Bar Active Cell Row Headers Formula Bar Column

More Spreadsheet Terms Name Box Title Bar Active Cell Row Headers Formula Bar Column Headers

Opening and Closing Worksheets • When you first open Excel, you see one blank

Opening and Closing Worksheets • When you first open Excel, you see one blank worksheet. • The visible worksheet is actually part of a workbook that contains three sheets. (Sheet 1, Sheet 2, Sheet 3). Close a worksheet Open a blank worksheet

Naming and Saving a Workbook • A filename and location should be assigned the

Naming and Saving a Workbook • A filename and location should be assigned the first time a workbook is saved. Save often!!! • The file name can be up to 255 characters in length. • The / < > * ? " | : ; characters may not be used when naming a workbook. • Save a workbook for the first time using either the Save option in Backstage view or by clicking the Save icon on the Quick Access Toolbar. • Save it with a new name or new file type by clicking “Save As” in the Backstage view.

Templates • For spreadsheets that have already been set up for specific purposes, use

Templates • For spreadsheets that have already been set up for specific purposes, use a template • You can save spreadsheets that you create to use as templates later. What would be the benefit of using a template?

Selecting Cells You can select 1 cell or a group of cells (a range).

Selecting Cells You can select 1 cell or a group of cells (a range). Cell ranges are identified by the first cell address and the last cell address, separated by a colon. Use the “select all” button to select all cells. How would you identify the cell range shown?

Cell Selection, continued. Select non-adjacent cells by holding down CTRL. The “Name Box” shows

Cell Selection, continued. Select non-adjacent cells by holding down CTRL. The “Name Box” shows the address of the active cell. Click the row or column header to select an entire row or column.

Entering Data into a Worksheet Text (sometimes called labels) – words or numbers that

Entering Data into a Worksheet Text (sometimes called labels) – words or numbers that won’t be used in math Notice that anything typed in the active cell appears in the formula bar. Formula - a mathematical equation used to calculate a value. Numbers – Values that will be used in math

Entering Data into a Worksheet • When typing in a active cell the content

Entering Data into a Worksheet • When typing in a active cell the content also appears in the formula bar. • By default, text is left aligned and values are right aligned. • Vertical alignment can be adjusted by dragging the bottom border of the row heading up or down.