BIS 155 Data Analysis with Spreadsheets with Lab

BIS 155 Data Analysis with Spreadsheets with Lab
This DeVry course focuses on analyzing business situations using current spreadsheet software. Using data derived from real-world business situations, students learn to use appropriate spreadsheet software features to organize, analyze and present data, as well as to make business decisions.

BIS 155 All Weeks (1-7) | All Discussions

BIS 155 All Weeks (1-7) | All Discussions

Week 1 to Week 7 - All Discussions Bundled: BIS 155 Week 1 Discussion | Getting Familiar with Excel   --- $7.00 BIS 155 Week 2 Discussion | Formulas and Functions | Version 1  --- $7.00 BIS 155 Week 2 Discussion | Formulas and Functions | Version 2  --- $7.00 BIS 155 Week 3 Discussion | Data Analysis Tools  --- $7.00 BIS 155 Week 4 Discussion | Data Consolidation  --- $7.00 BIS 155 Week 5 Discussion | Data Consolidation  --- $7...

$45.00

BIS 155 All Weeks (1-7) | All iLab Exercises

BIS 155 All Weeks (1-7) | All iLab Exercises

Week 1 to Week 7 iLab All Exercises Bundled: BIS 155 Week 1 iLab | Summit Ridge Mountain Resort Workbook on Mountain Sports Village Shop Sales to Data BIS 155 Week 2 iLab | Summit Ridge Mountain Resort Workbook on Mountain Sports Village Shop Sales to Data. BIS 155 Week 3 iLab | Summit Ridge Mountain Resort Analyze the claim made by the Condos at Summit Ridge Mountain. BIS 155 Week 4 iLab | Summit Ridge Mountain Resort Warming Hut Income, Seasonal Activities and X Games. BIS 155 Week ..

$65.00

BIS 155 All Weeks (1-7) | All Quizzes

BIS 155 All Weeks (1-7) | All Quizzes

Week 1 to Week 7 - All Quizzes Bundled: BIS 155 Week 1 | Quiz  -- $7.00 BIS 155 Week 2 | Quiz  -- $7.00 BIS 155 Week 3 | Quiz  -- $7.00 BIS 155 Week 4 | Quiz  -- $7.00 BIS 155 Week 5 | Quiz  -- $7.00 BIS 155 Week 6 | Quiz  -- $7.00 BIS 155 Week 7 | Quiz  -- $7.00 Note: This Bundle is cheaper than the individual ones --- $45.00..

$35.00

BIS 155 Week 1 Discussion | Getting Familiar with Excel

BIS 155 Week 1 Discussion | Getting Familiar with Excel

DQ: Getting Familiar With Excel (graded) Excel was introduced in 1985. Since then, it has become a standard business tool.1.  Discuss and explain at least six different (unique) features of Excel that make it a valuable business tool.2.  Discuss what type of Excel skills would be important in today’s job market and why. Be specific. 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...

$5.00

BIS 155 Week 1 iLab | Summit Ridge Mountain Resort

BIS 155 Week 1 iLab | Summit Ridge Mountain Resort

Workbook on Mountain Sports Village Shop Sales to Data Description Scenario/Summary You 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 re..

$10.00

BIS 155 Week 1 | Quiz

BIS 155 Week 1 | Quiz

Quiz 1 1.    Question: (TCO 1) An Output Area (as it applies to Excel 2016) is defined as _____.2.    Question: (TCO 1) In Excel 2016, a cell is best described by which of the following?3.    Question: (TCO 1) Which of the following best describes the AutoComplete function?4.    Question: (TCO 1) In Excel a formula _____.5.    Question: (TCO 1) Which of the following best describes the result of using the fill handle on a cell containing a form..

$5.00

BIS 155 Week 2 Discussion | Formulas and Functions | Version 1

BIS 155 Week 2 Discussion | Formulas and Functions | Version 1

DQ: Formulas and Functions (graded) - Version 1 One of the benefits of Excel is the ability to use formulas and functions.  1. 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 ..

$5.00

