Microsoft Excel 2010 a lessonapproach Lesson 1 Getting

Objectives 1 • Navigate in a workbook. a lesson approach 2 • Edit data

Objective 1 a lesson approach Navigating in a Workbook 3 © 2011 The Mc.

a lesson approach Navigating in a Workbook How you start Excel depends on how

The Excel Worksheet Quick Access toolbar Title bar Command tab Ribbon Formula bar Name

a lesson approach Backstage View for an Open Workbook © 2011 The Mc. Graw-Hill

a lesson approach Navigating in a Workbook § A workbook is the file that

a lesson approach Navigation Commands in a Workbook © 2011 The Mc. Graw-Hill Companies,

Scrolling Through a Worksheet When you scroll in a worksheet, the active cell does

a lesson approach Scrolling Techniques © 2011 The Mc. Graw-Hill Companies, Inc. All rights

Changing the Zoom Size a lesson approach The Zoom size controls how much you

a lesson approach Closing a Workbook You can close a workbook by § Clicking

a lesson approach Backstage View to Create a Workbook © 2011 The Mc. Graw-Hill

Objective 2 a lesson approach Editing Data in a Worksheet 14 © 2011 The

Editing Data in a Worksheet a lesson approach § Worksheet cells contain text, numbers,

a lesson approach Opening an Existing Workbook You can open a workbook by §

a lesson approach Protected View Workbooks that are opened or copied from an Internet

a lesson approach Editing Cell Contents § When the worksheet is in Ready mode,

a lesson approach Keyboard Shortcuts in Edit Mode © 2011 The Mc. Graw-Hill Companies,

a lesson approach Using Undo and Redo § To undo an edit, click the

Filling a Series a lesson approach § A series is a list of labels,

Objective 3 a lesson approach Working with Columns and Rows 23 © 2011 The

a lesson approach Working with Columns and Rows § Columns are 8. 43 spaces

Modifying Row Height and Column Width a lesson approach Resizing a Column Resizing a

a lesson approach Working with Columns and Rows § Inserted or deleted rows and

Objective 4 a lesson approach Saving Workbook Files 27 © 2011 The Mc. Graw-Hill

Saving Workbook Files a lesson approach § To save a workbook, give it a

Objective 5 a lesson approach Printing Excel Files 29 © 2011 The Mc. Graw-Hill

a lesson approach Printing Excel Files § Press [Ctrl]+[P] to open Backstage view for

a lesson approach Backstage View for Printing © 2011 The Mc. Graw-Hill Companies, Inc.

Objective 6 a lesson approach Getting Acquainted with Excel Functions 32 © 2011 The

a lesson approach Getting Acquainted with Excel Functions © 2011 The Mc. Graw-Hill Companies,

a lesson approach Copying a Function with the Fill Handle © 2011 The Mc.

Objective 7 a lesson approach Using Alignment, Borders, and Fill 35 © 2011 The

a lesson approach Using Alignment, Borders, and Fill § Cell alignment determines how the

a lesson approach Horizontal Alignment Choices © 2011 The Mc. Graw-Hill Companies, Inc. All

Objective 8 a lesson approach Getting Acquainted with an Excel Chart 38 © 2011

a lesson approach Getting Acquainted with an Excel Chart © 2011 The Mc. Graw-Hill

Getting Acquainted with an Excel Chart a lesson approach § A chart is a

Exiting Excel a lesson approach There are several ways to close a workbook and

a lesson approach Summary § Excel opens with a blank workbook and the Ribbon.

a lesson approach Summary § Worksheets are divided into cells, the intersections of rows

a lesson approach Summary § Replace cell data by clicking the cell and keying

a lesson approach Summary § Column widths and row heights can be changed, and

a lesson approach Summary § Cell alignment affects how cell contents are horizontally or

Slides: 46

Download presentation

Objectives 1 • Navigate in a workbook. a lesson approach 2 • Edit data in a worksheet. 2 3 • Work with columns and rows. 4 • Save workbook files. 5 • Print Excel files. 6 • Get acquainted with Excel functions. 7 • Use alignment, borders, and fill. 8 • Get acquainted with an Excel chart. © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

a lesson approach Navigating in a Workbook How you start Excel depends on how your software is installed and what shortcuts, if any, are available. Excel opens with a blank workbook, the Quick Access toolbar, and the Ribbon. The screen size and its resolution setting affect how command buttons appear. © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

The Excel Worksheet Quick Access toolbar Title bar Command tab Ribbon Formula bar Name Box Active cell Column headings a lesson approach Row headings Vertical scroll bar Tab scrolling buttons Zoom slider and buttons Horizontal scroll bar Worksheet tabs View switcher Status bar © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

a lesson approach Navigating in a Workbook § A workbook is the file that Excel creates to store data. § A worksheet is an individual page or tab in the workbook. § A cell is a rectangle formed by the intersection of a row and a column. § Cell addresses identify where the cell is located on the worksheet. © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

Scrolling Through a Worksheet When you scroll in a worksheet, the active cell does not change. Up scroll arrow a lesson approach Vertical scroll box Horizontal scroll box Right scroll arrow Left scroll arrow Tab splitter Down scroll arrow © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

