BIS 155 GENIUS Inspiring Minds/bis155genius.com

1
BIS 155 GENIUS Academic Coach/bis155genius.com

• FOR MORE CLASSES VISIT
• www.bis155genius.com

2
BIS 155 Entire Course (Devry) FOR MORE CLASSES
VISIT www.bis155genius.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 BIS 155
Lab 4 of 7 Create Address Labels BIS 155 Lab 5
of 7 Bruno's Pizza Analysis BIS 155 Lab 6 of 7
Day Care Center BIS 155 Lab 7 of 7 Access
Database
3
BIS 155 Lab 1 of 7 Saddle River Marching Band
(Devry) FOR MORE CLASSES VISIT
www.bis155genius.com     Lab 1 of 7 Saddle
River Marching Band (50 Points) Submit your
assignment to the Drop box located on the silver
tab at the top of this page. L A B O V E R V I E
W 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
4
BIS 155 Lab 2 of 7 Excel's Advanced Formulas
Functions (Devry) FOR MORE CLASSES VISIT
www.bis155genius.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 "New Loan Report" for the
Board of Directors. This analysis report will
clearly list and sum
5
BIS 155 Lab 3 of 7 Alice Barr Realty Analysis
(Devry) FOR MORE CLASSES VISIT
www.bis155genius.com     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
6
BIS 155 Lab 4 of 7 Create Address Labels
(Devry) FOR MORE CLASSES VISIT
www.bis155genius.com     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.
7
BIS 155 Lab 5 of 7 Bruno's Pizza Analysis
(Devry) FOR MORE CLASSES VISIT
www.bis155genius.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 of three dining
categories, dine-in, pickup, and delivery. Joe
has asked for your help in doing this analysis in
8
BIS 155 Lab 6 of 7 Day Care Center (Devry) FOR
MORE CLASSES VISIT www.bis155genius.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 75,000 profit per year in order to
start the business. She has asked you to analyze
9
BIS 155 Lab 7 of 7 Access Database (Devry) FOR
MORE CLASSES VISIT www.bis155genius.com     Hopef
ully 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
10
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)
11
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)
12
BIS 155 Week 3 Quiz (Data Analysis Functions)
(Devry) FOR MORE CLASSES VISIT
www.bis155genius.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,_ the unneeded columns to allow
users to focus on only the essential information.
(Points2) (TCO 4) In Excel, the print area is
defined as _____. (Points 2) (TCO 4) When
sorting in Excel, it arranges records in a table
_____. (Points 2) (TCO 4) Filtering the Cost
column (field) to show only records greater than
10,000 is......__.
13
BIS 155 Week 4 Quiz (Office Integration and Mail
Merge) (Devry) FOR MORE CLASSES VISIT
www.bis155genius.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) (TCO 8) Which of the following is
NOT a method for refreshing data? (Points
2) (TCO 8) The Convert Text to Columns Wizard
allows you to choose the file type, such as
Delimited____(Points2) (TCO 8) Which of the
following is a frequently used function to
manipulate txt? (Points 2)
14
BIS 155 Week 5 Quiz (Consolidating Data and
What-If Analysis) (Devry) FOR MORE CLASSES
VISIT www.bis155genius.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) (TCO 5) When two windows of the same
workbook are opened, Excel adds ________ to
the....
15
BIS 155 Week 6 Course Project Excel Project
(Devry) FOR MORE CLASSES VISIT
www.bis155genius.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. There are
16
BIS 155 Week 8 Final Exam (Devry) FOR MORE
CLASSES VISIT www.bis155genius.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 to develop a
spreadsheet to calculate weekly payroll for 15
employees with the following assumptions.......
(Points 40)
17
BIS 155 GENIUS Academic Coach/bis155genius.com

• FOR MORE CLASSES VISIT
• www.bis155genius.com