BIS 155 Week 2 Discussion | Formulas and Functions | Version 2

BIS 155 Week 2 Discussion | Formulas and Functions | Version 2

DQ: Formulas and Functions (graded) - Version 2 One of the benefits of Excel is the ability to use formulas and functions.  1. 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 ..

$5.00

BIS 155 Week 2 iLab | Summit Ridge Mountain Resort | v1 & v2

BIS 155 Week 2 iLab | Summit Ridge Mountain Resort | v1 & v2

Workbook on Mountain Sports Village Shop Sales to Data Note: There are two versions of this iLab in order to learn one point from two different angles.Description Scenario/SummaryManagement at Summit Ridge Mountain Resort is very pleased with your initial report. This week, management has asked that you add to the prior analysis and incorporate some visual images concerning the Village Shop sales. This new analysis will require the use of new formulas, new functions, and several charts to..

$10.00

BIS 155 Week 2 | Quiz

BIS 155 Week 2 | Quiz

Quiz 2: Excel's Advanced Formulas, Functions, and Charts 1.   Question: (TCO 2) A(n) _____ is tested in an IF function to determine if it is true or false.2.   Question: (TCO 2) Which of the following steps can be used to insert a SUM function?3.   Question: (TCO 2) The _____ function displays the current date in a cell.4.   Question: (TCO 2) The PMT function is best described by which of the following?5.   Question: (TCO 3) A data series is a gr..

$5.00

BIS 155 Week 3 Discussion | Data Analysis Tools

BIS 155 Week 3 Discussion | Data Analysis Tools

DQ: Data Analysis Tools (graded)  1.   Excel provides many different ways in which to analyze data. Discuss the different methods by which you can analyze data in your spreadsheet. That is, try an Internet search for “data analysis with excel,” or use some of the methods you learned in this week’s lesson. (Please don’t use the same methods. Show your research h and creativity skills.) 2.   Assume the role of a regional manager for a retail organization looking ..

$5.00

BIS 155 Week 3 iLab | Summit Ridge Mountain Resort

BIS 155 Week 3 iLab | Summit Ridge Mountain Resort

Analyze the claim made by the Condos at Summit Ridge Mountain. Description Scenario/Summary You are becoming more confident in your new position at Summit Ridge Mountain Resort. You are still meeting new coworkers and slowly but surely being asked to use more of your Excel skills for different departments at the resort. The manager handling sales for all of the condos in the Summit Ridge Mountain Village needs some help with his sales analysis. This report needs to clearly list and summarize ..

$10.00

BIS 155 Week 3 | Quiz

BIS 155 Week 3 | Quiz

Quiz 3: Data Analysis Functions 1.   Question: (TCO 4) How many possibilities exist when thinking about the freeze options?2.   Question: (TCO 4) In Excel, a table is defined as _____.3.   Question: (TCO 4) To create a table from an existing range of data, _____.4.   Question: (TCO 4) Filtering the Cost column (field) to show only records greater than $10,000 is an application of _____.5.   Question: (TCO 4) To apply a red background color to..

$5.00

BIS 155 Week 4 Discussion | Data Consolidation

BIS 155 Week 4 Discussion | Data Consolidation

DQ: Data Consolidation (graded) 1.  Discuss and compare the group summations and consolidation tools used with Excel. You may need to look up (research) the group summations. 2.  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...

$5.00

BIS 155 Week 4 iLab | Summit Ridge Mountain Resort

BIS 155 Week 4 iLab | Summit Ridge Mountain Resort

Warming Hut Income, Seasonal Activities and X Games Description Scenario/Summary Summit Ridge Mountain Resort has three full-service warming huts on its majestic mountains. The Summit View, the Bunny Den, and the Mogul Hill Samurai warming huts are rest stops that provide skiing customers a place to relax, eat, and warm up. At the end of the month, the manager of each warming hut prepares a worksheet that summarizes the monthly income. Please note that during the summer months,..

$10.00

BIS 155 Week 4 | Quiz

BIS 155 Week 4 | Quiz

