Get help DeVry-University BIS 155 Homework Help. Please read the course announcements and the Syllabus in particular. Pay particular attention to grading, attendance, discussion requirements, and the last portion of the Plagiarism section (Using APA) of the Syllabus. Have you taken COMP100? It is a prerequisite to this course. Do you have Microsoft Excel 2016 software? If not, have you accessed the Virtual Lab – Citrix to use Excel 2016? Discuss the Syllabus – what was one thing that stood out and why? Provide two examples of APA citations – one to cite a web reference, and one to cite a book or journal. NOTE: a URL is not an APA citation. 107 107 unread replies. Excel was introduced in 1985. Since then, it has become a standard business tool. Discuss and explain at least six different (unique) features of Excel that make it a valuable business tool. Discuss what type of Excel skills would be important in today’s job market and why.
Note: In addition to the Microsoft Excel 2016 overview in the Course Home section, there are many Excel resources in addition to your text on the Web. For example, try an Internet search on “top ten Excel 2016 features” and sift through some of the resources. Be sure to read your classmates’ posts, and see how many features you can find that haven’t been listed yet. Complete Lab 1: Summit Ridge Mountain Resort: Village Shops. Be sure to review the tutorials at the end of this week’s lesson, in combination with the content of your assigned readings. These will provide you with the necessary tools to customize the Week 1 Summit Ridge Mountain Resort Student file located in the Lab Overview page. Submit your lab Excel file. One of the benefits of Excel is the ability to use formulas and functions. Discuss the differences between formulas and functions. Pick a function in Excel and discuss how that function is used to calculate results in your worksheets.
Review your classmates’ posts to make sure that you’re not duplicating formulas or functions already discussed. Using the following scenarios, discuss how you would apply the Excel functions or create a formula to solve the scenario. You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost. You have a list of contracts and due dates for annual maintenance fees. You wish to determine when you have a contract due in the next 45 days and provide a note that warns you that the payment is due. Please feel free to add other, unique mathematical challenge questions to the discussion, and let us work together to figure out how you might calculate it. Complete Lab 2: Summit Ridge Mountain Resort: Shop Analysis. Basic instructions are located in the Lab Overview page. Be sure to watch the hands-on exercise tutorials at the end of the lesson for guidance on completing this assignment. Download the Week 3 Discussion instructions (Links to an external site.)Links to an external site.
Week 3 DQ.xlsx spreadsheet (Links to an external site.)Links to an external site. Use BigBlueButton to collaborate with your team and complete the calculations of the case study by Wednesday. Completed assignment should be attached to the first post of team members. Complete Lab 3: Summit Ridge Mountain Resort: Luxury Condo Sales. Basic instructions are in the Lab Overview page. You will be required to use your skills from the text and tutorials to complete the lab. Be sure to watch and work through the hands-on exercise videos in the lesson for guidance on completing this assignment. Discuss and compare the group summations and consolidation tools used with Excel. You may need to look up (research) the group summations. Under what circumstances would you use each of these features? Do they both serve the same purpose, or is each one used under different scenarios? Give examples of how each can be used. Please include your research references in APA format. Complete Lab 4: Summit Ridge Mountain Resort: Warming Hut Monthly Income Consolidation. A complete set of instructions can be found in the Lab Overview page. Discuss and compare the the specialized and statistical functions in Excel. You may need to research your answer. Under what circumstances would you use logical and lookup functions? What financial and statistical functions exist for use? Give examples of how each can be used. Please include your research references in APA format. Complete Lab 5: Summit Ridge Mountain Resort: Advanced Analysis. A complete set of instructions can be found in the Lab Overview page.