BIS 155 GENIUS A Guide to career/bis155genius.com

1
COM 295 STUDY Inspiring Minds/com295study.com
BIS 155 GENIUS A Guide to career/bis155genius.com

• For more course tutorials visit
• www.com295study.com

• Formore course tutorials visit
• www.bis155genius.com

2
fdfdsfsd
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 (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 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
3
fdfdsfsd
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 name and today's date on the
Documentation sheet b. Select the Q1Q2 sheet,
and adjust the widths of the columns as needed c.
Center the title "Cool Clock, Inc. Sales by Pro
4
fdfdsfsd
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 work
frequently. You have 4 hours to complete this
exam. Note Be sure to spell check on every
worksheet and correct all spelling errors.
Getting started Open Excel (either on your
desktop or in Citrix) If you are using Citrix,
you need to upload the spreadsheet to your
virtual drive before you can open it in Excel
Open the Practical Exam s
5
fdfdsfsd
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
formulas, format for presentation to the board,
and add charts to graphically depict the sales
over time and by product. Deliverables STEP 1
Opening and Saving Download the spreadsheet,
Week1 iLab Capital Fundraising Student.xslx.
6
fdfdsfsd
BIS 155 iLab 2 First National Bank (New) FOR
MORE CLASSES VISIT www.bis155genius.com 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.
The summary area includes the loan statistics as
labeled data in the data file. The format of the
report should be appropriate for the Board of
Directors for the First National Bank. Be sure to
watch the tutorials at the end of the Lesson
page. Deliverables Step 1 Open, Save, and
Document the Workbook A. Download the
Week2_iLab_FirstNatlBank_Students.xlsx Workbook.
Open "
7
fdfdsfsd
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
must open a workbook that lists home sales for 3
months. A. Download the workbook
Week3_iLab_LibertyRealty_Student.xlsx B. Open the
workbook in Excel, and save it according to the
file naming convention above.
8
fdfdsfsd
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.
9
fdfdsfsd
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 doing this
analysis in return for a small stipend and all
the pizza you can eat. You have already prepared
a template and distributed it to each restaurant
manager, who has entered the sales data for last
year. Your next task is to consolidate the data
into a single workbook that shows the total sales
for each quarter and each dining category. The
information should be shown in tabular, as well
as graphical format
10
fdfdsfsd
BIS 155 iLab 6 (Week 5) Day Care Center (New)
FOR MORE CLASSES VISIT www.bis155genius.com Senar
io/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. You have agreed to help
her complete her Income Statement and to perform
What-If analysis to help her look at her
potential profitability. When submitting the
workbook to the Dropbox, provide a comment in the
Dropbox comments area explaining what you learned
f
11
fdfdsfsd
BIS 155 iLab 7 (Week 6) Analysis of a business
Scenario FOR MORE CLASSES VISIT www.bis155genius.
com 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
(i.e., Sales/Units/discounts by
12
fdfdsfsd
BIS 155 iLab 8 (Week 7) Descriptive statistics,
formatting, graphs, and regression analysis FOR
MORE CLASSES VISIT www.bis155genius.com 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. 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"
13
fdfdsfsd
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 for residential housing in the past
month. The summary area includes the loan
statistics as labeled data in the data file. The
format of the report is appropriate for the Board
of Directors for the First National Bank.
14
fdfdsfsd
BIS 155 Lab 3 of 7 Alice Barr Realty Analysis
(Devry) FOR MORE CLASSES VISIT www.bis155genius.c
om 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 months'
sales by Alice Barr 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 (5 points) You must
open a workbook that
15
fdfdsfsd
BIS 155 Lab 4 of 7 Create Address Labels
(Devry) FOR MORE CLASSES VISIT www.bis155genius.c
om 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 printing labels. B. Merge data from your
Excel spreadsheet into the new label document.
Submit your completed workbook and the two Word
documents (merged letters and merged labels) to
the Dropbox. Make sure you post a comment about
what you
16
fdfdsfsd
BIS 155 Lab 5 of 7 Bruno's Pizza Analysis
(Devry) FOR MORE CLASSES VISIT www.bis155genius.c
om 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 in return for a small
stipend and all the pizza you can eat. You have
already prepared a template and distributed it to
each restaurant manager, who has entered the
sales data for last year. Your next task is to
consolidate the data into a single workbook that
17
fdfdsfsd
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 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 to help
her complete her Income Statement and to perform
What-If analysis to help her look at her
potential profitability.
18
fdfdsfsd
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)-Descrip
tive-statistics,-formatting,-graphs,-and-regressio
n-analysis 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 table, a form, a query,
and a report..
19
fdfdsfsd
BIS 155 Week 1 DQ Getting Familiar With Excel
FOR MORE CLASSES VISIT www.bis155genius.com Exce
l 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 Web. For example, try an Internet search
on "top ten Excel 2013 features" and sift through
some of the resources. Be sure to read your
classmates posts, and see how many features you
can find that haven't been listed yet.
20
fdfdsfsd
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 following would
you use? (Points 2)     (TCO 1) In Excel a
Formula is _______. (Points 2)     (TCO 1)
Which of the following describes the Auto Fill in
Excel 2010? (Points 2)     (TCO 1) Ribbon
Commands with arrows indicate_____. (Points 2)
21
fdfdsfsd
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 database perform the
calculations Is the cell that always holds the
current date Is the location of the insertion
point as
22
fdfdsfsd
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
23
fdfdsfsd
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 or create a
formula to solve the scenario. Be specific! You
wish to calculate the commission on sales. The
commission is 6 on all sales that are at least
20 above cost. You wish to calculate the total
pay for an employee who receives regular time for
40 hours, time and a half for 40
24
fdfdsfsd
BIS 155 Week 2 Quiz (Excel s Advanced Formulas
Functions) (Devry) FOR MORE CLASSES
VISIT www.bis155genius.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) (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) (TCO 2) The MEDIAN
function would identify the ____. (Points 2)
25
fdfdsfsd
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.
Question 2. Question (TCO 2) Which of the
following best describes a mixed cell reference?
Occurs when a formula directly or indirectly
26
COM 295 STUDY Inspiring Minds/com295study.com
BIS 155 GENIUS A Guide to career/bis155genius.com

• For more course tutorials visit
• www.com295study.com

• Formore course tutorials visit
• www.bis155genius.com