Excel homework
a932270734
CIS101-PA3.docxCISI 101-Intro to Computer Info Systems Dr. Simon Lin
Project Assignment 3 (PA3)
CIS101 Project Assignment 3 (PA3)
Please do the EXCEL’s Challenge Yourself 3.3 , which is on page EX-140-143 of EXCEL section in the book “ Microsoft Office - A Skills Approach 2016 ”.
The start file “EX2016-ChallengeYourself-3-3” (for step 1) must be downloaded from the Files folder by the name of “CIS101-PA3-EX2016-ChallengeYourself-3-3.xlsx”.
Then, you must do the following to really complete and finish your PA3:
Under the sheet Purchase, you must enter your student ID into cell D1, and your full name into cell E1. Then, you must make these two texts bold and in red color.
Please read this presentation file “CIS101-Ch9X-EXCEL_Ch3-Using Formulas & Functions(27) .pptx” from the Files folder if you encounter any problems in this EXCEL project assignment.
Some hints to help you complete this EXCEL project:
C10, D10, E10, F10: =AVERAGE( : )
C13, D13, E13, F13: =VLOOKUP( , ,2,False)
C15, D15, E15, F15: =IF( <= ,"no","yes")
C16, D16, E16, F16: =… -Data! …
C20, D20, E20, F20: =PMT( , , -C16)
C21, D21, E21, F21: =Data! /Purchase! *Data!
C22, D22, E22, F22: = /12
C23, D23, E23, F23: = /12
C24, D24, E24, F24: =SUM( : )
C26, D26, E26, F26: =IF( <=Data! ,"yes","no")
I7 up to I24: =AVERAGE( )
J7 up to J24: =MAX( )
K7 up to K24: =MIN( )
======================================================.
How to verify that your final result is correct?
The final result of Vehicle 1 column should look as follows:
|
|
|
Vehicle 1 |
|
Description |
2016 Ford Mustang Convertible |
|
|
|
Vehicle Type |
Passenger |
|
|
|
|
|
|
Seller |
dealer |
|
|
Price |
$27,800 |
|
|
MPG City |
17 |
|
|
MPG Highway |
28 |
|
|
Average MPG |
22.5 |
|
Yearly Costs |
|
|
|
|
Maintenance/Year |
$600 |
|
|
Registration Fee |
100 |
|
|
Insurance/Year |
$1,000 |
|
Need Loan? |
yes |
|
|
|
Amount to Borrow |
$19,800 |
|
|
APR |
3.20% |
|
|
Years |
5 |
|
Monthly Costs |
|
|
|
|
Loan Payment |
$357.54 |
|
|
Gas |
$66.67 |
|
|
Maintenance/Month |
$50.00 |
|
|
Insurance/Month |
$83.33 |
|
|
Total Monthly |
$557.54 |
|
|
|
|
|
|
Affordable? |
no |
|
|
|
|
=========================================================.
How to submit your work?
You must submit your work by uploading your final result file (for example: CIS101-PA3- EX2016-ChallengeYourself-3-3.MyName.xlsx).
Page 2 of 2
