Lecture 5 - Using Excel

Lecture 5 - Using Excel - S = 51800 and N = 1000 S = 150...

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

View Full Document Right Arrow Icon
1/25/2010 1 TODAY’S TOPIC: Using Excel Engr 160 Using Excel How will learning this help me? You will learn how to perform calculations using Excel which will make solving problems less time consuming You learn how to save and print Excel files which will enable you to include Excel documents in reports, etc. Connecting to your Background Engr 160
Background image of page 1

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

View Full DocumentRight Arrow Icon
1/25/2010 2 The Basics Opening and closing Save and print The “Ribbon” Changing Excel Options How to show equations in your spreadsheet Using the page break view Engr 160 Calculations Cell addresses Absolute $A$1 Relative A1 Relative formulas Absolute formulas Naming cells LN Log10 Sin, cos, tan, asin, acos, atan, exp, alog Engr 160
Background image of page 2
1/25/2010 3 Practice Problems Calculate the surface area and volume of a hollow sphere that has a wall thickness, t, of 3.10 mm and an outer diameter, d o , of 2.60 x 10 2 mm Calculate the natural log of 2.71 Calculate log 10 of 100, 1000, 10 0000 For the equation S = A*N b Find A and b when
Background image of page 3

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

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

Unformatted text preview: S = 51800 and N = 1000 S = 150 000 and N = 10 000 Engr 160 Comparing What Makes Sense to What Does Not These Things Make Sense Topic These Things Do Not Make Sense Topic Engr 160 1/25/2010 4 Teaching your team Team Topic Discussion Graph the following data using Excel Theta, , starts at 0.0 and goes to 360.0 in steps of 5 degrees F( ) = 100*cos( )*sin(2* ) F( ) is frequency in Hz. Label all axes and the graph using professional conventions Compare values and determine the source of any differences Engr 160 Key points Todays Assignment Make an Excel spreadsheet that will calculate your GPA Use radian measures for all trig functions Pi = pi() Pi = 4*atan(1.) Starting with an equal sign means that you will be entering a formula Log10 is base 10 log Ln is base e log Save your file frequently Page break view before printing Engr 160...
View Full Document

Page1 / 4

Lecture 5 - Using Excel - S = 51800 and N = 1000 S = 150...

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