Changing the Zoom Size a lesson approach The Zoom size controls how much you see on screen. You can set the size to be larger or smaller. Zoom Slider Zoom Out Zoom In © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

a lesson approach Closing a Workbook You can close a workbook by § Clicking the Close Window button. § Clicking the File command tab and choosing Close. § Pressing [Ctrl]+[W]. § Pressing [Ctrl]+[F 4]. © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

Editing Data in a Worksheet a lesson approach § Worksheet cells contain text, numbers, or formulas. § To determine a cell’s contents, click the cell and check the formula bar. © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

a lesson approach Opening an Existing Workbook You can open a workbook by § Clicking the File command tab and choosing Open. § Pressing [Ctrl]+[O]. § Pressing [Ctrl]+[F 12]. § Double-clicking the file name in an Explorer or a Computer window. © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

a lesson approach Editing Cell Contents § When the worksheet is in Ready mode, click the cell, key the new data, and press [Enter]. § To delete cell contents, click the cell and press [Delete]. § Start Edit mode by double-clicking a cell. § Start Edit mode by clicking the cell and pressing [F 2]. § Start Edit mode by clicking the cell and clicking in the formula bar. © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

a lesson approach Using Undo and Redo § To undo an edit, click the Undo button on the Quick Access toolbar. § Press [Ctrl]+[Z] to undo. § Press [Alt]+[Backspace] to undo. § To redo an edit, click the Redo button on the Quick Access toolbar. § Press [Ctrl]+[Y] to redo. § Press [F 4] to redo. © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

Filling a Series a lesson approach § A series is a list of labels, numbers, dates, or times that follows a pattern. § You can create a series by keying two values or labels that set an identifiable interval. § A series is extended using the Fill handle. © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

a lesson approach Working with Columns and Rows § Columns are 8. 43 spaces (64 pixels) wide with the default Office document theme. § Rows are 15. 00 points (20 pixels) high. § A point measures 1/72 inch. § A Screen. Tip helps you size columns/rows when you drag a border. § You can also use the Column Width and Row Height dialog boxes. © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

a lesson approach Working with Columns and Rows § Inserted or deleted rows and columns extend across and down the entire worksheet. § If a row/column is inserted within a formula range, the formula is adjusted to include the new row/column. § If a row/column within a formula range is deleted, the formula is adjusted. © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

Saving Workbook Files a lesson approach § To save a workbook, give it a descriptive file name. § Try to keep file names as short as possible, although they can be up to 255 characters. § You can use uppercase or lowercase letters in a file name. Windows does not distinguish between them. § Do not use these characters in a file name ? : *“<>| § Excel workbook file names are followed by a period and a four-letter extension, XLSX. © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

a lesson approach Printing Excel Files § Press [Ctrl]+[P] to open Backstage view for printing. § Click the File command tab and choose Print to open Backstage view. § Click the Quick Print button if it is on the Quick Access toolbar. © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

a lesson approach Using Alignment, Borders, and Fill § Cell alignment determines how the contents of a cell are positioned in the cell. § A border is a line around a cell or a group of cells. Borders are used to emphasize data, group data, and more. § Fill is the background color or pattern for a cell or group of cells. It is used for grouping and emphasis. © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

Getting Acquainted with an Excel Chart a lesson approach § A chart is a graph of data in the worksheet. § A chart style is a preset selection of colors and special effects. § A chart has many smaller objects including a title and data labels. © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

Exiting Excel a lesson approach There are several ways to close a workbook and exit Excel. You can: § Click the File command tab and choose Exit. § Click the Close button to close the workbook and then again to exit Excel. § Press [Ctrl]+[F 4] to close a workbook. § Press [Alt]+[F 4] to exit Excel. © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

a lesson approach Summary § Excel opens with a blank workbook and the Ribbon. § The File command tab shows information about the open workbook and provides access to Open, Print, and Save & Send commands. § A new workbook opens with three worksheets. A worksheet is an individual page or tab in the workbook. © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

a lesson approach Summary § Worksheets are divided into cells, the intersections of rows and columns. The location of the cell is its address (also called its cell reference). § The active cell is outlined with a black border. It is ready to accept new data or a formula or to be edited. § The Name Box shows the address of the active cell. You can also use it to change the active cell. © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

a lesson approach Summary § Replace cell data by clicking the cell and keying new data. Edit long or complicated cell data rather than rekeying them. § The Undo and Redo buttons have history arrows so that you can undo or redo multiple commands at once. § Use the Fill handle to fill a series of labels or to copy a formula. © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

a lesson approach Summary § Column widths and row heights can be changed, and columns and rows can be inserted or deleted. § An Excel workbook has an xlsx file name extension. § A function is a built-in formula. Commonly used functions such as SUM and AVERAGE can be inserted from a button on the Home tab. © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.

a lesson approach Summary § Cell alignment affects how cell contents are horizontally or vertically positioned. § Fill and borders can be used to differentiate and emphasize parts of the worksheet for greater readability. § A chart is a graphic representation of data in a worksheet. Charts have various elements that can be edited to change the look of the chart. © 2011 The Mc. Graw-Hill Companies, Inc. All rights reserved.