BIS 155 DEVRY Tutorial / bis155dotcom

BIS 155 Entire Course (Devry)For more course tutorials visit
www.bis155.comBIS 155 Week 6 Course Project Excel Project
BIS 155 Lab 1 of 7 Saddle River Marching Band
BIS 155 Lab 2 of 7 Excel’s Advanced Formulas & Functions
BIS 155 Lab 3 of 7 Alice Barr Realty Analysis
BIS 155 Lab 5 of 7 Bruno’s Pizza Analysis
BIS 155 Lab 6 of 7 Day Care Center
BIS 155 Lab 7 of 7 Access Database
BIS 155 Week 1 Quiz (Excel Fundamentals and Charting)
BIS 155 Week 2 Quiz (Excel s Advanced Formulas & Functions)
BIS 155 Week 3 Quiz (Data Analysis Functions)
BIS 155 Week 4 Quiz (Office Integration and Mail Merge)
BIS 155 Week 5 Quiz (Consolidating Data and What-If Analysis)
BIS 155 Week 8 Final Exam
……………………………………………………..BIS 155 Week 8 Final Exam (Devry)For more course tutorials visit
www.bis155.com1 (TCO 1) You work for a local construction firm, “DeVry Engineering Group” and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions:……. (Points : 40)
2 (TCO 3) You currently work for an automotive parts supply store. Your company is growing and is considering expansion. The company currently has three locations (North, South, and Central) in one state. Each parts supply store carries inventory in four categories. You have been presented with the sales figures for the last three years for each location and inventory category by store. Based on this information, you’re tasked with analyzing current sales for each store by category and overall total sales by store and category….. (Points : 40)
3 (TCO 4) You are given a spreadsheet with daily sales numbers ordered by date from January 1st to December 31st. You have been tasked with finding the average sales of each month, then to reorder the months so they are listed in order from highest to lowest average sales….

Leave a Reply

Your email address will not be published. Required fields are marked *