LAB 1 - Excel General Spreadsheet Use (Ch. 1, pp. 1 - 5)...

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

View Full Document Right Arrow Icon
Excel General Spreadsheet Use (Ch. 1, pp. 1 - 5) Formulas (Ch. 1, pp. 6 – 7, 15 – 22; Ch. 2, pp. 57 - 64) Excel Functions (Ch. 2, pp. 82 – 84) Cell Referencing (Ch. 1, pp. 8 – 22) Graphing (Ch. 1, pp. 23 – 32)
Background image of page 1

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

View Full DocumentRight Arrow Icon
r Always use R1C1 Nomenclature r To Switch to R1C1- File > Options > Formulas > R1C1 Reference Style (Check Mark) r Most important cell formatting functions available on Right Click Right Click is your best Friend General Spreadsheet Use
Background image of page 2
r Formulas always begin with an ‘=‘ sign r Text do not need to start with an ‘=‘ sign r Order of Operation: Excel Formulas () (parenthesis) ^ (power) * (multiplication), / (division) + (addition), - (subtraction)
Background image of page 3

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

View Full DocumentRight Arrow Icon
r Insert function tab r Trigonometric, Logarithmic, Logical, Statistical, etc. r Always use angles in radians when using trigonometric functions r Function Syntax: = Function_Name(Parameters) r Always begin with ‘=‘ sign r Always use parenthesis Excel Functions
Background image of page 4
r Relative Referencing - Address specified
Background image of page 5

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

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/12/2011 for the course ENGR 1412 taught by Professor Staff during the Spring '08 term at Oklahoma State.

Page1 / 10

LAB 1 - Excel General Spreadsheet Use (Ch. 1, pp. 1 - 5)...

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

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