Practice Module 3 – Excel (Part 1)
You are currently viewing a sample of the Cram Kit. Click here to unlock everything.
Time limit: 0
Practice Exercise Summary
0 of 24 Questions completed
Questions:
Information
You have already completed the practice exercise before. Hence you can not start it again.
Practice Exercise is loading…
You must sign in or sign up to start the practice exercise.
You must first complete the following:
Results
Practice Exercise complete. Results are being recorded.
Results
0 of 24 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
- Review / Skip
- Answered
- Correct
- Incorrect
-
Question 1 of 24
1. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 2 of 24
2. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 3 of 24
3. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 4 of 24
4. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 5 of 24
5. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 6 of 24
6. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 7 of 24
7. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 8 of 24
8. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 9 of 24
9. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 10 of 24
10. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 11 of 24
11. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 12 of 24
12. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 13 of 24
13. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 14 of 24
14. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 15 of 24
15. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 16 of 24
16. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 17 of 24
17. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 18 of 24
18. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 19 of 24
19. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 20 of 24
20. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 21 of 24
21. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 22 of 24
22. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 23 of 24
23. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect -
Question 24 of 24
24. Question
- Switch to the Comparison Operators sheet.
- Complete the instructions on the Comparison Operators sheet.
- Switch to the Family Budget #1 sheet.
- Autofill the monthly abbreviations in cell B3 for the rest of the headers across row 3 until column M.
- Fix the width of columns C and D so that the #’s do not show in cells C4:D5.
- Apply the “Total” cell style to A7:N7 and A19:N19. Then calculate the totals for each row.
- In cell B27, enter a formula to calculate the mortgage payment given in information in cells B23:D26. Your final Monthly Payment Amount should be positive.
- Change the length of loan in B24 to 18 years.
- Copy the formula from B27 to C27.
- In cell I25, the Investment Savings calculator has determined that at a monthly investment of $250 with a return rate of 3.5% over 10 years, the family could save up $35,858.13. However, the family would like to save $40,000.00 after 10 years. Use an Excel feature to determine what the return rate would need to be to achieve their desired final value.
- In row 10, utilize cell B27 and copy the Monthly Payment Amount across all Mortgage values. Make sure they have the same formatting as the rest of the expenses.
- In cell N10 sum all the Mortgage Payments.
- Notice that the summed value is $9239.99. This should be $9240.00 but because the monthly payment is based on a formula, we may need to utilize the ROUND feature here.
- Use a function to round the value of B27 to 2 decimals. (This should fix your total value for the mortgage payments.)
- Use a function In B16 to display the Personal Driver Service amount if B15 equals 0. If B15 does not equal 0, then set the Personal Driver Service for that month to 0.
- Copy the formula from B16 to M16.
- Enter a formula into O4 to calculate the percentage of total revenue in cell N7 that Bill contributes to the family. Then, copy this formula down to cell O6.
- In cell O10 do the same thing as #15, except computing what percentage the mortgage payment is of the total expenses in cell O19. Then, copy this formula down through all the expenses.
- Format O4:O6 and O11:O18 to have 2 decimal places.
- Save your file.
- Switch to the 5k Race sheet.
- Complete the instructions on the 5k Race sheet.
- Switch to the Pong sheet.
- Complete the instructions on the Pong sheet.
- Save your file.
CorrectIncorrect