GO! ECH04 H1 – Jesse Jewelers Condo Purchase 1.3
Project Description:
In this project, you will use a PMT function to calculate a value and then use it in a twovariable data table. You will create named ranges and use them in formulas.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step 
Instructions 
Points Possible 
1 
Start Excel. Download, save, and open the workbook named GO_e04_Grader_h1.xlsx. 
0.000 
2 
On the Condo Purchase sheet, in cell B5, insert the PMT function using the data from the range B2:B5—be sure to divide the interest rate by 12, multiply the years by 12, and display the payment as a positive number. 
10.000 
3 
Use Goal Seek to change the amount of the loan so that the payment is $6,250 (6250). 
2.000 
4 
On the Condo Purchase sheet, in cell A1, apply the Title cell style. In A7, type Option #1 Reduce the Loan and then Copy the format from cell A1 to cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A8. In cell B2, type 615000 to restore the original loan amount. 
10.000 
5 
Use Goal Seek to change the period of the loan (of the original data) so that the payment is $6,250 (6250). 
5.000 
6 
In A13, type Option #2 Increase Years Format the cell the same as cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A14. Display the value in B15 with two decimal places, and then in cell B3, type 10 to restore the original value. 
7.000 
7 
On the Payment Table worksheet, in the range A2:B4, enter the following row titles and data. Amount of Loan $615,000 
6.000 
8 
In cell C8, type 60—the number of months in a 5year loan. In D8, type 120—the number of months in a 10year loan. Fill the series through cell H8. Bold and Center cells C8:H8. 
4.000 
9 
Beginning in cell B9, enter varying interest rates in decrements of .5% beginning with 7.5% and ending with 4.0%. Format all the interest rates with two decimal places, and then apply Bold and Center to the range B9:B16. 
4.000 
10 
In cell B8, enter a PMT function using the information in cells B2:B4. Be sure that you convert the interest rate to a monthly rate and that the result displays as a positive number. 
10.000 
11 
Create a Data Table in the range B8:H16 using the information in cells B2:B4 in which the Row input cell is the Period and the Column input cell is the Interest rate. 
10.000 
12 
Copy the format from B8 to the results in the data table. Format cell D16 with the Note cell style as the payment option that is close to but less than $6,250 per month. 
3.000 
13 
Display the Advertising Costs by Quarter worksheet, and then apply Currency [0] to B6:E6, Comma [0] to B7:E18, and Total cell styles to B19:E19. 
2.000 
14 
Name the following ranges: B6:E10 Newspaper_Costs; B11:E14 Digital_Costs; B15:E16 Magazine_Costs; B17:E17 Billboard_Costs 
6.000 
15 
Insert a new row 15. In cell A15, type Business Podcasts. In cell B15, type 12500. In cell C15, type 11525. In cell D15, type 14455. In cell E15, type 13009. 
3.000 
16 
Display the Name Manager, click Digital_Costs, and then change cell E14 to E15. Select the Billboard_Costs, and Edit the name to Outdoor_Costs. 
5.000 
17 
Display the Annual Advertising Costs sheet. In cell B5, type =sum(N and sum the values, using the appropriate range name in the function. Do this for the other named ranges. Sum all the costs. Apply Currency [0], Comma [0], and Total cell styles. 
10.000 
18 
Group the worksheets, center the worksheets Horizontally on the page and set orientation to Landscape. Document properties should include the tags payment table, advertising costs. 
3.000 
19 
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Condo Purchase, Payment Table, Advertising Costs by Quarter, Annual Advertising Costs. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 
0.000 

Total Points 
100.000 
GO! ECH04 H1 – Jesse Jewelers Condo Purchase 1.3
Project Description:
In this project, you will use a PMT function to calculate a value and then use it in a twovariable data table. You will create named ranges and use them in formulas.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step 
Instructions 
Points Possible 
1 
Start Excel. Download, save, and open the workbook named GO_e04_Grader_h1.xlsx. 
0.000 
2 
On the Condo Purchase sheet, in cell B5, insert the PMT function using the data from the range B2:B5—be sure to divide the interest rate by 12, multiply the years by 12, and display the payment as a positive number. 
10.000 
3 
Use Goal Seek to change the amount of the loan so that the payment is $6,250 (6250). 
2.000 
4 
On the Condo Purchase sheet, in cell A1, apply the Title cell style. In A7, type Option #1 Reduce the Loan and then Copy the format from cell A1 to cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A8. In cell B2, type 615000 to restore the original loan amount. 
10.000 
5 
Use Goal Seek to change the period of the loan (of the original data) so that the payment is $6,250 (6250). 
5.000 
6 
In A13, type Option #2 Increase Years Format the cell the same as cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A14. Display the value in B15 with two decimal places, and then in cell B3, type 10 to restore the original value. 
7.000 
7 
On the Payment Table worksheet, in the range A2:B4, enter the following row titles and data. Amount of Loan $615,000 
6.000 
8 
In cell C8, type 60—the number of months in a 5year loan. In D8, type 120—the number of months in a 10year loan. Fill the series through cell H8. Bold and Center cells C8:H8. 
4.000 
9 
Beginning in cell B9, enter varying interest rates in decrements of .5% beginning with 7.5% and ending with 4.0%. Format all the interest rates with two decimal places, and then apply Bold and Center to the range B9:B16. 
4.000 
10 
In cell B8, enter a PMT function using the information in cells B2:B4. Be sure that you convert the interest rate to a monthly rate and that the result displays as a positive number. 
10.000 
11 
Create a Data Table in the range B8:H16 using the information in cells B2:B4 in which the Row input cell is the Period and the Column input cell is the Interest rate. 
10.000 
12 
Copy the format from B8 to the results in the data table. Format cell D16 with the Note cell style as the payment option that is close to but less than $6,250 per month. 
3.000 
13 
Display the Advertising Costs by Quarter worksheet, and then apply Currency [0] to B6:E6, Comma [0] to B7:E18, and Total cell styles to B19:E19. 
2.000 
14 
Name the following ranges: B6:E10 Newspaper_Costs; B11:E14 Digital_Costs; B15:E16 Magazine_Costs; B17:E17 Billboard_Costs 
6.000 
15 
Insert a new row 15. In cell A15, type Business Podcasts. In cell B15, type 12500. In cell C15, type 11525. In cell D15, type 14455. In cell E15, type 13009. 
3.000 
16 
Display the Name Manager, click Digital_Costs, and then change cell E14 to E15. Select the Billboard_Costs, and Edit the name to Outdoor_Costs. 
5.000 
17 
Display the Annual Advertising Costs sheet. In cell B5, type =sum(N and sum the values, using the appropriate range name in the function. Do this for the other named ranges. Sum all the costs. Apply Currency [0], Comma [0], and Total cell styles. 
10.000 
18 
Group the worksheets, center the worksheets Horizontally on the page and set orientation to Landscape. Document properties should include the tags payment table, advertising costs. 
3.000 
19 
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Condo Purchase, Payment Table, Advertising Costs by Quarter, Annual Advertising Costs. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 
0.000 

Total Points 
100.000 
GO! ECH04 H1 – Jesse Jewelers Condo Purchase 1.3
Project Description:
In this project, you will use a PMT function to calculate a value and then use it in a twovariable data table. You will create named ranges and use them in formulas.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step 
Instructions 
Points Possible 
1 
Start Excel. Download, save, and open the workbook named GO_e04_Grader_h1.xlsx. 
0.000 
2 
On the Condo Purchase sheet, in cell B5, insert the PMT function using the data from the range B2:B5—be sure to divide the interest rate by 12, multiply the years by 12, and display the payment as a positive number. 
10.000 
3 
Use Goal Seek to change the amount of the loan so that the payment is $6,250 (6250). 
2.000 
4 
On the Condo Purchase sheet, in cell A1, apply the Title cell style. In A7, type Option #1 Reduce the Loan and then Copy the format from cell A1 to cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A8. In cell B2, type 615000 to restore the original loan amount. 
10.000 
5 
Use Goal Seek to change the period of the loan (of the original data) so that the payment is $6,250 (6250). 
5.000 
6 
In A13, type Option #2 Increase Years Format the cell the same as cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A14. Display the value in B15 with two decimal places, and then in cell B3, type 10 to restore the original value. 
7.000 
7 
On the Payment Table worksheet, in the range A2:B4, enter the following row titles and data. Amount of Loan $615,000 
6.000 
8 
In cell C8, type 60—the number of months in a 5year loan. In D8, type 120—the number of months in a 10year loan. Fill the series through cell H8. Bold and Center cells C8:H8. 
4.000 
9 
Beginning in cell B9, enter varying interest rates in decrements of .5% beginning with 7.5% and ending with 4.0%. Format all the interest rates with two decimal places, and then apply Bold and Center to the range B9:B16. 
4.000 
10 
In cell B8, enter a PMT function using the information in cells B2:B4. Be sure that you convert the interest rate to a monthly rate and that the result displays as a positive number. 
10.000 
11 
Create a Data Table in the range B8:H16 using the information in cells B2:B4 in which the Row input cell is the Period and the Column input cell is the Interest rate. 
10.000 
12 
Copy the format from B8 to the results in the data table. Format cell D16 with the Note cell style as the payment option that is close to but less than $6,250 per month. 
3.000 
13 
Display the Advertising Costs by Quarter worksheet, and then apply Currency [0] to B6:E6, Comma [0] to B7:E18, and Total cell styles to B19:E19. 
2.000 
14 
Name the following ranges: B6:E10 Newspaper_Costs; B11:E14 Digital_Costs; B15:E16 Magazine_Costs; B17:E17 Billboard_Costs 
6.000 
15 
Insert a new row 15. In cell A15, type Business Podcasts. In cell B15, type 12500. In cell C15, type 11525. In cell D15, type 14455. In cell E15, type 13009. 
3.000 
16 
Display the Name Manager, click Digital_Costs, and then change cell E14 to E15. Select the Billboard_Costs, and Edit the name to Outdoor_Costs. 
5.000 
17 
Display the Annual Advertising Costs sheet. In cell B5, type =sum(N and sum the values, using the appropriate range name in the function. Do this for the other named ranges. Sum all the costs. Apply Currency [0], Comma [0], and Total cell styles. 
10.000 
18 
Group the worksheets, center the worksheets Horizontally on the page and set orientation to Landscape. Document properties should include the tags payment table, advertising costs. 
3.000 
19 
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Condo Purchase, Payment Table, Advertising Costs by Quarter, Annual Advertising Costs. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 
0.000 

Total Points 
100.000 
GO! ECH04 H1 – Jesse Jewelers Condo Purchase 1.3
GO! ECH04 H1 – Jesse Jewelers Condo Purchase 1.3GO! ECH04 H1 – Jesse Jewelers Condo Purchase 1.3GO! ECH04 H1 – Jesse Jewelers Condo Purchase 1.3
Project Description:
Project Description: Project Description: Project Description:
In this project, you will use a PMT function to calculate a value and then use it in a twovariable data table. You will create named ranges and use them in formulas.
In this project, you will use a PMT function to calculate a value and then use it in a twovariable data table. You will create named ranges and use them in formulas.In this project, you will use a PMT function to calculate a value and then use it in a twovariable data table. You will create named ranges and use them in formulas.In this project, you will use a PMT function to calculate a value and then use it in a twovariable data table. You will create named ranges and use them in formulas.
Instructions:
Instructions: Instructions: Instructions:
For the purpose of grading the project you are required to perform the following tasks:
For the purpose of grading the project you are required to perform the following tasks:
Step 
Instructions 
Points Possible 
1 
Start Excel. Download, save, and open the workbook named GO_e04_Grader_h1.xlsx. 
0.000 
2 
On the Condo Purchase sheet, in cell B5, insert the PMT function using the data from the range B2:B5—be sure to divide the interest rate by 12, multiply the years by 12, and display the payment as a positive number. 
10.000 
3 
Use Goal Seek to change the amount of the loan so that the payment is $6,250 (6250). 
2.000 
4 
On the Condo Purchase sheet, in cell A1, apply the Title cell style. In A7, type Option #1 Reduce the Loan and then Copy the format from cell A1 to cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A8. In cell B2, type 615000 to restore the original loan amount. 
10.000 
5 
Use Goal Seek to change the period of the loan (of the original data) so that the payment is $6,250 (6250). 
5.000 
6 
In A13, type Option #2 Increase Years Format the cell the same as cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A14. Display the value in B15 with two decimal places, and then in cell B3, type 10 to restore the original value. 
7.000 
7 
On the Payment Table worksheet, in the range A2:B4, enter the following row titles and data. Amount of Loan $615,000 
6.000 
8 
In cell C8, type 60—the number of months in a 5year loan. In D8, type 120—the number of months in a 10year loan. Fill the series through cell H8. Bold and Center cells C8:H8. 
4.000 
9 
Beginning in cell B9, enter varying interest rates in decrements of .5% beginning with 7.5% and ending with 4.0%. Format all the interest rates with two decimal places, and then apply Bold and Center to the range B9:B16. 
4.000 
10 
In cell B8, enter a PMT function using the information in cells B2:B4. Be sure that you convert the interest rate to a monthly rate and that the result displays as a positive number. 
10.000 
11 
Create a Data Table in the range B8:H16 using the information in cells B2:B4 in which the Row input cell is the Period and the Column input cell is the Interest rate. 
10.000 
12 
Copy the format from B8 to the results in the data table. Format cell D16 with the Note cell style as the payment option that is close to but less than $6,250 per month. 
3.000 
13 
Display the Advertising Costs by Quarter worksheet, and then apply Currency [0] to B6:E6, Comma [0] to B7:E18, and Total cell styles to B19:E19. 
2.000 
14 
Name the following ranges: B6:E10 Newspaper_Costs; B11:E14 Digital_Costs; B15:E16 Magazine_Costs; B17:E17 Billboard_Costs 
6.000 
15 
Insert a new row 15. In cell A15, type Business Podcasts. In cell B15, type 12500. In cell C15, type 11525. In cell D15, type 14455. In cell E15, type 13009. 
3.000 
16 
Display the Name Manager, click Digital_Costs, and then change cell E14 to E15. Select the Billboard_Costs, and Edit the name to Outdoor_Costs. 
5.000 
17 
Display the Annual Advertising Costs sheet. In cell B5, type =sum(N and sum the values, using the appropriate range name in the function. Do this for the other named ranges. Sum all the costs. Apply Currency [0], Comma [0], and Total cell styles. 
10.000 
18 
Group the worksheets, center the worksheets Horizontally on the page and set orientation to Landscape. Document properties should include the tags payment table, advertising costs. 
3.000 
19 
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Condo Purchase, Payment Table, Advertising Costs by Quarter, Annual Advertising Costs. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 
0.000 

Total Points 
100.000 
Step
Instructions
Points Possible
Step
Instructions
Points Possible
Step
Step
StepStepStep
Instructions
Instructions
InstructionsInstructionsInstructions
Points Possible
Points Possible
Points PossiblePoints PossiblePoints Possible
1
Start Excel. Download, save, and open the workbook named GO_e04_Grader_h1.xlsx.
0.000
2
On the Condo Purchase sheet, in cell B5, insert the PMT function using the data from the range B2:B5—be sure to divide the interest rate by 12, multiply the years by 12, and display the payment as a positive number.
10.000
3
Use Goal Seek to change the amount of the loan so that the payment is $6,250 (6250).
2.000
4
On the Condo Purchase sheet, in cell A1, apply the Title cell style. In A7, type Option #1 Reduce the Loan and then Copy the format from cell A1 to cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A8. In cell B2, type 615000 to restore the original loan amount.
10.000
5
Use Goal Seek to change the period of the loan (of the original data) so that the payment is $6,250 (6250).
5.000
6
In A13, type Option #2 Increase Years Format the cell the same as cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A14. Display the value in B15 with two decimal places, and then in cell B3, type 10 to restore the original value.
7.000
7
On the Payment Table worksheet, in the range A2:B4, enter the following row titles and data.
Amount of Loan $615,000
Period (months) 120
Interest Rate (per year) 5.25%
6.000
8
In cell C8, type 60—the number of months in a 5year loan. In D8, type 120—the number of months in a 10year loan. Fill the series through cell H8. Bold and Center cells C8:H8.
4.000
9
Beginning in cell B9, enter varying interest rates in decrements of .5% beginning with 7.5% and ending with 4.0%. Format all the interest rates with two decimal places, and then apply Bold and Center to the range B9:B16.
4.000
10
In cell B8, enter a PMT function using the information in cells B2:B4. Be sure that you convert the interest rate to a monthly rate and that the result displays as a positive number.
10.000
11
Create a Data Table in the range B8:H16 using the information in cells B2:B4 in which the Row input cell is the Period and the Column input cell is the Interest rate.
10.000
12
Copy the format from B8 to the results in the data table. Format cell D16 with the Note cell style as the payment option that is close to but less than $6,250 per month.
3.000
13
Display the Advertising Costs by Quarter worksheet, and then apply Currency [0] to B6:E6, Comma [0] to B7:E18, and Total cell styles to B19:E19.
2.000
14
Name the following ranges: B6:E10 Newspaper_Costs; B11:E14 Digital_Costs; B15:E16 Magazine_Costs; B17:E17 Billboard_Costs
6.000
15
Insert a new row 15. In cell A15, type Business Podcasts. In cell B15, type 12500. In cell C15, type 11525. In cell D15, type 14455. In cell E15, type 13009.
3.000
16
Display the Name Manager, click Digital_Costs, and then change cell E14 to E15. Select the Billboard_Costs, and Edit the name to Outdoor_Costs.
5.000
17
Display the Annual Advertising Costs sheet. In cell B5, type =sum(N and sum the values, using the appropriate range name in the function. Do this for the other named ranges. Sum all the costs. Apply Currency [0], Comma [0], and Total cell styles.
10.000
18
Group the worksheets, center the worksheets Horizontally on the page and set orientation to Landscape. Document properties should include the tags payment table, advertising costs.
3.000
19
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Condo Purchase, Payment Table, Advertising Costs by Quarter, Annual Advertising Costs. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
0.000
Total Points
100.000
1
Start Excel. Download, save, and open the workbook named GO_e04_Grader_h1.xlsx.
0.000
1
1
111
Start Excel. Download, save, and open the workbook named GO_e04_Grader_h1.xlsx.
Start Excel. Download, save, and open the workbook named GO_e04_Grader_h1.xlsx.
Start Excel. Download, save, and open the workbook named GO_e04_Grader_h1.xlsx. GO_e04_Grader_h1.xlsx
0.000
0.000
0.000
2
On the Condo Purchase sheet, in cell B5, insert the PMT function using the data from the range B2:B5—be sure to divide the interest rate by 12, multiply the years by 12, and display the payment as a positive number.
10.000
2
2
222
On the Condo Purchase sheet, in cell B5, insert the PMT function using the data from the range B2:B5—be sure to divide the interest rate by 12, multiply the years by 12, and display the payment as a positive number.
On the Condo Purchase sheet, in cell B5, insert the PMT function using the data from the range B2:B5—be sure to divide the interest rate by 12, multiply the years by 12, and display the payment as a positive number.
On the Condo Purchase sheet, in cell B5, insert the PMT function using the data from the range B2:B5—be sure to divide the interest rate by 12, multiply the years by 12, and display the payment as a positive number.
On the Condo Purchase sheet, in cell B5, insert the PMT function using the data from the range B2:B5—be sure to divide the interest rate by 12, multiply the years by 12, and display the payment as a positive number.
1212
10.000
10.000
10.000
3
Use Goal Seek to change the amount of the loan so that the payment is $6,250 (6250).
2.000
3
3
333
Use Goal Seek to change the amount of the loan so that the payment is $6,250 (6250).
Use Goal Seek to change the amount of the loan so that the payment is $6,250 (6250).
Use Goal Seek to change the amount of the loan so that the payment is $6,250 (6250). 6250
2.000
2.000
2.000
4
On the Condo Purchase sheet, in cell A1, apply the Title cell style. In A7, type Option #1 Reduce the Loan and then Copy the format from cell A1 to cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A8. In cell B2, type 615000 to restore the original loan amount.
10.000
4
4
444
On the Condo Purchase sheet, in cell A1, apply the Title cell style. In A7, type Option #1 Reduce the Loan and then Copy the format from cell A1 to cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A8. In cell B2, type 615000 to restore the original loan amount.
On the Condo Purchase sheet, in cell A1, apply the Title cell style. In A7, type Option #1 Reduce the Loan and then Copy the format from cell A1 to cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A8. In cell B2, type 615000 to restore the original loan amount.
On the Condo Purchase sheet, in cell A1, apply the Title cell style. In A7, type Option #1 Reduce the Loan and then Copy the format from cell A1 to cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A8. In cell B2, type 615000 to restore the original loan amount.Option #1 Reduce the Loan615000
10.000
10.000
10.000
5
Use Goal Seek to change the period of the loan (of the original data) so that the payment is $6,250 (6250).
5.000
5
5
555
Use Goal Seek to change the period of the loan (of the original data) so that the payment is $6,250 (6250).
Use Goal Seek to change the period of the loan (of the original data) so that the payment is $6,250 (6250).
Use Goal Seek to change the period of the loan (of the original data) so that the payment is $6,250 (6250).(6250)
5.000
5.000
5.000
6
In A13, type Option #2 Increase Years Format the cell the same as cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A14. Display the value in B15 with two decimal places, and then in cell B3, type 10 to restore the original value.
7.000
6
6
666
In A13, type Option #2 Increase Years Format the cell the same as cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A14. Display the value in B15 with two decimal places, and then in cell B3, type 10 to restore the original value.
In A13, type Option #2 Increase Years Format the cell the same as cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A14. Display the value in B15 with two decimal places, and then in cell B3, type 10 to restore the original value.
In A13, type Option #2 Increase Years Format the cell the same as cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A14. Display the value in B15 with two decimal places, and then in cell B3, type 10 to restore the original value.Option #2 Increase Years10
7.000
7.000
7.000
7
On the Payment Table worksheet, in the range A2:B4, enter the following row titles and data.
Amount of Loan $615,000
Period (months) 120
Interest Rate (per year) 5.25%
6.000
7
7
777
On the Payment Table worksheet, in the range A2:B4, enter the following row titles and data.
Amount of Loan $615,000
Period (months) 120
Interest Rate (per year) 5.25%
On the Payment Table worksheet, in the range A2:B4, enter the following row titles and data.
Amount of Loan $615,000
Period (months) 120
Interest Rate (per year) 5.25%
On the Payment Table worksheet, in the range A2:B4, enter the following row titles and data.
Amount of Loan $615,000
Period (months) 120
Interest Rate (per year) 5.25%
Amount of Loan $615,000
Period (months) 120
Interest Rate (per year) 5.25%
6.000
6.000
6.000
8
In cell C8, type 60—the number of months in a 5year loan. In D8, type 120—the number of months in a 10year loan. Fill the series through cell H8. Bold and Center cells C8:H8.
4.000
8
8
888
In cell C8, type 60—the number of months in a 5year loan. In D8, type 120—the number of months in a 10year loan. Fill the series through cell H8. Bold and Center cells C8:H8.
In cell C8, type 60—the number of months in a 5year loan. In D8, type 120—the number of months in a 10year loan. Fill the series through cell H8. Bold and Center cells C8:H8.
In cell C8, type 60—the number of months in a 5year loan. In D8, type 120—the number of months in a 10year loan. Fill the series through cell H8. Bold and Center cells C8:H8.In cell C8, type 6060—the number of months in a 5year loan. In D8, type 120120—the number of months in a 10year loan. Fill the series through cell H8. Bold and Center cells C8:H8.
4.000
4.000
4.000
9
Beginning in cell B9, enter varying interest rates in decrements of .5% beginning with 7.5% and ending with 4.0%. Format all the interest rates with two decimal places, and then apply Bold and Center to the range B9:B16.
4.000
9
9
999
Beginning in cell B9, enter varying interest rates in decrements of .5% beginning with 7.5% and ending with 4.0%. Format all the interest rates with two decimal places, and then apply Bold and Center to the range B9:B16.
Beginning in cell B9, enter varying interest rates in decrements of .5% beginning with 7.5% and ending with 4.0%. Format all the interest rates with two decimal places, and then apply Bold and Center to the range B9:B16.
Beginning in cell B9, enter varying interest rates in decrements of .5% beginning with 7.5% and ending with 4.0%. Format all the interest rates with two decimal places, and then apply Bold and Center to the range B9:B16.7.5%4.0%.
4.000
4.000
4.000
10
In cell B8, enter a PMT function using the information in cells B2:B4. Be sure that you convert the interest rate to a monthly rate and that the result displays as a positive number.
10.000
10
10
101010
In cell B8, enter a PMT function using the information in cells B2:B4. Be sure that you convert the interest rate to a monthly rate and that the result displays as a positive number.
In cell B8, enter a PMT function using the information in cells B2:B4. Be sure that you convert the interest rate to a monthly rate and that the result displays as a positive number.
In cell B8, enter a PMT function using the information in cells B2:B4. Be sure that you convert the interest rate to a monthly rate and that the result displays as a positive number.
10.000
10.000
10.000
11
Create a Data Table in the range B8:H16 using the information in cells B2:B4 in which the Row input cell is the Period and the Column input cell is the Interest rate.
10.000
11
11
111111
Create a Data Table in the range B8:H16 using the information in cells B2:B4 in which the Row input cell is the Period and the Column input cell is the Interest rate.
Create a Data Table in the range B8:H16 using the information in cells B2:B4 in which the Row input cell is the Period and the Column input cell is the Interest rate.
Create a Data Table in the range B8:H16 using the information in cells B2:B4 in which the Row input cell is the Period and the Column input cell is the Interest rate.
10.000
10.000
10.000
12
Copy the format from B8 to the results in the data table. Format cell D16 with the Note cell style as the payment option that is close to but less than $6,250 per month.
3.000
12
12
121212
Copy the format from B8 to the results in the data table. Format cell D16 with the Note cell style as the payment option that is close to but less than $6,250 per month.
Copy the format from B8 to the results in the data table. Format cell D16 with the Note cell style as the payment option that is close to but less than $6,250 per month.
Copy the format from B8 to the results in the data table. Format cell D16 with the Note cell style as the payment option that is close to but less than $6,250 per month.
3.000
3.000
3.000
13
Display the Advertising Costs by Quarter worksheet, and then apply Currency [0] to B6:E6, Comma [0] to B7:E18, and Total cell styles to B19:E19.
2.000
13
13
131313
Display the Advertising Costs by Quarter worksheet, and then apply Currency [0] to B6:E6, Comma [0] to B7:E18, and Total cell styles to B19:E19.
Display the Advertising Costs by Quarter worksheet, and then apply Currency [0] to B6:E6, Comma [0] to B7:E18, and Total cell styles to B19:E19.
Display the Advertising Costs by Quarter worksheet, and then apply Currency [0] to B6:E6, Comma [0] to B7:E18, and Total cell styles to B19:E19.
2.000
2.000
2.000
14
Name the following ranges: B6:E10 Newspaper_Costs; B11:E14 Digital_Costs; B15:E16 Magazine_Costs; B17:E17 Billboard_Costs
6.000
14
14
141414
Name the following ranges: B6:E10 Newspaper_Costs; B11:E14 Digital_Costs; B15:E16 Magazine_Costs; B17:E17 Billboard_Costs
Name the following ranges: B6:E10 Newspaper_Costs; B11:E14 Digital_Costs; B15:E16 Magazine_Costs; B17:E17 Billboard_Costs
Name the following ranges: B6:E10 Newspaper_Costs; B11:E14 Digital_Costs; B15:E16 Magazine_Costs; B17:E17 Billboard_CostsNewspaper_CostsDigital_CostsMagazine_CostsBillboard_Costs
6.000
6.000
6.000
15
Insert a new row 15. In cell A15, type Business Podcasts. In cell B15, type 12500. In cell C15, type 11525. In cell D15, type 14455. In cell E15, type 13009.
3.000
15
15
151515
Insert a new row 15. In cell A15, type Business Podcasts. In cell B15, type 12500. In cell C15, type 11525. In cell D15, type 14455. In cell E15, type 13009.
Insert a new row 15. In cell A15, type Business Podcasts. In cell B15, type 12500. In cell C15, type 11525. In cell D15, type 14455. In cell E15, type 13009.
Insert a new row 15. In cell A15, type Business Podcasts. In cell B15, type 12500. In cell C15, type 11525. In cell D15, type 14455. In cell E15, type 13009.Business Podcasts12500115251445513009
3.000
3.000
3.000
16
Display the Name Manager, click Digital_Costs, and then change cell E14 to E15. Select the Billboard_Costs, and Edit the name to Outdoor_Costs.
5.000
16
16
161616
Display the Name Manager, click Digital_Costs, and then change cell E14 to E15. Select the Billboard_Costs, and Edit the name to Outdoor_Costs.
Display the Name Manager, click Digital_Costs, and then change cell E14 to E15. Select the Billboard_Costs, and Edit the name to Outdoor_Costs.
Display the Name Manager, click Digital_Costs, and then change cell E14 to E15. Select the Billboard_Costs, and Edit the name to Outdoor_Costs.
E15Outdoor_Costs
5.000
5.000
5.000
17
Display the Annual Advertising Costs sheet. In cell B5, type =sum(N and sum the values, using the appropriate range name in the function. Do this for the other named ranges. Sum all the costs. Apply Currency [0], Comma [0], and Total cell styles.
10.000
17
17
171717
Display the Annual Advertising Costs sheet. In cell B5, type =sum(N and sum the values, using the appropriate range name in the function. Do this for the other named ranges. Sum all the costs. Apply Currency [0], Comma [0], and Total cell styles.
Display the Annual Advertising Costs sheet. In cell B5, type =sum(N and sum the values, using the appropriate range name in the function. Do this for the other named ranges. Sum all the costs. Apply Currency [0], Comma [0], and Total cell styles.
Display the Annual Advertising Costs sheet. In cell B5, type =sum(N and sum the values, using the appropriate range name in the function. Do this for the other named ranges. Sum all the costs. Apply Currency [0], Comma [0], and Total cell styles.=sum(N
10.000
10.000
10.000
18
Group the worksheets, center the worksheets Horizontally on the page and set orientation to Landscape. Document properties should include the tags payment table, advertising costs.
3.000
18
18
181818
Group the worksheets, center the worksheets Horizontally on the page and set orientation to Landscape. Document properties should include the tags payment table, advertising costs.
Group the worksheets, center the worksheets Horizontally on the page and set orientation to Landscape. Document properties should include the tags payment table, advertising costs.
Group the worksheets, center the worksheets Horizontally on the page and set orientation to Landscape. Document properties should include the tags payment table, advertising costs.payment tableadvertising costs
3.000
3.000
3.000
19
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Condo Purchase, Payment Table, Advertising Costs by Quarter, Annual Advertising Costs. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
0.000
19
19
191919
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Condo Purchase, Payment Table, Advertising Costs by Quarter, Annual Advertising Costs. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Condo Purchase, Payment Table, Advertising Costs by Quarter, Annual Advertising Costs. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Condo Purchase, Payment Table, Advertising Costs by Quarter, Annual Advertising Costs. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
0.000
0.000
0.000
Total Points
100.000
Total Points
Total Points
Total PointsTotal PointsTotal Points
100.000
100.000
100.000100.000100.000