Chapter.02 CGS2518

Precision of data succeeding in business with

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: king with mul3ple arguments •  “Set precision as displayed” op3on •  •  •  •  Succeeding in Business with Microsoft Office Excel 2010 Level 1 home 8 The ROUND Func/on Succeeding in Business with Microsoft Office Excel 2010 Level 1 home 9 Controlling the Precision of Data Succeeding in Business with Microsoft Office Excel 2010 Level 1 home 10 Using Paste Special to Copy and Paste Data •  Simplest method: Copy buaon and Paste buaon in the Clipboard group on the Home tab Succeeding in Business with Microsoft Office Excel 2010 Level 1 home 11 Using Paste Special Succeeding in Business with Microsoft Office Excel 2010 Level 1 home 12 Using Paste Special Succeeding in Business with Microsoft Office Excel 2010 13 Calcula/ng the Mean, Median, Mode, and Standard Devia/on •  Contain only one type of argument – a list of values –  Constants –  Cell references –  Range of cells along a column –  Range of cells along a row –  Two ­dimensional block of cells Succeeding in Business with Microsoft Office Excel 2010 Level 1 home 14 Sta/s/cal Func/ons Succeeding in Business with Microsoft Office Excel 2010 Level 1 home 15 Sta/s/cal Func/ons Succeeding in Business with Microsoft Office Excel 2010 Level 1 home 16 Managing Large Worksheets by Freezing Panes and SpliNng the Window •  Freezing panes –  Keeps 3tles displayed in top pane; allows boaom pane to be scrolled –  Both 3tles and values further down are displayed simultaneously •  SpliJng the window –  Allows you to scroll each por3on individually, top/ boaom and lef/right, with separate scroll bars Succeeding in Business with Microsoft Office Excel 2010 Level 1 home 17 Freezing Panes Succeeding in Business with Microsoft Office Excel 2010 Level 1 home 18 Comparing Current Values with Historical Values •  Use a Comparison worksheet –  Places current values and historical values on a separate worksheet in the workbook, side by side Succeeding in Business with Microsoft Office Excel 2010 Level 1 home 19 Comparison Worksheet Succeeding in Business with Microsoft Office Excel 2010 Level 1 home 20 Calcula/ng the Difference Between Two Sets of Data Succeeding in Business with Microsoft Office Excel 2010 Level 1 home 21 Calcula/ng the Percent Di...
View Full Document

This note was uploaded on 05/24/2012 for the course CGS 2518 taught by Professor Gower-winter during the Spring '12 term at FSU.

Ask a homework question - tutors are online