Lecture-03.2

# Lecture-03.2 - Lab 1(Chapter 1 Introduction to Excel...

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

Lab 1 (Chapter 1): Introduction to Excel Demonstration Model 1 Important ideas: comments worksheet: just ext(explains what the speread sheet actually does) Summing worksheet three different types of formulas (in H6, H12, H18) changing values on a spreadsheet – everything instantly updated insert row/column – rest of spreadsheet adjusted generality of formulas – one produces wrong answer after new column inserted. (why?) functions Demonstration Model 2 Important ideas: copying formulas: (File → Down) Named Ranges in X*Y column - shape of X, Y and XY is the same - =X*Y formula does row-by-row element pair multiplication new functions: MIN, MAX, AVERAGE, MEDIAN Demonstration Model 3 Important ideas: multiple worksheets: factor out parameters to a separate sheet translating mathematical formulas into Excel formulas - what parts are cell references - what parts are constants - what parts are built-in functions - inter-worksheet cell references graphs CSE 1520 – Lecture 3.2 January 18, 2011 page 1

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.

{[ snackBarMessage ]}

### Page1 / 3

Lecture-03.2 - Lab 1(Chapter 1 Introduction to Excel...

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

View Full Document
Ask a homework question - tutors are online