BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 20

•

Profit by Product

•

Percent Sales Graph

•

Profits-by-Day

=========================================

BIS 155 iLab 2: First National Bank (New)
For more course tutorials visit

www.tutorialrank.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 the file in Excel, and save it as the file name as
describe above (i.e., Doe_J_Week2 iLab.xlxsm). [Note: You may get a