03 Excel Review

03 Excel Review - Excel Review CEE3804: Computer...

Info iconThis preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon
CEE 3804 - Rojiani 1 Excel Review CEE3804: Computer Applications for Civil and Environmental Engineers
Background image of page 1

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

View Full DocumentRight Arrow Icon
CEE 3804 - Rojiani 2 1. Topics to be Covered z Understanding basic workbook concepts z Navigating the workbook z Working with menus and toolbars z Getting help z Protecting your files z Working with window panes z Working with names z Organizing your workbook
Background image of page 2
CEE 3804 - Rojiani 3 Excel Key Components: Overview z Menu Bar: z includes menus and toolbars z menus and toolbars can be customized z Formula Bar: z displays cell address and formula of active cell z Status Bar: z displays status of active window and keyboard features
Background image of page 3

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

View Full DocumentRight Arrow Icon
CEE 3804 - Rojiani 4 Excel Key Components: Worksheets z Worksheets and spreadsheets include: Standard worksheets: z grid of columns and rows z intersection of columns and rows form cells Chart worksheets: z worksheets used solely to store charts z Worksheets are bound together in a workbook z Worksheets have names (e.g. Sheet1)
Background image of page 4
CEE 3804 - Rojiani 5 Excel Key Components: Cells z The cell is the basic element of a worksheet z Cells can hold: z values, formulas, or objects. z Cells are identified by a unique reference: z column/row intersection (e.g. A1) intersection of column “A” and row “1” z Cells can reference to: z other workbooks - external references z other applications - remote references
Background image of page 5

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

View Full DocumentRight Arrow Icon
CEE 3804 - Rojiani 6 Excel Key Components Columns, Rows, and Ranges z Column: z is a vertical group of cells a worksheet contains a total of 256 columns (A to IV) z Row: z is a horizontal group of cells a worksheet contains a total of 65,536 rows (1 to 65,536) z Range: z is a rectangular group of cells Example: A1:C3
Background image of page 6
CEE 3804 - Rojiani 7 Excel Key Components: Regions z Region is a range with blank rows and columns surrounding it z Regions are used by Excel to determine the particular range of interest: z e.g. sorting z Region selection: z select a single cell in the region z enter Ctrl+*
Background image of page 7

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

View Full DocumentRight Arrow Icon
CEE 3804 - Rojiani 8 Excel Spreadsheet z Rectangular array of cells, worksheet z Excel can contain multiple worksheets, up to memory limitations. z Each worksheet contains 256 columns: A through IV 65536 rows, numbered (total of 16,777,216 cells)
Background image of page 8
CEE 3804 - Rojiani 9 Cell entries z -Number, double precision, range ~ 10 -308 to 10 308 , 15-16 digits of precision can be formatted in variety of ways z Text if want numbers as text (e.g. social security number, zip code) start with ' z Date and Time stored as serial number to allow calculations (e.g. days between)
Background image of page 9

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

View Full DocumentRight Arrow Icon
CEE 3804 - Rojiani 10 Cell entries z Formula start with =, can use built in functions and reference other cells or ranges z Worksheets can also contain graphs, maps, embedded or linked objects.
Background image of page 10
CEE 3804 - Rojiani 11 Selecting Cells and Ranges z With Mouse Cell: click on desired cell to make active Range: click on initial cell, drag to last desired cell (hold down left mouse button) Non adjacent cells: select 1st cell, hold down Ctrl key, select each remaining cell z With Keys Cell: use arrow keys to move to desired cell Range: use arrow keys to move to desired cell, hold down Shift key, move to last cell
Background image of page 11

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

View Full DocumentRight Arrow Icon
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/14/2008 for the course CEE 3804 taught by Professor Aatrani during the Fall '07 term at Virginia Tech.

Page1 / 68

03 Excel Review - Excel Review CEE3804: Computer...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online