# Bis 155 Entire Course All Labs-Quizzes and Final Exam

Decent Essays

BIS 155 Entire Course All Labs-Quizzes And Final Exam

BIS 155 ( All Quizzes Included in File )
BIS 155 Lab 1
BIS 155 Lab 2
BIS 155 Lab 3
BIS 155 Lab 4 ( Word )
BIS 155 Lab 4 (Excel )
BIS 155 Lab 4 Clary labels
BIS 155 Lab 5
BIS 155 Lab 6
BIS 155 Lab 6 Clary Course Project
BIS 155 Lab 6 Clary Project Memo Template
BIS 155 Lab 7 Clary ( BIS 155 Final Exam ) Final Exam 1. (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 …show more content…

Explain how you would use the integration features of MS Office to incorporate the Excel information into other presentation media.

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. Give a step-by-step explanation of how you will rearrange the data so you can analyze the best and worst months

(TCO 5) You’ve just joined the staff of the XYZ Manufacturing Company (XYZ, for short). XYZ manufactures only one product, the gizmo. It comes in two sizes, the mini-gizmo and the magna-gizmo. Both are difficult to manufacture, and consequently, the company closely monitors rejected units. The company has three locations, each of which produces both the mini and the magna-gizmos. You are automating the weekly production reports so that you can easily calculate total production for the entire company each week.
The mini-gizmo is priced at \$3.25 per unit. The magna-gizmo is priced at \$7.00 per unit. The unit cost for a reject mini-gizmo is \$1.75. The cost for a reject magna-gizmo is \$3.50. Respond fully to the following questions regarding this task: 1.) The managers will e-mail their weekly reports to you on Monday of the following week. You will then produce the summary report. Explain the process for doing this. Give a sample