Quiz 4: Consolidating Data 1.   Question: (TCO 5) Excel's multiple worksheet abilities can do all of the following except2.   Question: (TCO 5) In Excel, which of the following would you perform to group nonadjacent worksheets?3.  Question: (TCO 5) If the active cell is in column A, but not in row 1, when you click the Split command, the worksheet will appear in two ________ panes.4.   Question: (TCO 5) In Excel, which of the following is not a method for r..

$5.00

BIS 155 Week 5 Discussion | Data Consolidation

BIS 155 Week 5 Discussion | Data Consolidation

DQ: Specialized and Statistical Functions (graded) 1.   Discuss and compare the the specialized and statistical functions in Excel. You may need to research your answer.2.   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...

$5.00

BIS 155 Week 5 iLab | Summit Ridge Mountain Resort

BIS 155 Week 5 iLab | Summit Ridge Mountain Resort

Detailed analysis concerning Stay A While Longer Apartments Description Scenario/Summary Summit Ridge Mountain Resorts has decided to expand. Because of the popularity of the resort among the business community and families, Summit Ridge has decided to purchase some apartments for guests and seasonal employees to have an extended stay. Because these will prove to be a long-term investment, Summit Ridge has decided to put all complexes on a remodeling rotation to ensure the apartments each h..

$10.00

BIS 155 Week 5 | Quiz

BIS 155 Week 5 | Quiz

Quiz 5: Excel's Advanced Functions and Statistical Functions 1.  Question: (TCO 9) Which of the following is a nested function?2.  Question: (TCO 9) If there are four possible outcomes, how many logical tests are required?3.  Question: (TCO 9) When using the MATCH function looking for the largest value that is less than or equal to the match lookup_value, the match type must be set to _____.4.  Question: (TCO 9) Which of the following functions will return the interest paym..

$5.00

BIS 155 Week 6 Discussion | What-If Analysis

BIS 155 Week 6 Discussion | What-If Analysis

DQ: What-If Analysis (graded) Life is full of questions and each question deserves a good answer. Let’s explore the What-If Analysis tools available in Excel. Explain how these tools are used to assist with solid decision making. Give examples of how each of the What-If Analysis tools can be used practically. Please include your research references in APA format...

$5.00

BIS 155 Week 6 iLab | Summit Ridge Mountain Resort

BIS 155 Week 6 iLab | Summit Ridge Mountain Resort

SRMR Income Statement Variables and Warming Hut Sales - changes in Condominium Rental Fees, Ski Lift Tickets, and X Game Tickets and Pricing. Description Scenario/Summary This week it seems like everyone needs an answer to a question. The Accounting Manager for Operations has asked you to update some analysis prepared earlier in the year. In an attempt to predict year-end changes in net income, you have been asked to prepare some reports on changes in condominium rental fees, ski lift ticke..

$10.00

BIS 155 Week 6 iLab | Three-Scenario Analysis on Memo Template

BIS 155 Week 6 iLab | Three-Scenario Analysis on Memo Template

Week 6 iLab 7 - Analysis of a Business Scenario and Do 3 Different Types of Analysis on a Memo Template Description Scenario/Summary The purpose of this exercise is to use the Excel skills you have acquired thus far, and apply them to an analysis of a business scenario, of your choice. This will consist of preparing the groundwork in Excel (importing data, preparing the analysis using tables, charts, graphs, pivot tables, etc.) and preparing a memo to your management, explaining your thre..

$10.00

BIS 155 Week 6 | Quiz

BIS 155 Week 6 | Quiz

Quiz 6: What-If Analysis 1.  Question (TCO 6) Which of the following tools is an add-in? 2.  Question (TCO 6) Which of the following is NOT in the What-If Analysis command in the Data Tools group on the Data tab? 3.  Question (TCO 6) In a data table, the _____ number format is used to disguise the formula references in thefirst row as labels. 4.  Question (TCO 6) A series of ______ indicates that which of a column is too narrow to display the complete number 5. ..

$5.00

BIS 155 Week 7 Discussion | Expert Tools

