Rent	Years of Lease	Credit Score	Deposit
1328	1	3
1650	0.5	3
1645	0.5	3
1548	0.5	3
1370	0.5	3
1325	1	2
1451	0.5	2
1462	0.5	2
1650	1	2
1281	1	2
1624	1	2
1588	0.5	2

Question 1

5 Points

Please edit the excel below to calculate the deposit for an apartment for each individual in the list

Here are the simple rules about how the rent is calculated for each one

• The base deposit is the same as the rent
• People who rent only for a half year will have to pay an extra 0.5*rent on top of the base deposit
• People whose credit score is 3 don't have to pay an extra deposit
• People whose credit score is 2 will have to pay an extra 0.5*rent on top of the base deposit
• People whose credit score is 2 will have to pay an extra rent amount on top of the base deposit

Please hide the credit score

Please freeze the first column and first row, so when you scroll down they are still visible

I just need the steps to help me go through it