business 1504 notes

business 1504 notes - reference when an equation is copied....

Info iconThis preview shows pages 1–24. 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
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
Background image of page 7

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

View Full DocumentRight Arrow Icon
Excel tries to change part of each cell 
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

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

View Full DocumentRight Arrow Icon
Background image of page 12
Background image of page 13

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

View Full DocumentRight Arrow Icon
Background image of page 14
Background image of page 15

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

View Full DocumentRight Arrow Icon
Background image of page 16
Background image of page 17

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

View Full DocumentRight Arrow Icon
Background image of page 18
Background image of page 19

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

View Full DocumentRight Arrow Icon
Background image of page 20
Background image of page 21

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

View Full DocumentRight Arrow Icon
Background image of page 22
Background image of page 23

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

View Full DocumentRight Arrow Icon
Background image of page 24
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: reference when an equation is copied. Vertical copies will increase/decrease row references. Horizontal copies will increase/decrease column references. Copy Formula? Vertical or Horizontal? Change Rows? Change Columns? Yes No Stop Horizontal Vertical Yes Yes Stop No Enter $ before column letters that should not change No Enter $ before row numbers that should not change Start 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 / 24

business 1504 notes - reference when an equation is copied....

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

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