BIS 155 GENIUS innovative education/bis155genius.com

1
BIS 155 GENIUS innovative education/bis155genius.c
om
2
BIS 155 GENIUS innovative education
BIS 155 All iLabs Course Project FOR MORE
CLASSES VISIT www.bis155genius.com 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 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 BIS 155 iLab 3 Luke Liberty
Realty (New) BIS 155 Lab 4 of 7 Create Address
Labels BIS 155 iLab 4 Student Education Trust
Create Address Labels (New) BIS 155 Lab 5 of 7
Bruno's Pizza Analysis BIS 155 iLab 5 Carina's
Pizza Analysis (New) BIS 155
3
BIS 155 GENIUS innovative education
BIS 155 Final Exam Guide (Cool Clocks, Inc.) FOR
MORE CLASSES VISIT www.bis155genius.com 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). You may not
get interactive help from any other person
(either in person or via email, text messaging,
IM, or other communications channels). I strongly
recommend that you save your work frequently. 1.
Formatting and charts (TCOs 1 3 40 points) a.
Enter your
4
BIS 155 GENIUS innovative education
BIS 155 Final Exam Guide (Music on Demand) FOR
MORE CLASSES VISIT www.bis155genius.com 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. I
strongly recommend that you save your 
5
BIS 155 GENIUS innovative education
BIS 155 iLab 1 Upper Saddle River Marching Band
(New) FOR MORE CLASSES VISIT www.bis155genius.com
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. The report
will summarize all sales of all items and include
the total profit-to-date with the amount
remaining to reach the profit goal. You will open
the partially completed workbook, create for
6
BIS 155 GENIUS innovative education
BIS 155 iLab 2 First National Bank (New) FOR
MORE CLASSES VISIT www.bis155genius.com Scenario/S
ummary 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.
The summary area includes th
7
BIS 155 GENIUS innovative education
BIS 155 iLab 3 Luke Liberty Realty (New) FOR
MORE CLASSES VISIT www.bis155genius.com 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. You
are going to determine the percent of asking
price for each home sold and analyze the sales
data to determine the true track record of the
company in selling homes for the asking price.
STEP 1 Open, Save, and Document the Workbook You
8
BIS 155 GENIUS innovative education
BIS 155 iLab 4 Student Education Trust Create
Address Labels (New) FOR MORE CLASSES
VISIT www.bis155genius.com 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. You have been
asked to create a letter that will go out to each
of the contributors that will accept their
donation. Tickets to the event will be enclosed.
The letter requires that you provide the
following pieces of information. Full name and
address First name Donated item Value
9
BIS 155 GENIUS innovative education
BIS 155 iLab 5 Carina's Pizza Analysis (New) FOR
MORE CLASSES VISIT www.bis155genius.com 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.
Carina has asked for your help in 
10
BIS 155 GENIUS innovative education
BIS 155 iLab 6 (Week 5) Day Care Center (New) FOR
MORE CLASSES VISIT www.bis155genius.com Senario/Su
mmary 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. You have agreed
11
BIS 155 GENIUS innovative education
BIS 155 iLab 7 (Week 6) Analysis of a business
Scenario FOR MORE CLASSES VISIT www.bis155genius.c
om 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 three
separate analysis. This is different than prior
iLab assignments, in that there are no specific
instructions as to what type of analysis (
12
BIS 155 GENIUS innovative education
BIS 155 iLab 8 (Week 7) Descriptive statistics,
formatting, graphs, and regression analysis FOR
MORE CLASSES VISIT www.bis155genius.com Scenario/S
ummary 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. As discussed in the
lesson, the value of statistics lies in the
ability to analyze data more effectively for the
purpose of improving decision making. You might
have heard the expression that "statistics never
lie, and only liars use statistics". There is an 
13
BIS 155 GENIUS innovative education
BIS 155 Lab 1 of 7 Saddle River Marching Band
(Devry) FOR MORE CLASSES VISIT www.bis155genius.co
m
14
BIS 155 GENIUS innovative education
BIS 155 Lab 2 of 7 Excel's Advanced Formulas
Functions (Devry) FOR MORE CLASSES
VISIT www.bis155genius.com WE HAVE A NEW WEEK 2
LAB (UPDATED JUNE 2016) WHICH COULD BE FOUND ON
THIS LINK http//www.bis155genius.com/BIS-155/prod
uct-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, 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 fo
15
BIS 155 GENIUS innovative education
BIS 155 Lab 3 of 7 Alice Barr Realty Analysis
(Devry) FOR MORE CLASSES VISIT www.bis155genius.co
m 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." You have prepared a
spreadsheet that shows data relating to 3 
16
BIS 155 GENIUS innovative education
BIS 155 Lab 4 of 7 Create Address Labels
(Devry) FOR MORE CLASSES VISIT www.bis155genius.co
m 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. Download the
Lab 4, Step 3 Instructions. A. Create a new file
for p
17
BIS 155 GENIUS innovative education
BIS 155 Lab 5 of 7 Bruno's Pizza Analysis
(Devry) FOR MORE CLASSES VISIT www.bis155genius.co
m 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. He is
particularly interested in the comparative
results of three dining categories, dine-in,
pickup, and delivery. Joe has asked for your help
in doing this analysis
18
BIS 155 GENIUS innovative education
BIS 155 Lab 6 of 7 Day Care Center (Devry) FOR
MORE CLASSES VISIT www.bis155genius.com 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-Car
e-Center-(New) 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
19
BIS 155 GENIUS innovative education
BIS 155 Lab 7 of 7 Access Database (Devry) FOR
MORE CLASSES VISIT www.bis155genius.com 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)-Descriptiv
e-statistics,-formatting,-graphs,-and-regression-a
nalysis 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 that you are now a
database designer. You will walk through the
steps of creating and populating an Access
database to keep a record of items in your home.
The database will have a 
20
BIS 155 GENIUS innovative education
BIS 155 Week 1 DQ Getting Familiar With Excel FOR
MORE CLASSES VISIT www.bis155genius.com 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. Note In
addition to the Microsoft Excel 2013 overview in
the Course Home, there are many Excel resources,
in addition to your text, on the 
21
BIS 155 GENIUS innovative education
BIS 155 Week 1 Quiz (Excel Fundamentals and
Charting) (Devry) FOR MORE CLASSES
VISIT www.bis155genius.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? (Points 2) (TCO 1) If
you wanted to insert the current date into an
active cell, which of the fo
22
BIS 155 GENIUS innovative education
BIS 155 Week 1 Quiz (New) FOR MORE CLASSES
VISIT www.bis155genius.com 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 2. Question
(TCO 1) In Excel 2013, a cell is best described
by which of the following? Must have formulas
entered into it Cannot be used for labels or
headings Must have text entered into it Question
3. Question (TCO 1) Which of the following best
describes the active cell? Is where all the
functions of the da
23
BIS 155 GENIUS innovative education
BIS 155 Week 1-7 All DQs FOR MORE CLASSES
VISIT www.bis155genius.com 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
24
BIS 155 GENIUS innovative education
BIS 155 Week 2 DQ Formulas and Functions FOR MORE
CLASSES VISIT www.bis155genius.com 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. Review your
classmates posts to make sure that you're not
duplicating formulas/functions already discussed.
Using the following scenarios, discuss how you
would apply the Excel functions o
25
BIS 155 GENIUS innovative education
BIS 155 Week 2 Quiz (Excel s Advanced Formulas
Functions) (Devry) FOR MORE CLASSES
VISIT www.bis155genius.com Week 2 Quiz 1. (TCO
2) An absolute cell reference (Points
2) 2. (TCO 2) Which of the following best
describes a circular reference? (Points
2) 3. (TCO 2) E2-G4 contains examples of _____
cell references. (Points 2)
26
BIS 155 GENIUS innovative education
BIS 155 Week 2 Quiz (New) FOR MORE CLASSES
VISIT www.bis155genius.com 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.
occurs when a formula directly or indirectly
refers to the cell containing the formula. Que
27
BIS 155 GENIUS innovative education