BIS 155 help Become Exceptional / bis155genius.com

1
BIS 155 help Become Exceptional / bis155genius.com
For More Tutorials
www.bis155genius.com
2
BIS 155 help Become Exceptional / bis155genius.com

• BIS 155 All iLabs Course Project

• BIS 155 Final Exam Guide (Cool Clocks, Inc.)

• BIS 155 Course Project Excel Project
• BIS 155 Lab 1 of 7 Saddle River Marching Band
• BIS 155 iLab 1 Upper Saddle River Marching Band
  (New)
• BIS 155 Lab 2 of 7 Excel's Advanced Formulas
  Functions
• BIS 155 iLab 2 First National Bank (New)
• BIS 155 Lab 3 of 7 Alice Barr Realty Analysis

• BIS155 Practical Final Exam Instructions 1 for
  Cool Clocks, Inc. (v2) 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).

3
BIS 155 help Become Exceptional / bis155genius.com

• BIS 155 Final Exam Guide (Music on Demand)

• BIS 155 iLab 1 Upper Saddle River Marching Band
  (New)

• Complete the tasks below using Microsoft Excel.
  You may refer to your notes, the textbook, or
  other resources such as the Web You may not get
  interactive help from any other person, either in
  person or via email, text messaging, instant
  messaging, or other communications channels.

• Scenario/Summary You are the assistant to the
  band director for the Upper Saddle River Marching
  Band, and you must prepare a report showing the
  status of the marching band fundraising event for
  presentation to the board of trustees

4
BIS 155 help Become Exceptional / bis155genius.com

• BIS 155 iLab 2 First National Bank (New)

• BIS 155 iLab 3 Luke Liberty Realty (New)

• Scenario/Summary You are an intern at First
  National Bank working in the loan department, and
  your boss has asked you to prepare the monthly
  "New Loan Report" for the Board of Directors.
  This analysis report will clearly list and
  summarize all new loans for residential housing
  in the past month

• You are an intern with the Regional Realty
  Association and are analyzing the claim made by
  Luke Liberty Realty that "we get your price." You
  have prepared a spreadsheet that shows data
  relating to 3 months' sales by Luke Liberty
  Realty.

5
BIS 155 help Become Exceptional / bis155genius.com

• BIS 155 iLab 4 Student Education Trust Create
  Address Labels (New)

• BIS 155 iLab 5 Carina's Pizza Analysis (New)

• You work with the Student Education Trust, which
  allows you to demonstrate your expertise with
  Excel. The trust is sponsoring an auction, and
  you have received a list of all donors who have
  contributed to this auction. The list was pulled
  from their database as a comma-separated text file

• The owner of Carina's Pizza, wants to evaluate
  the profitability of the three restaurants before
  expanding further. They are particularly
  interested in the comparative results of three
  dining categories, dine-in, pickup, and delivery.

6
BIS 155 help Become Exceptional / bis155genius.com

• BIS 155 iLab 6 (Week 5) Day Care Center (New)

• BIS 155 iLab 7 (Week 6) Analysis of a business
  Scenario

• Senario/Summary Your friend, Adair Deske, 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 75,000 profit per
  year in order to start the business. She has
  asked you to analyze her Income Statement and
  help her determine whether it is viable for her
  to start this business

• 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

7
BIS 155 help Become Exceptional / bis155genius.com

• BIS 155 iLab 8 (Week 7) Descriptive statistics,
  formatting, graphs, and regression analysis

• BIS 155 Lab 1 of 7 Saddle River Marching Band
  (Devry)

• Scenario/Summary Hopefully you will find this
  week's iLab activity fun and useful. We'll be
  exploring the world of statistics from a business
  perspective this week, allowing you to practice
  your skills with descriptive statistics,
  formatting, graphs, and regression analysis

• http//www.bis155genius.com/BIS-155/product-62-BIS
  -155-iLab-1-Upper-Saddle-River-Marching-Band-(New)
  
• WE HAVE A NEW WEEK 1 LAB (UPDATED JUNE 2016)
  WHICH COULD BE FOUND ON THIS LINK 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

8
BIS 155 help Become Exceptional / bis155genius.com

• BIS 155 Lab 2 of 7 Excel's Advanced Formulas
  Functions (Devry)

• BIS 155 Lab 3 of 7 Alice Barr Realty Analysis
  (Devry)

• WE HAVE A NEW WEEK 2 LAB (UPDATED JUNE 2016)
  WHICH COULD BE FOUND ON THIS LINK
  http//www.bis155genius.com/BIS-155/product-61-BIS
  -155-iLab-2-First-National-Bank-(New) BIS 155
  Lab 2 of 7 Excels Advanced Formulas Functions
  You are an intern at First National Bank working
  in the loan department

• WE HAVE A NEW WEEK 3 LAB (UPDATED JUNE 2016)
  WHICH COULD BE FOUND ON THIS LINK
  http//www.bis155genius.com/BIS-155/product-60-BIS
  -155-iLab-3-Luke-Liberty-Realty-(New) Lab 3 of
  7 Alice Barr Realty Analysis You are an intern
  with the Regional Realty Association and are
  analyzing the claim made by Alice Barr Realty
  that "we get your price."

