week 1 Ilab for evagat

ou are new to the staff of Summit Ridge Mountain Resort. One of the benefits to your employment is a free mountain ski pass. You are anxious to complete your work and enjoy a run down the mountain but know management is looking to you for important details and analysis for the ski resort overall. This week, management has asked that you begin to prepare a report for the Village Shop sales. The report will summarize all sales of all items and include the total profit-to-date with the amount remaining to reach the profit goal. You will open the partially completed workbook, create formulas, and format your work professionally. 

After completing the steps below, turn in one Excel 2016 workbook. Rename the workbook with your lastname_first initial_Week1_Lab. xlsx. Example: If your name were Jane Doe, your workbook would be Doe_J_Week1_Lab.xlsx.

Haven’t Found The Relevant Content? Hire a Subject Expert to Help You With
week 1 Ilab for evagat
Post Your Own Question And Get A Custom Answer
Hire Writer

When submitting the workbook, provide a comment in the Dropbox comments area explaining what you learned from completing this lab activity. Make certain you compare your finished work with the Grading Rubric included here. 

You will be using Microsoft Excel 2016 for this lab.

Be sure you have read the required chapter materials and reviewed the hands-on exercise videos located on the Lesson page before you begin the lab.

Please do not rely solely on the hands-on exercise videos to complete this week’s lab. The videos provide detailed examples walking you through the hands-on exercises. Applying the hands-on exercise examples will provide both practice and instruction of what to complete. 

For example, your final assignment file should include two worksheets (Documentation and Sales-Data).

Begin: Opening and Saving

Download the spreadsheet Week 1 Lab – Summit Ridge Mountain Resort Student.xslx. You will be prompted to save the file. Click yes. 

Open the saved file from your Download folder on your computer. 

Note: If you are using the Remote Lab environment, you will need to follow the instructions for uploading the file. These instructions can be found on the Lab page when you click on the Lab icon on Course Resources.

To save the spreadsheet with a new file name

open the workbook in Excel 2016; and in Excel, click File then Save as and rename it as lastname_first initial_Week1_Lab.xlsx (Jane Doe would save the file as Doe_J_Week1_Lab.xlsx).

Step 1: Adding a Documentation Sheet

  1. Insert a new spreadsheet into the workbook.
  2. Change the tab name from sheet 2 to Documentation. The documentation sheet should be moved to the first sheet in the workbook. 
  3. Include your name, the date, and the purpose of the spreadsheet.
  4. Make sure you include block color formatting and text wrapping as needed. Your documentation sheet should look something like the one below.

Step 2: Adding Calculations (Formulas)

Now we need to begin working on the worksheet with all of the data.  

  1. Create the formulas needed to calculate the following for each item.

    Column N: Total Quantity Sold = Sum of all Daily Sales 

    Column O: Net Selling Price = Selling Price * (1 – Sales Discount) 

    Column P: Total Sales = Total Quantity Sold * Net Selling Price 

    Column Q: Total Profit = Total Sales – (Cost per item * Total Quantity Sold) 

    Column R:  Average Profit % = Total Profit / Total Sales

  2. Create a Grand Total for the Total Profit column and place it in cell B21.
  3. Create a formula to calculate the Remaining Profit needed and place it in cell B22.

    Remaining Profit = The Profit Goal – Total Profit (all items)

One of the strengths of Excel is its ability to make tedious and repetitious calculations for speed and to reduce errors. Like all tools, there is always the possibility that you could use it incorrectly, so with formulas, it is important to verify the formulas you enter are correct. Notice that the daily sales columns between columns C and N are hidden in the picture below.  https://devry.equella.ecollege.com/file/bdd8662e-d094-47ef-b3c5-8db5b04d10fb/139/image_–_wk1_-_formulas.png

Step 3: Formatting

Apply formatting to your spreadsheet.

Your goal is to take into consideration readability, reliability, and reusability. Remember that presentation has an impact on the viewer, and professional appearance is important for reporting data, just as personal appearance impacts perception. The goal is to make the data more readable and possibly to highlight data that might otherwise be lost in many numbers.

The minimum formatting requirements (per the Grading Rubric) are the following. 

  1. Title Rows formatted as titles, centered across all columns A–R
  2. Apply text wrapping to the column headers.
  3. Make professional font size and color changes.
  4. Make use of shading and borders.
  5. Format for currency, percentage, and numeric formatting.

Step 4: Professional Appearance (Cleanup)

Cleanup the formatting of your report, taking into account professional appearance.

The Minimum Requirement (per the Grading Rubric)

  1. Apply a color and assign a descriptive name to each tab (sheet) in the workbook.
  2. Hide the Daily Sales columns (D–M).
  3. Create a custom page header with your professor’s name and your name.
  4. Set the page orientation to landscape.

Remember, professional appearance doesn’t only promote better readability of your report, it represents you as a professional.

https://devry.equella.ecollege.com/file/bdd8662e-d094-47ef-b3c5-8db5b04d10fb/139/image_–_wk1_-_finished_lab.PNG

Save your Excel file. Saving your file often is good practice (Ctrl + s).

