# S2 - Horizontal copies will increase/decrease column...

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

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

View Full Document
Understand how the spreadsheet design  principles of accuracy and efficiency are applied  to the Spreadsheet 2 Project. Know which objective each chart type depicts  best. Become familiar with common charting pitfalls  and how to avoid them. Know what spreadsheet topics to study for  Exam 2.
Parentheses Multiplication and Division Addition and Subtraction

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

View Full Document
Formula – created by you Function – keyword defined by Microsoft Functions are more flexible than formulas.
SUM AVERAGE MIN and MAX COUNT

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

View Full Document
Store numbers in cells Write equations to point to cells containing  numbers
Excel tries to change part of each cell  reference when an equation is copied. Vertical copies will increase/decrease row  references.

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

View Full Document

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.

Unformatted text preview: Horizontal copies will increase/decrease column references. A1 \$A\$1 \$A1 or A\$1 Relative cell reference change when copied. A1 Absolute cell references will not change when copied. \$A\$1 Mixed - the character following \$ does not change when copied. \$A1 or A\$1 Calculations Macros PIE CHART Dept C Dept B Dept D Dept A 10 20 30 40 50 60 70 80 90 100 2008 2009 2010 2011 LINE CHART 20 40 60 80 100 Dept C Dept B Dept D Dept A BAR CHART Include entire scale Include relevant data points Put horizontal axis in chronological order Stack and scale pictograph images Do not separate all pieces of pie chart Arrange pie slices largest to smallest starting at noon...
View Full Document

## This note was uploaded on 07/08/2010 for the course ACIS 1504 taught by Professor Jmlacoste during the Spring '07 term at Virginia Tech.

### Page1 / 11

S2 - Horizontal copies will increase/decrease column...

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

View Full Document
Ask a homework question - tutors are online