Class03 - GEEN 1300 Introduction to Engineering Computing...

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

View Full Document Right Arrow Icon
1 1 GEEN 1300 Introduction to Engineering Computing Spreadsheet Problem Solving ± review of cell addressing modes ± syntax for Excel formulas ± one-way case studies: ± using formula copy ± using the TABLE function Class meeting #3 Monday, Aug 30 th Homework #1 due Wednesday at the beginning of class 2 Which of the following products was the original spreadsheet program? A. Quattro Pro B. Lotus 1-2-3 C. Excel D. VisiCalc E. Wingz
Background image of page 1

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

View Full Document Right Arrow Icon
2 3 Cell Addressing Modes Relative Address Absolute Address 4 Mixed Addresses
Background image of page 2
3 5 What result is displayed in cell C3 when the formula in B2 is copied to C3? A) 2 B) 5 C) 1 D) 4 E) 0 6 Syntax for Excel formulas formulas must start with =, + or - ( ± leftover from 1-2-3) expressions are evaluated left-to-right parentheses are used to establish order for calculations precedence for arithmetic operators is: negation unary – exponentiation ^ multiplication & division * and / addition & subtraction + and - functions are evaluated first and the result is inserted at the position of the function in the expression
Background image of page 3

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

View Full Document Right Arrow Icon
4 7 Examples algebraic format
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 13

Class03 - GEEN 1300 Introduction to Engineering Computing...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online