BIS 155 Week 7 Discussion | Expert Tools

Expert Tools (graded)  1. Excel shares very well with other applications. Why does it import data so easily from other external sources? What features make it easy to manipulate this imported data?  2.  Adding a macro to an Excel workbook is almost like clicking the “Easy” button. They can automate very simple tasks. Why are people often intimidated by macros?..

$5.00

BIS 155 Week 7 iLab | Summit Ridge Mountain Resort

BIS 155 Week 7 iLab | Summit Ridge Mountain Resort

Utilizing "expert" features in Excel such as text importing (outstanding condo sales results for Jesse Gonzales), cell protection and macro generation (X Game Calculator). Description Scenario/Summary Your manager could not be happier with the help you’ve provided to all of those departments requesting Excel assistance within the resort. He is now very confident handing over complex tasks to your capable hands. This week he is requesting that you exercise some expert skills. It seems he h..

$10.00

BIS 155 Week 7 | Quiz

BIS 155 Week 7 | Quiz

Quiz 7: Importing and Macros 1.   Question (TCO 8) Which of the following is a file type that cannot be imported into Excel? (Points : 2) 2.   Question (TCO 8) Which of the following file types uses tabs to separate data into columns? (Points : 2) 3.   Question (TCO 8) Where are web query tools and options located? (Points : 2) 4.   Question (TCO 8) Which of the following are settings that control how imported data in cells connect to their source data..

$5.00

BIS 155 Week 8 Final Exam Practical Problems | Three Versions

BIS 155 Week 8 Final Exam Practical Problems | Three Versions

Final Exam Practical Problems - Three Versions (Bundled) BIS 155 Week 8 Final Exam | Car Parts Service (v5)  -- $25.00 Question 1: Formatting and Charts (Excel; TCOs 1, 2, and 3; 30 points) Question 2: Formulas, Applications and Statistical Functions (Excel; TCOs 2, 3, 6, and 10; 30 points) Question 3: Lists, Sorting, Charts, and Conditional Formatting (Excel; TCOs 4 and 6; 40 points) Question 4: Functions and Financials (Excel TCOs 2, 6, and 7; 30 points) Question 5: ..

$45.00

BIS 155 Week 8 Final Exam | Car Parts Service (v5)

BIS 155 Week 8 Final Exam | Car Parts Service (v5)

Practical Problems: Car Parts Service (Exam v5) Complete the tasks below using Microsoft Excel. You may refer to your notes, the textbook, or other resources (for example, you may search the Web for information). You may not get interactive help from any other person (either in person or via e-mail, text messaging, instant messaging, or other communications channels). Save your work frequently using CTL + S. You have 4 hours to complete this exam. Note: Be sure you spell-che..

$20.00

BIS 155 Week 8 Final Exam | Music On Demand (v3)

BIS 155 Week 8 Final Exam | Music On Demand (v3)

Practical Problems: Music On Demand (Exam v3) Question 1: Formatting and charts (TCOs 1, 2, and 3; 30 points) 1.  Adjust the widths of the columns so all data is visible.2.  Center the title “Music on Demand – Sales by Product” across columns A-D.3.  Increase the font size to 16, and change the font color to red.4.  Bold the column headings “Product”, “Unit Price”, “Quantity”, and “Total Sales”.5.  Add formulas to the Total Sales column to calculate the total sales fo..

$20.00

BIS 155 Week 8 Final Exam | Super Shoes Inc (3v2)

BIS 155 Week 8 Final Exam | Super Shoes Inc (3v2)

Practical Problems: Final Exam 3 Instructions V2 - Super Shoes, Inc. (Exam 3v2) Complete the tasks below using Microsoft Excel. You may refer to your notes, the textbook, or other resources (for example, you may search the Web for information). You may not get interactive help from any other person (either in person, via email, text messaging, IM, or other communications channels).Save your work frequently using CTL+s. You have 4 hours to complete this exam.NOTE: Be sure you SP..

$20.00

Showing 1 to 30 of 30 (1 Pages)