week3_09_13

week3_09_13 - IST 195 Week 3 Lecture 1 Desktop Publishing...

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

View Full Document Right Arrow Icon
IST 195 – Week 3, Lecture 1 – Desktop Publishing & Spreadsheet Essentials Professor Jeffrey Rubin
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
Want a leg up in the workplace? MASTER EXCEL!
Background image of page 2
How Many of you? Used functions (if then else) within Excel? Wrote a macro to do automate repetitive tasks? Created pivot tables to analyze multidimensional data? Created charts/graphs based on Excel information?
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
Data Storage and Calculation Formula Basics allow you to create instructions using mathematical expressions and commands. + - * / % ^
Background image of page 4
Spreadsheet Quiz 1 Evaluate this spreadsheet formula: =5-10*-5 a. Error: This is not a valid formula. b. The cell contents would be -10 c. The cell contents would be 55 d. The cell contents would be -45 e. None of the above is correct
Background image of page 5

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

View Full Document Right Arrow Icon
% - ^ * / + - = <> < > >= <= Percent and negate Exponent Multiply Add and subtract Equality and inequality tests 1 operand 2 operands 2 operands 2 operands 2 operands Evaluated first Evaluated second Evaluated third
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 18

week3_09_13 - IST 195 Week 3 Lecture 1 Desktop Publishing...

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

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