BadTechnique

BadTechnique - File name File BadTechnique Contents...

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

View Full Document Right Arrow Icon
File name: c577d26acbc76dd9e40a3ec1146e51d3303a27f7.xls 12/20/2011 For Computer Skills (and on Excel Review website) File: BadTechnique.xls Contents: Introduction 4th Quarter - Bad Version Formulas Displayed Good Version A simple worksheet displayed three ways to illustrate the dangers of using actual values in Excel formulas and how to correct that critical design flaw.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Projected October Revenue Internet Access Subscriptions 1,750.00  225 Web Page Disk Space Rental 50 Monthly Revenues  $2,025.00  Expenses Salaries 5,210.40  Rent 156 Equipment Maintenance 302.64 Advertising 185.12 Operating Costs 416 Monthly Expenses  $6,270.16  Profit  $(4,245.16)
Background image of page 2
Projected Problems: October Revenue 5% is entered into each formula. Internet Access 1,750.00  If the value changes, each formula 225 must be changed manually. Web Page Disk 50 Monthly Revenues  $2,025.00 
Background image of page 3

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

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

This note was uploaded on 12/20/2011 for the course BUS 101 taught by Professor Ecklund during the Spring '01 term at Duke.

Page1 / 5

BadTechnique - File name File BadTechnique Contents...

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

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