DVP2 Cost of University-1.docx - DVP2 UNIVERSITY COSTS This assignment entails comparison of the cost of attending university at several schools You may

DVP2 Cost of University-1.docx - DVP2 UNIVERSITY COSTS This...

This preview shows page 1 - 5 out of 6 pages.

DVP2 UNIVERSITY COSTS This assignment entails comparison of the cost of attending university at several schools. You may use Microsoft Excel (either 2013 on a pc or 2011 on a mac) or Google spreadsheet to complete this assignment. You will also use the internet for research. In order to successfully complete this assignment, in addition to the concepts in DVP1, you also need to know how to do the following tasks in a spreadsheet software: Apply order of mathematics Use absolute cell references Add worksheet and label it Apply conditional formatting Use relative cell references Use cell references from different worksheet
Image of page 1

Subscribe to view the full document.

START BY FIXING BUDGET ASSIGNMENT The DVP1 budgeting assignment must be correct before you complete this assignment. Fix any errors you had in this assignment before proceeding. SAVE FILE Save file using the Save As command. Use file name DVP2 Last Name. Save often as you complete this assignment. LABEL WORKSHEET, ADD A NEW SHEET Open DVP1. Change the name of the worksheet to Budget . Add a new worksheet. Change the name of the worksheet to University Cost ENTER LABELS AND DATA Recreate the following table in the new worksheet: Cost of University Weber State University Item 20 14 - 20 15 20 15 - 20 16 20 16 - 20 17 20 17 - 20 18 To Tuition Fees Housing and Meals Books and Supplies Average for US Public, 4-year institutions 15 Average annual percentage increase 4.
Image of page 2
Image of page 3

Subscribe to view the full document.

ENTER DATA FROM BUDGET WORKSHEET In the 2014-2015 column, we need to enter the values for Weber State University. We already did this in the budget worksheet so we will simply have the spreadsheet transfer those numbers for us.
Image of page 4
Image of page 5
  • Fall '17

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

Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes