ES2_08_Lec_13_POST

# ES2_08_Lec_13_POST - ES 2 Computing in Engineering Lecture...

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

ES 2 Computing in Engineering 1 ES 2 Computing in Engineering Lecture 13 Excel Worksheet Equations Solving Simultaneous Equations Recording Macros Minor Editing of Macros

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

View Full Document
ES 2 Computing in Engineering 2 Assist Accepted Engineering Student to Choose Tufts! Assist Accepted Engineering Student to Choose Tufts! Why did you choose Tufts’ engineering? Was it the April Open House or just Dean Knox? The April Open House will entice admitted students to come  to Tufts! We need freshmen engineers to participate in programs on  April 18, 24, and 25! Email:  Eli.Cushner@tufts.edu !!! Or talk to him                                                                                 (he is that magician in the first row)!!!!! Announcements
ES 2 Computing in Engineering 3 Interested in Majoring in Chemical Engineering? Learn about majoring in Chemical Engineering  from Students and Professors  March 10 @ 7 PM Large Conference Room in Campus Center Come to ChBE Department Night! Pizza and refreshments will be served . Announcements

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

View Full Document
ES 2 Computing in Engineering 4 Navigating the Excel Worksheet Filling cells Manually, fill handles, Series, Fill Down, Right… Referencing one or more cells in an equation Type in, click cells, ranges Moving around large spreadsheets Shift key –  from-to range select Ctrl key – add-to selection Ctrl-Shift- Ctrl-home Equation updating when adding and deleting rows and  columns
ES 2 Computing in Engineering 5 Absolute Reference A \$ in front of the row  number keeps it fixed when the  cell is copied or used in a fill down  operation A \$ in front of the column  number keeps it fixed when  the cell is copied or used in a fill right  operation. ExcelDemoStart.xls =ROUND(D13*(1+G\$11),2) When this cell is  copied downward,  the row number 11  for column G will not  be effected but row  13 for column D will  be.

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

View Full Document
ES 2 Computing in Engineering 6 Absolute Cell Reference  None Column Row
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 03/26/2008 for the course ES 2 taught by Professor Minardi during the Spring '08 term at Tufts.

### Page1 / 24

ES2_08_Lec_13_POST - ES 2 Computing in Engineering Lecture...

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

View Full Document
Ask a homework question - tutors are online