9
BIS 155 help Become Exceptional / bis155genius.com

• BIS 155 Lab 4 of 7 Create Address Labels (Devry)

• BIS 155 Lab 5 of 7 Bruno's Pizza Analysis
  (Devry)

• WE HAVE A NEW WEEK 4 LAB (UPDATED JUNE 2016)
  WHICH COULD BE FOUND ON THIS LINK
  http//www.bis155genius.com/BIS-155/product-59-BIS
  -155-iLab-4-Student-Education-Trust-Create-Address
  -Labels-(New) Create labels for the letters. The
  XYZ Corporation wishes to use mailing labels to
  address the envelopes. They own 8 1/2 x 11"
  sheets of label paper with 1" by 4" labels, which
  they purchased from Office Depot.

• WE HAVE A NEW WEEK 5 LAB (UPDATED JUNE 2016)
  WHICH COULD BE FOUND ON THIS LINK
  http//www.bis155genius.com/BIS-155/product-58-BIS
  -155-iLab-5-Carina's-Pizza-Analysis-(New) The
  owner of Bruno's Pizza, Joe Bruno, wants to
  evaluate the profitability of his three
  restaurants before he expands further

10
BIS 155 help Become Exceptional / bis155genius.com

• BIS 155 Lab 6 of 7 Day Care Center (Devry)

• BIS 155 Lab 7 of 7 Access Database (Devry)

• WE HAVE A NEW WEEK 5 iLAB 6 (UPDATED JUNE 2016)
  WHICH COULD BE FOUND ON THIS LINK
  http//www.bis155genius.com/BIS-155/product-57-BIS
  -155-iLab-6-(Week-5)-Day-Care-Center-(New) Your
  friend, Jane Morales, is considering opening a
  Day Care Center.

• WE HAVE A NEW WEEK 5 LAB (UPDATED JUNE 2016)
  WHICH COULD BE FOUND ON THIS LINK
  http//www.bis155genius.com/BIS-155/product-55-BIS
  -155-iLab-8-(Week-7)-Descriptive-statistics,-forma
  tting,-graphs,-and-regression-analysis Hopefully
  you will find this week's lab activity fun and
  useful. If you have never created a database

11
BIS 155 help Become Exceptional / bis155genius.com

• BIS 155 Week 1 DQ Getting Familiar With Excel

• BIS 155 Week 1 Quiz (Excel Fundamentals and
  Charting) (Devry)

• 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 todays job market and why. Be
  specific.

• 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? (Points 2)
•     (TCO 1) If you wanted to insert the current
  date into an active cell, which of the following
  would you use? (Points 2)

12
BIS 155 help Become Exceptional / bis155genius.com

• BIS 155 Week 1 Quiz (New)

• BIS 155 Week 1 Quiz (Excel Fundamentals and
  Charting) (Devry)

• 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 todays job market and why. Be
  specific.

• Question 1. Question (TCO 1) An Input Area (as
  it applies to Excel 2013) is defined as_____. a
  range of cells containing results based on the
  output area displays the name of a worksheet
  within a workbook a range of cells containing
  values for variables used in formulas Question

13
BIS 155 help Become Exceptional / bis155genius.com

• BIS 155 Week 1-7 All DQs

• BIS 155 Week 2 DQ Formulas and Functions

• BIS 155 Week 1 DQ Getting Familiar With Excel BIS
  155 Week 2 DQ Formulas and Functions BIS 155 Week
  3 DQ Data Analysis Tools BIS 155 Week 4 DQ Excel
  Data Exchange BIS 155 Week 5 DQ Data
  Consolidation and What-If Analysis BIS 155 Week 6
  DQ Bringing It All Together BIS 155 Week 7 DQ
  Uses and Applications of Statistics

• One of the benefits of Excel is the ability to
  use formulas and functions. 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.

14
BIS 155 help Become Exceptional / bis155genius.com

• BIS 155 Week 2 Quiz (Excel s Advanced Formulas
  Functions) (Devry)

• BIS 155 Week 2 Quiz (New)

• Week 2 Quiz
• (TCO 2) An absolute cell reference (Points 2)
• (TCO 2) Which of the following best describes a
  circular reference? (Points 2)
• (TCO 2) E2-G4 contains examples of _____ cell
  references. (Points 2)
• (TCO 2) In Excel, an Argument would be best
  described by which of the following statements?
  (Points 2)

• Question 1. Question (TCO 2) In Excel, a
  relative cell reference indicates a cell's
  specific location and the reference does not
  change when you copy the formula. contains both
  an absolute and a relative cell reference.
  indicates a cell's relative location from the
  cell containing the formula the reference
  changes when you copy the formula

15
BIS 155 help Become Exceptional / bis155genius.com
For More Tutorials
www.bis155genius.com