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

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

View Full Document Right Arrow Icon
Background image of page 1

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

View Full DocumentRight Arrow Icon
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.
Background image of page 2
Parentheses Multiplication and Division Addition and 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
Formula – created by you Function – keyword defined by Microsoft Functions are more flexible than formulas.
Background image of page 4
SUM AVERAGE MIN and MAX COUNT
Background image of page 5

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

View Full DocumentRight Arrow Icon
Store numbers in cells Write equations to point to cells containing  numbers
Background image of page 6
Excel tries to change part of each cell  reference when an equation is copied. Vertical copies will increase/decrease row  references.
Background image of page 7

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

View Full DocumentRight Arrow Icon
Background image of page 8
Background image of page 9

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

View Full DocumentRight Arrow Icon
Background image of page 10
Background image of page 11
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

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 Right Arrow Icon
Ask a homework question - tutors are online