BIS 155 Innovation Is Our Tradition / bis155.com

1
BIS 155 Innovation Is Our Tradition / bis155.com
2
BIS 155 Innovation Is Our Tradition

• BIS 155 Entire Course (Devry)
•  
• For more course tutorials visit
• www.bis155.com
•  
• BIS 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

3
BIS 155 Innovation Is Our Tradition

• BIS 155 Lab 1 of 7 Saddle River Marching Band
  (Devry)
• For more course tutorials visit
• www.bis155.com
•  
• Lab 1 of 7 Saddle River Marching Band (50
  Points)
• Submit your assignment to the Dropbox located on
  the silver tab at the top of this page.

4
BIS 155 Innovation Is Our Tradition

• BIS 155 Lab 2 of 7 Excel's Advanced Formulas
  Functions (Devry)
•  
• For more course tutorials visit
• www.bis155.com
• BIS 155 Lab 2 of 7 Excels Advanced Formulas
  Functions
• You are an intern at First National Bank working
  in the loan department, and your boss has asked
  you to prepare the monthly

5
BIS 155 Innovation Is Our Tradition

• BIS 155 Lab 3 of 7 Alice Barr Realty Analysis
  (Devry)
• For more course tutorials visit
• www.bis155.com
• Lab 3 of 7 Alice Barr Realty Analysis
• You are an intern with the Regional Realty
  Association and areanalyzing the claim made by
  Alice Barr Realty that "we get your price."

6
BIS 155 Innovation Is Our Tradition

• BIS 155 Lab 4 of 7 Create Address Labels (Devry)
•  
• For more course tutorials visit
• www.bis155.com
• Create labels for the letters. The XYZ
  Corporation wishes to usemailing labels to
  address the envelopes. They own 8 1/2 x 11"
  sheets of labelpaper with 1" by 4" labels, which
  they purchased from OfficeDepot.

7
BIS 155 Innovation Is Our Tradition

• BIS 155 Lab 5 of 7 Bruno's Pizza Analysis
  (Devry)
• For more course tutorials visit
• www.bis155.com
• The owner of Bruno's Pizza, Joe Bruno, wants to
  evaluate the profitability of his three
  restaurants before he expands further. He is
  particularly interested in the comparative results

8
BIS 155 Innovation Is Our Tradition

• BIS 155 Lab 6 of 7 Day Care Center (Devry)
•  
• For more course tutorials visit
• www.bis155.com
• Your friend, Jane Morales, is considering opening
  a Day Care Center. She has started compiling her
  assumptions and putting together an Income
  Statement. She has determined that she must make
  at least

9
BIS 155 Innovation Is Our Tradition

• BIS 155 Lab 7 of 7 Access Database (Devry)
•  
• For more course tutorials visit
• www.bis155.com
•  
• Hopefully you will find this week's lab activity
  fun and useful. If you have never created a
  database, you will be able to tell all of your
  friends and family

10
BIS 155 Innovation Is Our Tradition

• BIS 155 Week 1 Quiz (Excel Fundamentals and
  Charting) (Devry)
•  
• For more course tutorials visit
• www.bis155.com
•  
• Week 1 Quiz
• (TCO 1) Which of the following describes the
  function of the Formula Bar (as it applies to
  Excel 2010)? (Points 2)
• (TCO 1) Which of the following best describes
  a cell address?

11
BIS 155 Innovation Is Our Tradition

• BIS 155 Week 2 Quiz (Excel s Advanced Formulas
  Functions) (Devry)
•  
• For more course tutorials visit
• www.bis155.com
•  
• Week 2 Quiz
• (TCO 2) An absolute cell reference (Points 2)
• (TCO 2) Which of the following best describes a
  circular reference? (Points 2)

12
BIS 155 Innovation Is Our Tradition

• BIS 155 Week 3 Quiz (Data Analysis Functions)
  (Devry)
•  
• For more course tutorials visit
• www.bis155.com
•  
• Week 3 Quiz
• (TCO 4) If there are certain columns of
  information that are not needed at a particular
  time but might be needed later,

13
BIS 155 Innovation Is Our Tradition

• BIS 155 Week 4 Quiz (Office Integration and Mail
  Merge) (Devry)
•  
• For more course tutorials visit
• www.bis155.com
•  
• Week 4 Quiz
• (TCO 8) Which of the following is one of the most
  common file types imported into Excel? (Points
  2)
• (TCO 8) Which of the following is NOT a text
  file? (Points 2)

14
BIS 155 Innovation Is Our Tradition

• BIS 155 Week 5 Quiz (Consolidating Data and
  What-If Analysis) (Devry)
•  
• For more course tutorials visit
• www.bis155.com
•  
• Week 5 Quiz
• (TCO 5) When multiple worksheets are selected,
  the word ________ appears in the title bar.
  (Points 2)
• (TCO 5) In Excel, which of the following would
  you perform to group adjacent worksheets? (Points
  2)

15
BIS 155 Innovation Is Our Tradition

• BIS 155 Week 6 Course Project Excel Project
  (Devry)
•  
• For more course tutorials visit
• www.bis155.com
• Objective
• The general instructions for this project can be
  found in the Week 6 Lecture material. The Week 6
  Lecture describes the assignment and provides an
  overview of the project as a whole.

16
BIS 155 Innovation Is Our Tradition

• BIS 155 Week 8 Final Exam (Devry)
•  
• For more course tutorials visit
• www.bis155.com
•  
• (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

17
BIS 155
Innovation Is Our Tradition