Your Excel file should contain two worksheets.

  • Documentation
  • Sales-Data

Remember to provide a comment in the Dropbox comments area explaining what you learned from completing this lab activity. Submit your completed Excel file to the Dropbox (see the Deliverables above).

Keep this finished work, because you will be using it to begin the lab for Week 2. 

Calculate the price of your order

Select your paper details and see how much our professional writing services will cost.

We`ll send you the first draft for approval by at
Price: $36
  • Freebies
  • Format
  • Formatting (MLA, APA, Chicago, custom, etc.)
  • Title page & bibliography
  • 24/7 customer support
  • Amendments to your paper when they are needed
  • Chat with your writer
  • 275 word/double-spaced page
  • 12 point Arial/Times New Roman
  • Double, single, and custom spacing
  • We care about originality

    Our custom human-written papers from top essay writers are always free from plagiarism.

  • We protect your privacy

    Your data and payment info stay secured every time you get our help from an essay writer.

  • You control your money

    Your money is safe with us. If your plans change, you can get it sent back to your card.

How it works

  1. 1
    You give us the details
    Complete a brief order form to tell us what kind of paper you need.
  2. 2
    We find you a top writer
    One of the best experts in your discipline starts working on your essay.
  3. 3
    You get the paper done
    Enjoy writing that meets your demands and high academic standards!

Samples from our advanced writers

Check out some essay pieces from our best essay writers before your place an order. They will help you better understand what our service can do for you.

Get your own paper from top experts

Order now

Perks of our essay writing service

We offer more than just hand-crafted papers customized for you. Here are more of our greatest perks.

  • Swift delivery
    Our writing service can deliver your short and urgent papers in just 4 hours!
  • Professional touch
    We find you a pro writer who knows all the ins and outs of your subject.
  • Easy order placing/tracking
    Create a new order and check on its progress at any time in your dashboard.
  • Help with any kind of paper
    Need a PhD thesis, research project, or a two-page essay? For you, we can do it all.
  • Experts in 80+ subjects
    Our pro writers can help you with anything, from nursing to business studies.
  • Calculations and code
    We also do math, write code, and solve problems in 30+ STEM disciplines.

Frequently asked questions

Get instant answers to the questions that students ask most often.

See full FAQ
  • What if I’m dissatisfied with the paper I get?

    The average quality score at our professional custom essay writing service is 8.5 out of 10. The high satisfaction rate is set by our Quality Control Department, which checks all papers before submission. The final check includes:
    • Compliance with initial order details.
    • Plagiarism.
    • Proper referencing.
    If for some reason we happen to leave a mistake unnoticed, you are invited to request unlimited revisions of your custom-written paper. For more information, check our Revision Policy. We will do our best to make your experience with Familiar Essays enjoyable.
  • I need an essay on the same day. Is it something you can do?

    Sure. Our writing company offers a fast service with an 8-hour deadline for orders up to master’s level. Make sure to specify the deadline in the order form and our writers will write a paper within the indicated timeslot. Just proceed to submit your requirements here Once you order a custom-written essay, our managers will assign your order to the well-suited writer, who has the best skills and experience for preparing your specific assignment. You can also request one of these extra features:
    • Choose the Writer’s Samples option – study 3 randomly-provided pages from orders that have been written by the assigned writer.
    • Request a specific writer – choose an academic writer from the dropdown list in the order’s form (optional for returning customers).
    You can be sure that your custom writing order will be accomplished by one of our 400+ professional academic writers. They all pass a series of tests to prove their writing prowess and hold the reputation of being the most professional in the industry. Want to make sure writer’s skills match your needs? Get more details on how to choose the appropriate author.
  • How can I be sure your writing service is not a scam?

    We understand that a shade of mistrust has covered the paper writing industry, and we want to convince you of our loyalty. Apart from high-quality writing services, we offer:
    • The chances of students to boost writing skills in a quick and effective way.
    • The opportunity to manage studies and free time in an enjoyable manner.
    • The possibilities to improve overall academic performance.
    Our custom writing company has been working for more than 12 years and always puts quality and clients’ needs first. Our operations are legally documented, we are easily accessible online and offline,
  • Is it legal to use your professional writing service?

    Yes. Custom writing help is not prohibited by any university or college. It’s a 100% legal way of getting professional assistance with paper writing. Hiring writers from an essay writing company is in many ways similar to consulting a tutor – we help you solve the writing issues at hand.
  • How does your service work?

    Our custom writing service is a reliable solution on your academic journey that will always help you if your deadline is too tight. You fill in the order form with your basic requirements for a paper: your academic level, paper type and format, the number of pages and sources, discipline, and deadline. Then, you describe the specific details of the paper you need: add the topic, write or paste the instructions, and attach files to be used, if you have them. After that, an online customer support representative chooses the best writer that specializes in your discipline and assigns him or her to complete the paper according to your requirements. When the paper is ready, we check it for plagiarism and send it to you. If you want to change something, you can request a free revision.
See full FAQ

Take your studies to the next level with our experienced specialists

Live ChatWhatsApp