ASSIGNMENT 1
Excel Lab
IT Investment Cost-Benefit Analysis Using Excel
BUS311, Dr. Chen
This lab will assist you in reviewing basic Excel concepts and specific Excel formula and functions that may be used in ASSIGNMENT 1. (Note: label every variable so that it can be easily understood.)
1) Basic text manipulation
Practice Question: Center the following Page title and make the text color purple
“BUS311 Excel Lab” in size 14.
2) PMT formula
Practice Question: Calculate the monthly payment of a car loan. The sale price is $60,000, down payment is $7,000. You elect a 7 year loan with an annual interest of 4%.
3) Absolute vs. Relative reference & Copy formula
Practice Question: Calculate the total payment over the 7 years from the PMT calculation. From the result, compute the yearly and total interest paid on the loan.
4) IF logic function
Practice Question: Generate an letter grade for the following students using the grade scale used in this class.
Student Score
1 87
2 95
3 92
4 59
5 65
5) Charts and Graphics
Practice Question: Generate a pie charts for the grade distribution in question 4. Generate an appropriate chart for question 6.
6) Breakeven Analysis
Practice question: You are planning to put in an investment of US$100K the first year and US$50K for a shop, which bring in profit every year for US$70K. Which year will you break even?
7) Work between worksheets
Use a cell/variable in one worksheet to refer to a cell/variable in another worksheet.
Note: At the end of the Lab, you will need to submit your Excel_Lab_Lastname_Firstname.xls file to Laulima to get 10 points. Please try these functions (using your previous ICS101 books or Excel help or books) at home first before coming to the Lab. (You can save your practice file and bring it to the Lab for earning participation points.) Have fun!
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- writing assignment for 2nd grade
- aesop substitute assignment aesop online
- 6th grade writing assignment ideas
- 6th grade writing assignment pdf
- 9th grade writing assignment worksheet
- 9th grade writing assignment classroom
- 10th grade writing assignment idea
- biol 101 individual assignment 1
- unit 1 assignment sequences and series
- assignment 1 1 introductory speech outline
- mathematical literacy grade 10 assignment 1 2021 finance
- major assignment 1 mat 144