Dr. Cotter's Excel Tutor

# Dr. Cotter's Excel Tutor - Old Dominion University...

This preview shows pages 1–8. Sign up to view the full content.

1 Old Dominion University Introduction to Microsoft Excel © T. Steven Cotter, Ph.D. Engineering Management and Systems Engineering © Old Dominion University, 2009 Norfolk, Virginia

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
2 Old Dominion University Introduction to Microsoft Excel © Contents Chapter Title Page 1 The Excel Environment – Office 2007 3 2 Building Worksheets 12 3 Creating Formulas and Performing Data Analysis 31 4 Creating and Formatting Charts 42 5 Working with Functions 50
3 Old Dominion University Introduction to Microsoft Excel © Chapter 1: The Excel Environment – Microsoft Office 2007 © The Workbook Window A new workbook, shown in Figure 1 as a floating window, is made up of a number of components. Figure 1: Workbook components. Column heading letters ranging from A to IV (after column Z comes AA through AZ, BA through BZ, etc.). Row headings range from 1 through 65,536. The currently selected cell is referred to as the active cell.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
4 Old Dominion University Introduction to Microsoft Excel © When a range of cells is selected, only the upper left corner cell is active. The headings for the columns and rows of a range of selected cells are highlighted, making it easier to identify the location of the selected cells. A worksheet can contain up to 256 columns and 65,536 rows or more than 16 million cells. However, the number of cells that can be used in any given worksheet is limited to (1) the amount of computer memory and (2) the number of bytes of information in the worksheet. Be default, a new workbook contains 3 worksheets. The default setting can be changed by clicking on the Office Button, selecting Excel Options, and changing the default number of worksheets per workbook in the Options properties window. Otherwise, new worksheets can be added by left clicking on the “New Worksheet” tab.
5 Old Dominion University Introduction to Microsoft Excel © Worksheets can be renamed by double left clicking on the tab name and typing a new name. Click anywhere in the worksheet to return active control to the sheet and register the new worksheet name.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
6 Old Dominion University Introduction to Microsoft Excel © Right clicking on the title bar, a scroll box, a worksheet tab, or an active cell opens a context sensitive shortcut menu of commands.
7 Old Dominion University Introduction to Microsoft Excel © Menus Microsoft Excel’s main menus provide worksheet editing, layout, and formatting functionality. The “Home” menu provides the most used functionality. The “Insert” menu provides the means to insert tables, graphics objects, charts, hyperlinks, or text objects into a worksheet. The “Page Layout” provides formatting options for printed page output.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 10/17/2009 for the course MET 387 taught by Professor Dean during the Spring '09 term at Old Dominion.

### Page1 / 57

Dr. Cotter's Excel Tutor - Old Dominion University...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online