This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Excel ENGR102 Fall 2006 Copyright, 2006 Gregory E. Ogden Excel Hints and Cool Tricks Remind students that excel is a cell-based program. It consists of cells that are aligned in rows and columns. Each column is referenced by a letter (a, b, c, etc.) and each row is referred to by a number. For example in the figure below, the cell B2 contains the number 6.25. While E1 has the number 0.001. The area highlighted below covers cells A1 through E5. Excel was created for accounting purposes. It is very easy to create tables of data (columns and columns). One can also perform simple and complex calculations on individual cells as well as copy data (numerical or words) and formulas from one cell (or range of cells) to another. Each file (called a worksheet) can have one or more spreadsheets, noted by the tabs on the bottom. Complex worksheets can use multiple spreadsheets and have inter-related formulas (between spreadsheets). You can create graphs in Excel and either place them on a spreadsheet (over the cells) or on it’s one chart page. Simple equations can be developed like Y = Mx + B. Where the cell you want the answer in (Y) is the cell you choose to create the equation. “x” can refer to another cell and the M and B can either be numbers or refer to other cells. To create a formula (in Cell B3 below), you first highlight that cell, then type in the dialog box above the spreadsheet what you want the formula to look like. In this case is it 3x+4. In this instance, I referred to the cell A3 for the value of X. Note that the equation in the dialog box reads: “=3*A3+4”. Here the cell A3 is highlighted in blue on the spreadsheet and the “A3” shows up in Yellow in the dialog box at the top. The “*” indicates multiplication. The “*” indicates multiplication....
View Full Document
This note was uploaded on 04/07/2009 for the course ENGR 102 taught by Professor Likhatchev during the Spring '07 term at Arizona.
- Spring '07