EGR_102_Lab_01B_Excel_I

EGR_102_Lab_01B_Excel_I - Advanced Microsoft Excel I EGR...

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
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
Background image of page 3

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

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

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 Right Arrow Icon
Ask a homework question - tutors are online