DVP2 1700 2018.docx - DVP2 UNIVERSITY COSTS 2018 This assignment entails comparison of the cost of attending a university at several schools Please use

DVP2 1700 2018.docx - DVP2 UNIVERSITY COSTS 2018 This...

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

DVP2 UNIVERSITY COSTS 2018 This assignment entails comparison of the cost of attending a university at several schools. Please use Excel 2016 (365) for this assignment. You will also need to 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 to a workbook 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.

OPEN DVP1 1. Save file using the Save As command. Use file name DVP2 MAC or PC (whichever platform you are using) Last Name . Save often as you complete this assignment. LABEL WORKSHEET, ADD A NEW SHEET 2. Change the name of the worksheet to Budget . 3. Add a new worksheet. 4. Change the name of the new worksheet to University Costs 5.Move the worksheets so that Budget is first, then the Budget Chart, then the University Costs worksheet. 6. Recreate the following table in the new worksheet: Cost of University Weber State University Item 20 16 - 20 17 20 17 - 20 18 20 18 - 20 19 20 19 - 20 20 To Tuition Fees Housing and Meals Books and Supplies Average for US Public, 4-year institutions 15 Average annual percentage increase 2. PC—OFFICE 2016 OR OFFICE 365 MAC--OFFICE2016
Image of page 2
The values in your worksheet will be very different from mine. This is just a sample of what your worksheet will look like when finished. ENTER DATA FROM BUDGET WORKSHEET In the 2016-2017 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. Having looked up the current WSU costs your values should be accurate.
Image of page 3

Subscribe to view the full document.

Image of page 4
  • Fall '17
  • Weber State University, Weber State

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