Devry

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

COMP 230 All Weeks (1 to 7) Quizzes

COMP 230 All Weeks (1 to 7) Quizzes

Week 1 to Week 7 - All Quizzes COMP 230 Week 1 Quiz -- $ 8.00 COMP 230 Week 2 Quiz -- $ 8.00 COMP 230 Week 3 Quiz -- $ 8.00 COMP 230 Week 4 Quiz -- $ 8.00 COMP 230 Week 5 Quiz -- $ 8.00 COMP 230 Week 6 Quiz -- $ 8.00 COMP 230 Week 7 Quiz -- $ 8.00 Note: this bundle is cheaper than the individual Quiz...

$30.00

COMP 230 All Weeks (3 & 6) Course Projects

COMP 230 All Weeks (3 & 6) Course Projects

Objectives Your company is currently planning to automate many different system administration tasks. Your manager has asked you to research a system administration task and implement it using VBScript. In addition, your manager would like to see both a proposal that describes the system administration task and a complete VBScript solution with sample output runs. COMP 230 all weeks Course Projects are bundled in this product. It contains week 3 and week 6 course projects.  Course Project (..

$25.00

COMP 230 Week 1 Quiz

COMP 230 Week 1 Quiz

Questions: 1-61.  (TCO 1) Which one of the following Windows net commands are NOT used to control services with the net ServiceName?2.  (TCO 1) Which of the following Windows commands will shutdown and restart your computer in 2 minutes?3.  (TCO 1) Which of the following Windows commands will shutdown and restart the computer FileServer in 2 minutes?4.  (TCO 1) Which Windows shutdown-command switch is used to shutdown and turn off a local or remote computer?5.&..

$5.00

COMP 230 Week 2 Quiz

COMP 230 Week 2 Quiz

Questions: 1-81.  (TCO 2) ____ data items may involve displaying numbers or text to the screen.2.  (TCO 2) The process of walking through a program's logic on paper…… ____.3.  (TCO 2) What is the problem with the following statement? 60 + 5 = grade4.  (TCO 2) What is the problem with the following statement? LastName = "smith5.  (TCO 2) What is the assignment operator?6.  (TCO 2) String constants and _____ refer to the same concept.7.  (TCO 2) If a variable hol..

$5.00

COMP 230 Week 3 Course Project

COMP 230 Week 3 Course Project

COMP 230 Week 3 Course Project is relating to Automating Administrative Tasks.In this week a proposal has to be made and submitted regarding any topic. In subsequent weeks, a full-fledged course project is to be made and submitted in week 6. ScholarlyProjects.com offers a proposal relating network automation that means to create a task which is performed automatically; Tasks that a system administrator performs frequently should be automated...

$15.00

COMP 230 Week 3 Quiz

COMP 230 Week 3 Quiz

Questions: 1-81.  (TCO 3) What statement best describes the following pseudocode?2.  (TCO 3) What decision structure is logically equivalent to the following?3.  (TCO 3) What logic operator could be used to replace the nested selection….?4.  (TCO 3) Which logical operator has the lowest precedence?5.  (TCO 3) Every Boolean expression must be true in order for the entire…._____.6.  (TCO 3) Only one of the Boolean expressions must be false in order for…____.7.&nb..

$5.00

COMP 230 Week 4 Quiz

COMP 230 Week 4 Quiz

Question: 1-111.  (TCO 4) A variable that determines if a loop will continue is known as a ____. 2.  (TCO 4) What is the name for the statements that are repeated during loop…..?3.  (TCO 4) Which piece of pseudocode represents incrementing the loop-control…?4.  (TCO 4) When a value is incremented by 1, ____.5.  (TCO 4) When a loop-control variable is not altered during loop…. ______ loop....6.  (TCO 4) Which of the following is NOT automatically handled by the for l..

$5.00

COMP 230 Week 5 Quiz

COMP 230 Week 5 Quiz

Questions: 1-61.  (TCO 5) Although it is not a requirement of any programming language, it frequently makes sense to use a(n) ____ as all or as part of a module's name because modules....2.  (TCO 5) A variable that is used in all program modules is ____.3.  (TCO 5) What statement is not an advantage of using modularization?4.  (TCO 5) Variables declared within a module have what scope?5.  (TCO 5) In what way do named constants differ from variables? 6.  (TC..

$5.00

COMP 230 Week 6 Course Project

COMP 230 Week 6 Course Project

COMP 230 Week 6 Course Project; Complete course project relating to the topic "Utilizing VBScript for the Removal of Spam from Email in Outlook" has been made.Week 6: Complete Course Project (140 points)The following is a list of guidelines for your Course Project, due in Week 6.The complete proposal should include the following:IntroductionDescription of program (script)Source Code with detailed commentsSource Code should contain a minimum 5 out of 6 topics learned during this session.Explain ..

$15.00

COMP 230 Week 6 Quiz

COMP 230 Week 6 Quiz

Questions: 1-61.  (TCO 6) When you create a VBScript Scripting.FileSystemObject, you must start the code line with _____.2.  (TCO 6) Which one of the following is NOT a Windows file attribute?3. (TCO 6) To test to see if a file exists before you overwrite it in VBScript, use the following command (assuming that fso is a Scripting.FileSystemObject).4. (TCO 6) To move the file C:\Data\CustData.txt to C:\BackUp\CustData.txt in VBScript, use the following command (assum..

$5.00

COMP 230 Week 7 Quiz

COMP 230 Week 7 Quiz

Questions: 1-61.  (TCO 7) What is the most common database query language?2.  (TCO 7) What is the name for a column that uniquely identifies a record?3.  (TCO 7) The __ in a table is the column that makes each record different from….4.  (TCO 7) Which of the following is not a database-security issue?5.  (TCO 7) When two tables in a database contain related data, the data in…. _____. 6.  (TCO 7) The general syntax of an SQL select statement is _____...

$5.00

ECON 545 All Weeks 1-7 All Discussion Questions

ECON 545 All Weeks 1-7 All Discussion Questions

Weeks 1 to Weeks 7 Complete Discussions ECON 545 Week 1 | DQ: Economic Thinking And Economic Systems ECON 545 Week 2 | DQ: Shift In Supply And Demand ECON 545 Week 3 | DQ: Market Structure And Profit Maximization ECON 545 Week 4 | DQ: GDP And Economic Growth ECON 545 Week 5 | DQ: Unemployment ECON 545 Week 6 | DQ: Monetary and Fiscal Policies ECON 545 Week 7 | DQ: International Trade and Exchange Rates Note: this bundle is cheaper than the individual DQ...

$30.00

Showing 81 to 120 of 318 (8 Pages)