Understanding Microsoft Excel Lesson 1 Microsoft Excel 2010
- Slides: 12
Understanding Microsoft Excel Lesson 1 – Microsoft Excel 2010
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 else? ? ?
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 Headers
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 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 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). 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 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 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 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.
- Microsoft office excel adalah aplikasi pengolah
- Microsoft excel 2010 training
- Lesson 1 understanding science answer key
- Microsoft official academic course microsoft excel 2016
- Microsoft microsoft excel merupakan program aplikasi
- Excel 2010 kullanımı
- Goal seek in excel 2007
- Correlation means
- Cara mengaktifkan macro di excel 2010
- Excel 2010 kullanımı
- Miscrosoft excel
- Excel 2010
- Solver excel 2007