BIS 155 GENIUS Peer Educator/ bis155genius.com

1
BIS 155 GENIUS Peer Educator/ 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
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 Dropbox located on the silver
tab at the top of this page. L A B O V E R V I E W
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.
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."
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.
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.
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.
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.
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)
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)
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)
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)
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)
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 no
step-by-steps for the course project.
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 Peer Educator/ bis155genius.com

• FOR MORE CLASSES VISIT
• www.bis155genius.com