Class03

# Class03 - GEEN 1300 Introduction to Engineering Computing...

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

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

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

View Full Document
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

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

View Full Document
4 7 Examples algebraic format
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 11/07/2010 for the course CHEN 1300 at Colorado.

### 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
Ask a homework question - tutors are online