EGR_102_Lab_01B_Excel_I

# EGR_102_Lab_01B_Excel_I - Advanced Microsoft Excel I EGR...

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

Lab 01B 1 Advanced Microsoft Excel ® I EGR 102 Lab 01B 2 Spreadsheets Grid designed to hold values Migrated from paper to electronic spreadsheets in 70’s Developed use of formulas Primary function: Automatic recalculation Errors easily fixed, what-if scenarios EGR 102

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

View Full Document
Lab 01B 3 Spreadsheet Usages When to use spreadsheets: Performing the same calculations repeatedly Working with tabular information, column or row format Producing graphs and other plots Performing parametric analyses Presenting results in a readable form But not when: Symbolic manipulation of equations EGR 102 Lab 01B 4 Spreadsheet Applications Business Applications Time value of money Many options, built-in functions (rates of return, etc) Statistics Applications Data Analysis Regression, Curve Fitting Many options, built-in functions Engineering Applications X-Y charts, plots More limited, not as many built-ins EGR 102
Lab 01B 5 Terminology A worksheet is one page of a spreadsheet document Tabs at the bottom indicate the worksheet name A cell is one block within the worksheet Can insert data or formulas Change color, size and border of each cell Change format of numbers Arranged in vertical columns and horizontal rows Identified by unique column and row heading Columns A – IV, total of 256; Rows 1 – 65536 EGR 102 Lab 01B 6 Terminology A range of cells is referenced from upper left to bottom right cell numbers separated by a colon A formula

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 04/23/2011 for the course EGR 102 taught by Professor Hinds during the Spring '09 term at Michigan State University.

### Page1 / 8

EGR_102_Lab_01B_Excel_I - Advanced Microsoft Excel I EGR...

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

View Full Document
Ask a homework question - tutors are online