BadTechnique - File name File BadTechnique Contents...

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

View Full Document Right Arrow Icon
File name: c577d26acbc76dd9e40a3ec1146e51d3303a27f7.xls 04/25/2016 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.
Image of page 1

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

View Full Document Right Arrow Icon
Projected October Revenue Internet Access Subscriptions 1,750.00 E-mail & Bulletin Board Servi 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)
Image of page 2
Projected Problems: October Revenue 5% is entered into each formula. Internet Acce 1,750.00 If the value changes, each formula E-mail & Bull 225 must be changed manually. Web Page Dis 50 Monthly Revenues $ 2,025.00
Image of page 3

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

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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern