EX16_XL_CH07_GRADER_CAP_AS – Sales Data 1.1
Project Description:
Your assistant created a spreadsheet that lists names, hire dates, quarterly sales, and total sales for 2018. You will calculate the number of years each representative has worked and each representative’s bonus. In addition, you will create a nested lookup function to look up a person’s name and particular quarter to identify the sales for that person. Next, you will perform advanced database filtering and use summary database functions. Finally, you will complete an amortization table to build a small addition to your office complex.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step 
Instructions 
Points Possible 
1 
Download and open the file named exploring_e07_grader_a1_Sales.xlsx, and then save the file as exploring_e07_grader_a1_Sales_LastFirst, replacing LastFirst with your name. 
0.000 
2 
On the Sales worksheet, enter a date function in cell C8 to calculate the number of years the first representative has worked for your company. Copy the function to the range C9:C20. 
7.000 
3 
On the Sales worksheet, enter a nested function in cell J8 of the Bonus column to display the bonus amount. If the employee sold $200,000 or more (cell J2) AND is International (cell I4), he or she earns a 5% (cell J4) bonus on his or her total annual sales; otherwise, the representative earns 3% (cell J3) of his or her total annual sales. Use relative and mixed (or absolute) references correctly in the nested function. Copy the function from J8 to the range J9:J20. 
7.000 
4 
Enter a nested lookup function in cell E4 that uses the cells E2 and E3 to return a specific sales record. For example, using the current data, you want the function to return the third quarter sales for Erica. 
7.000 
5 
Click the Database worksheet tab and enter conditions in the Criteria Range for Domestic sales reps that made 240000 or more in sales. Data function Tab and search criteria 
4.000 
6 
Perform an advanced filter based on the criteria range. Set the filter to copy the new data to the range A22:G22. 
8.000 
7 
In cell J7, enter a database function to calculate the number of reps meeting the criteria. Use the output range A22:G35 for the database argument in the function. 
7.000 
8 
In cell J8, enter a database function to calculate the highest total sales for records meeting the criteria. Use the output range A22:G35 for the database argument in the function. 
7.000 
9 
In cell J9, enter a database function to calculate the average sales for records meeting the criteria. Use the output range A22:G35 for the database argument in the function. 
7.000 
10 
Click the Addition worksheet tab, and then insert a formula in cell E2 to calculate the loan amount based on the loan parameters. 
4.000 
11 
In cell E5, enter a function to calculate the monthly payment. Modify the function to ensure that the result is a positive number. 
5.000 
12 
In cell E6, enter a function to calculate the total interest paid after five payments. Modify the function to ensure that the result is a positive number. The formula will result in an error until the loan amortization table is completed. 
7.000 
13 
In cell B11, create a relative reference to cell B7 and in cell C11, create a relative reference to cell E2. In cell C12, enter a relative reference to cell F11 and copy the formula to the range C13:C15. 
4.000 
14 
In cell B12, insert a nested DATE function to enter the payment date for the next month. Copy the function to the range B13:B15. 
7.000 
15 
In cell D11, enter the financial function to calculate the interest paid for the first payment period. The result should be a positive value. 
7.000 
16 
In cell E11, enter the financial function to calculate the principal payment for the first payment period. The result should be a positive value. 
7.000 
17 
In cell F11, subtract the principal payment in cell E11 from the beginning balance in cell C11. Copy the functions and formulas from the range D11:F11 to the range D12:F15. 
5.000 
18 
Save the file making sure the worksheets are in the following order: Sales, Database, and Addition. Close Excel. Submit the file as directed. 
0.000 

Total Points 
100.000 
EX16_XL_CH07_GRADER_CAP_AS – Sales Data 1.1
Project Description:
Your assistant created a spreadsheet that lists names, hire dates, quarterly sales, and total sales for 2018. You will calculate the number of years each representative has worked and each representative’s bonus. In addition, you will create a nested lookup function to look up a person’s name and particular quarter to identify the sales for that person. Next, you will perform advanced database filtering and use summary database functions. Finally, you will complete an amortization table to build a small addition to your office complex.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step 
Instructions 
Points Possible 
1 
Download and open the file named exploring_e07_grader_a1_Sales.xlsx, and then save the file as exploring_e07_grader_a1_Sales_LastFirst, replacing LastFirst with your name. 
0.000 
2 
On the Sales worksheet, enter a date function in cell C8 to calculate the number of years the first representative has worked for your company. Copy the function to the range C9:C20. 
7.000 
3 
On the Sales worksheet, enter a nested function in cell J8 of the Bonus column to display the bonus amount. If the employee sold $200,000 or more (cell J2) AND is International (cell I4), he or she earns a 5% (cell J4) bonus on his or her total annual sales; otherwise, the representative earns 3% (cell J3) of his or her total annual sales. Use relative and mixed (or absolute) references correctly in the nested function. Copy the function from J8 to the range J9:J20. 
7.000 
4 
Enter a nested lookup function in cell E4 that uses the cells E2 and E3 to return a specific sales record. For example, using the current data, you want the function to return the third quarter sales for Erica. 
7.000 
5 
Click the Database worksheet tab and enter conditions in the Criteria Range for Domestic sales reps that made 240000 or more in sales. Data function Tab and search criteria 
4.000 
6 
Perform an advanced filter based on the criteria range. Set the filter to copy the new data to the range A22:G22. 
8.000 
7 
In cell J7, enter a database function to calculate the number of reps meeting the criteria. Use the output range A22:G35 for the database argument in the function. 
7.000 
8 
In cell J8, enter a database function to calculate the highest total sales for records meeting the criteria. Use the output range A22:G35 for the database argument in the function. 
7.000 
9 
In cell J9, enter a database function to calculate the average sales for records meeting the criteria. Use the output range A22:G35 for the database argument in the function. 
7.000 
10 
Click the Addition worksheet tab, and then insert a formula in cell E2 to calculate the loan amount based on the loan parameters. 
4.000 
11 
In cell E5, enter a function to calculate the monthly payment. Modify the function to ensure that the result is a positive number. 
5.000 
12 
In cell E6, enter a function to calculate the total interest paid after five payments. Modify the function to ensure that the result is a positive number. The formula will result in an error until the loan amortization table is completed. 
7.000 
13 
In cell B11, create a relative reference to cell B7 and in cell C11, create a relative reference to cell E2. In cell C12, enter a relative reference to cell F11 and copy the formula to the range C13:C15. 
4.000 
14 
In cell B12, insert a nested DATE function to enter the payment date for the next month. Copy the function to the range B13:B15. 
7.000 
15 
In cell D11, enter the financial function to calculate the interest paid for the first payment period. The result should be a positive value. 
7.000 
16 
In cell E11, enter the financial function to calculate the principal payment for the first payment period. The result should be a positive value. 
7.000 
17 
In cell F11, subtract the principal payment in cell E11 from the beginning balance in cell C11. Copy the functions and formulas from the range D11:F11 to the range D12:F15. 
5.000 
18 
Save the file making sure the worksheets are in the following order: Sales, Database, and Addition. Close Excel. Submit the file as directed. 
0.000 

Total Points 
100.000 
EX16_XL_CH07_GRADER_CAP_AS – Sales Data 1.1
Project Description:
Your assistant created a spreadsheet that lists names, hire dates, quarterly sales, and total sales for 2018. You will calculate the number of years each representative has worked and each representative’s bonus. In addition, you will create a nested lookup function to look up a person’s name and particular quarter to identify the sales for that person. Next, you will perform advanced database filtering and use summary database functions. Finally, you will complete an amortization table to build a small addition to your office complex.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step 
Instructions 
Points Possible 
1 
Download and open the file named exploring_e07_grader_a1_Sales.xlsx, and then save the file as exploring_e07_grader_a1_Sales_LastFirst, replacing LastFirst with your name. 
0.000 
2 
On the Sales worksheet, enter a date function in cell C8 to calculate the number of years the first representative has worked for your company. Copy the function to the range C9:C20. 
7.000 
3 
On the Sales worksheet, enter a nested function in cell J8 of the Bonus column to display the bonus amount. If the employee sold $200,000 or more (cell J2) AND is International (cell I4), he or she earns a 5% (cell J4) bonus on his or her total annual sales; otherwise, the representative earns 3% (cell J3) of his or her total annual sales. Use relative and mixed (or absolute) references correctly in the nested function. Copy the function from J8 to the range J9:J20. 
7.000 
4 
Enter a nested lookup function in cell E4 that uses the cells E2 and E3 to return a specific sales record. For example, using the current data, you want the function to return the third quarter sales for Erica. 
7.000 
5 
Click the Database worksheet tab and enter conditions in the Criteria Range for Domestic sales reps that made 240000 or more in sales. Data function Tab and search criteria 
4.000 
6 
Perform an advanced filter based on the criteria range. Set the filter to copy the new data to the range A22:G22. 
8.000 
7 
In cell J7, enter a database function to calculate the number of reps meeting the criteria. Use the output range A22:G35 for the database argument in the function. 
7.000 
8 
In cell J8, enter a database function to calculate the highest total sales for records meeting the criteria. Use the output range A22:G35 for the database argument in the function. 
7.000 
9 
In cell J9, enter a database function to calculate the average sales for records meeting the criteria. Use the output range A22:G35 for the database argument in the function. 
7.000 
10 
Click the Addition worksheet tab, and then insert a formula in cell E2 to calculate the loan amount based on the loan parameters. 
4.000 
11 
In cell E5, enter a function to calculate the monthly payment. Modify the function to ensure that the result is a positive number. 
5.000 
12 
In cell E6, enter a function to calculate the total interest paid after five payments. Modify the function to ensure that the result is a positive number. The formula will result in an error until the loan amortization table is completed. 
7.000 
13 
In cell B11, create a relative reference to cell B7 and in cell C11, create a relative reference to cell E2. In cell C12, enter a relative reference to cell F11 and copy the formula to the range C13:C15. 
4.000 
14 
In cell B12, insert a nested DATE function to enter the payment date for the next month. Copy the function to the range B13:B15. 
7.000 
15 
In cell D11, enter the financial function to calculate the interest paid for the first payment period. The result should be a positive value. 
7.000 
16 
In cell E11, enter the financial function to calculate the principal payment for the first payment period. The result should be a positive value. 
7.000 
17 
In cell F11, subtract the principal payment in cell E11 from the beginning balance in cell C11. Copy the functions and formulas from the range D11:F11 to the range D12:F15. 
5.000 
18 
Save the file making sure the worksheets are in the following order: Sales, Database, and Addition. Close Excel. Submit the file as directed. 
0.000 

Total Points 
100.000 
EX16_XL_CH07_GRADER_CAP_AS – Sales Data 1.1
EX16_XL_CH07_GRADER_CAP_AS – Sales Data 1.1EX16_XL_CH07_GRADER_CAP_AS – Sales Data 1.1EX16_XL_CH07_GRADER_CAP_AS – Sales Data 1.1
Project Description:
Project Description: Project Description: Project Description:
Your assistant created a spreadsheet that lists names, hire dates, quarterly sales, and total sales for 2018. You will calculate the number of years each representative has worked and each representative’s bonus. In addition, you will create a nested lookup function to look up a person’s name and particular quarter to identify the sales for that person. Next, you will perform advanced database filtering and use summary database functions. Finally, you will complete an amortization table to build a small addition to your office complex.
Your assistant created a spreadsheet that lists names, hire dates, quarterly sales, and total sales for 2018. You will calculate the number of years each representative has worked and each representative’s bonus. In addition, you will create a nested lookup function to look up a person’s name and particular quarter to identify the sales for that person. Next, you will perform advanced database filtering and use summary database functions. Finally, you will complete an amortization table to build a small addition to your office complex.Your assistant created a spreadsheet that lists names, hire dates, quarterly sales, and total sales for 2018. You will calculate the number of years each representative has worked and each representative’s bonus. In addition, you will create a nested lookup function to look up a person’s name and particular quarter to identify the sales for that person. Next, you will perform advanced database filtering and use summary database functions. Finally, you will complete an amortization table to build a small addition to your office complex.Your assistant created a spreadsheet that lists names, hire dates, quarterly sales, and total sales for 2018. You will calculate the number of years each representative has worked and each representative’s bonus. In addition, you will create a nested lookup function to look up a person’s name and particular quarter to identify the sales for that person. Next, you will perform advanced database filtering and use summary database functions. Finally, you will complete an amortization table to build a small addition to your office complex.
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 
Download and open the file named exploring_e07_grader_a1_Sales.xlsx, and then save the file as exploring_e07_grader_a1_Sales_LastFirst, replacing LastFirst with your name. 
0.000 
2 
On the Sales worksheet, enter a date function in cell C8 to calculate the number of years the first representative has worked for your company. Copy the function to the range C9:C20. 
7.000 
3 
On the Sales worksheet, enter a nested function in cell J8 of the Bonus column to display the bonus amount. If the employee sold $200,000 or more (cell J2) AND is International (cell I4), he or she earns a 5% (cell J4) bonus on his or her total annual sales; otherwise, the representative earns 3% (cell J3) of his or her total annual sales. Use relative and mixed (or absolute) references correctly in the nested function. Copy the function from J8 to the range J9:J20. 
7.000 
4 
Enter a nested lookup function in cell E4 that uses the cells E2 and E3 to return a specific sales record. For example, using the current data, you want the function to return the third quarter sales for Erica. 
7.000 
5 
Click the Database worksheet tab and enter conditions in the Criteria Range for Domestic sales reps that made 240000 or more in sales. Data function Tab and search criteria 
4.000 
6 
Perform an advanced filter based on the criteria range. Set the filter to copy the new data to the range A22:G22. 
8.000 
7 
In cell J7, enter a database function to calculate the number of reps meeting the criteria. Use the output range A22:G35 for the database argument in the function. 
7.000 
8 
In cell J8, enter a database function to calculate the highest total sales for records meeting the criteria. Use the output range A22:G35 for the database argument in the function. 
7.000 
9 
In cell J9, enter a database function to calculate the average sales for records meeting the criteria. Use the output range A22:G35 for the database argument in the function. 
7.000 
10 
Click the Addition worksheet tab, and then insert a formula in cell E2 to calculate the loan amount based on the loan parameters. 
4.000 
11 
In cell E5, enter a function to calculate the monthly payment. Modify the function to ensure that the result is a positive number. 
5.000 
12 
In cell E6, enter a function to calculate the total interest paid after five payments. Modify the function to ensure that the result is a positive number. The formula will result in an error until the loan amortization table is completed. 
7.000 
13 
In cell B11, create a relative reference to cell B7 and in cell C11, create a relative reference to cell E2. In cell C12, enter a relative reference to cell F11 and copy the formula to the range C13:C15. 
4.000 
14 
In cell B12, insert a nested DATE function to enter the payment date for the next month. Copy the function to the range B13:B15. 
7.000 
15 
In cell D11, enter the financial function to calculate the interest paid for the first payment period. The result should be a positive value. 
7.000 
16 
In cell E11, enter the financial function to calculate the principal payment for the first payment period. The result should be a positive value. 
7.000 
17 
In cell F11, subtract the principal payment in cell E11 from the beginning balance in cell C11. Copy the functions and formulas from the range D11:F11 to the range D12:F15. 
5.000 
18 
Save the file making sure the worksheets are in the following order: Sales, Database, and Addition. Close Excel. Submit the file 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
Download and open the file named exploring_e07_grader_a1_Sales.xlsx, and then save the file as exploring_e07_grader_a1_Sales_LastFirst, replacing LastFirst with your name.
0.000
2
On the Sales worksheet, enter a date function in cell C8 to calculate the number of years the first representative has worked for your company. Copy the function to the range C9:C20.
7.000
3
On the Sales worksheet, enter a nested function in cell J8 of the Bonus column to display the bonus amount. If the employee sold $200,000 or more (cell J2) AND is International (cell I4), he or she earns a 5% (cell J4) bonus on his or her total annual sales; otherwise, the representative earns 3% (cell J3) of his or her total annual sales. Use relative and mixed (or absolute) references correctly in the nested function. Copy the function from J8 to the range J9:J20.
7.000
4
Enter a nested lookup function in cell E4 that uses the cells E2 and E3 to return a specific sales record. For example, using the current data, you want the function to return the third quarter sales for Erica.
7.000
5
Click the Database worksheet tab and enter conditions in the Criteria Range for Domestic sales reps that made 240000 or more in sales. Data function Tab and search criteria
4.000
6
Perform an advanced filter based on the criteria range. Set the filter to copy the new data to the range A22:G22.
8.000
7
In cell J7, enter a database function to calculate the number of reps meeting the criteria. Use the output range A22:G35 for the database argument in the function.
7.000
8
In cell J8, enter a database function to calculate the highest total sales for records meeting the criteria. Use the output range A22:G35 for the database argument in the function.
7.000
9
In cell J9, enter a database function to calculate the average sales for records meeting the criteria. Use the output range A22:G35 for the database argument in the function.
7.000
10
Click the Addition worksheet tab, and then insert a formula in cell E2 to calculate the loan amount based on the loan parameters.
4.000
11
In cell E5, enter a function to calculate the monthly payment. Modify the function to ensure that the result is a positive number.
5.000
12
In cell E6, enter a function to calculate the total interest paid after five payments. Modify the function to ensure that the result is a positive number. The formula will result in an error until the loan amortization table is completed.
7.000
13
In cell B11, create a relative reference to cell B7 and in cell C11, create a relative reference to cell E2. In cell C12, enter a relative reference to cell F11 and copy the formula to the range C13:C15.
4.000
14
In cell B12, insert a nested DATE function to enter the payment date for the next month. Copy the function to the range B13:B15.
7.000
15
In cell D11, enter the financial function to calculate the interest paid for the first payment period. The result should be a positive value.
7.000
16
In cell E11, enter the financial function to calculate the principal payment for the first payment period. The result should be a positive value.
7.000
17
In cell F11, subtract the principal payment in cell E11 from the beginning balance in cell C11. Copy the functions and formulas from the range D11:F11 to the range D12:F15.
5.000
18
Save the file making sure the worksheets are in the following order: Sales, Database, and Addition. Close Excel. Submit the file as directed.
0.000
Total Points
100.000
1
Download and open the file named exploring_e07_grader_a1_Sales.xlsx, and then save the file as exploring_e07_grader_a1_Sales_LastFirst, replacing LastFirst with your name.
0.000
1
1
111
Download and open the file named exploring_e07_grader_a1_Sales.xlsx, and then save the file as exploring_e07_grader_a1_Sales_LastFirst, replacing LastFirst with your name.
Download and open the file named exploring_e07_grader_a1_Sales.xlsx, and then save the file as exploring_e07_grader_a1_Sales_LastFirst, replacing LastFirst with your name.
Download and open the file named exploring_e07_grader_a1_Sales.xlsx, and then save the file as exploring_e07_grader_a1_Sales_LastFirst, replacing LastFirst with your name.exploring_e07_grader_a1_Sales.xlsxexploring_e07_grader_a1_Sales_LastFirstLastFirst
0.000
0.000
0.000
2
On the Sales worksheet, enter a date function in cell C8 to calculate the number of years the first representative has worked for your company. Copy the function to the range C9:C20.
7.000
2
2
222
On the Sales worksheet, enter a date function in cell C8 to calculate the number of years the first representative has worked for your company. Copy the function to the range C9:C20.
On the Sales worksheet, enter a date function in cell C8 to calculate the number of years the first representative has worked for your company. Copy the function to the range C9:C20.
On the Sales worksheet, enter a date function in cell C8 to calculate the number of years the first representative has worked for your company. Copy the function to the range C9:C20.
7.000
7.000
7.000
3
On the Sales worksheet, enter a nested function in cell J8 of the Bonus column to display the bonus amount. If the employee sold $200,000 or more (cell J2) AND is International (cell I4), he or she earns a 5% (cell J4) bonus on his or her total annual sales; otherwise, the representative earns 3% (cell J3) of his or her total annual sales. Use relative and mixed (or absolute) references correctly in the nested function. Copy the function from J8 to the range J9:J20.
7.000
3
3
333
On the Sales worksheet, enter a nested function in cell J8 of the Bonus column to display the bonus amount. If the employee sold $200,000 or more (cell J2) AND is International (cell I4), he or she earns a 5% (cell J4) bonus on his or her total annual sales; otherwise, the representative earns 3% (cell J3) of his or her total annual sales. Use relative and mixed (or absolute) references correctly in the nested function. Copy the function from J8 to the range J9:J20.
On the Sales worksheet, enter a nested function in cell J8 of the Bonus column to display the bonus amount. If the employee sold $200,000 or more (cell J2) AND is International (cell I4), he or she earns a 5% (cell J4) bonus on his or her total annual sales; otherwise, the representative earns 3% (cell J3) of his or her total annual sales. Use relative and mixed (or absolute) references correctly in the nested function. Copy the function from J8 to the range J9:J20.
On the Sales worksheet, enter a nested function in cell J8 of the Bonus column to display the bonus amount. If the employee sold $200,000 or more (cell J2) AND is International (cell I4), he or she earns a 5% (cell J4) bonus on his or her total annual sales; otherwise, the representative earns 3% (cell J3) of his or her total annual sales. Use relative and mixed (or absolute) references correctly in the nested function. Copy the function from J8 to the range J9:J20. International
7.000
7.000
7.000
4
Enter a nested lookup function in cell E4 that uses the cells E2 and E3 to return a specific sales record. For example, using the current data, you want the function to return the third quarter sales for Erica.
7.000
4
4
444
Enter a nested lookup function in cell E4 that uses the cells E2 and E3 to return a specific sales record. For example, using the current data, you want the function to return the third quarter sales for Erica.
Enter a nested lookup function in cell E4 that uses the cells E2 and E3 to return a specific sales record. For example, using the current data, you want the function to return the third quarter sales for Erica.
Enter a nested lookup function in cell E4 that uses the cells E2 and E3 to return a specific sales record. For example, using the current data, you want the function to return the third quarter sales for Erica.
7.000
7.000
7.000
5
Click the Database worksheet tab and enter conditions in the Criteria Range for Domestic sales reps that made 240000 or more in sales. Data function Tab and search criteria
4.000
5
5
555
Click the Database worksheet tab and enter conditions in the Criteria Range for Domestic sales reps that made 240000 or more in sales. Data function Tab and search criteria
Click the Database worksheet tab and enter conditions in the Criteria Range for Domestic sales reps that made 240000 or more in sales. Data function Tab and search criteria
Click the Database worksheet tab and enter conditions in the Criteria Range for Domestic sales reps that made 240000 or more in sales. Data function Tab and search criteriaDomestic 240000
4.000
4.000
4.000
6
Perform an advanced filter based on the criteria range. Set the filter to copy the new data to the range A22:G22.
8.000
6
6
666
Perform an advanced filter based on the criteria range. Set the filter to copy the new data to the range A22:G22.
Perform an advanced filter based on the criteria range. Set the filter to copy the new data to the range A22:G22.
Perform an advanced filter based on the criteria range. Set the filter to copy the new data to the range A22:G22.
8.000
8.000
8.000
7
In cell J7, enter a database function to calculate the number of reps meeting the criteria. Use the output range A22:G35 for the database argument in the function.
7.000
7
7
777
In cell J7, enter a database function to calculate the number of reps meeting the criteria. Use the output range A22:G35 for the database argument in the function.
In cell J7, enter a database function to calculate the number of reps meeting the criteria. Use the output range A22:G35 for the database argument in the function.
In cell J7, enter a database function to calculate the number of reps meeting the criteria. Use the output range A22:G35 for the database argument in the function.
7.000
7.000
7.000
8
In cell J8, enter a database function to calculate the highest total sales for records meeting the criteria. Use the output range A22:G35 for the database argument in the function.
7.000
8
8
888
In cell J8, enter a database function to calculate the highest total sales for records meeting the criteria. Use the output range A22:G35 for the database argument in the function.
In cell J8, enter a database function to calculate the highest total sales for records meeting the criteria. Use the output range A22:G35 for the database argument in the function.
In cell J8, enter a database function to calculate the highest total sales for records meeting the criteria. Use the output range A22:G35 for the database argument in the function.
7.000
7.000
7.000
9
In cell J9, enter a database function to calculate the average sales for records meeting the criteria. Use the output range A22:G35 for the database argument in the function.
7.000
9
9
999
In cell J9, enter a database function to calculate the average sales for records meeting the criteria. Use the output range A22:G35 for the database argument in the function.
In cell J9, enter a database function to calculate the average sales for records meeting the criteria. Use the output range A22:G35 for the database argument in the function.
In cell J9, enter a database function to calculate the average sales for records meeting the criteria. Use the output range A22:G35 for the database argument in the function.
7.000
7.000
7.000
10
Click the Addition worksheet tab, and then insert a formula in cell E2 to calculate the loan amount based on the loan parameters.
4.000
10
10
101010
Click the Addition worksheet tab, and then insert a formula in cell E2 to calculate the loan amount based on the loan parameters.
Click the Addition worksheet tab, and then insert a formula in cell E2 to calculate the loan amount based on the loan parameters.
Click the Addition worksheet tab, and then insert a formula in cell E2 to calculate the loan amount based on the loan parameters.
4.000
4.000
4.000
11
In cell E5, enter a function to calculate the monthly payment. Modify the function to ensure that the result is a positive number.
5.000
11
11
111111
In cell E5, enter a function to calculate the monthly payment. Modify the function to ensure that the result is a positive number.
In cell E5, enter a function to calculate the monthly payment. Modify the function to ensure that the result is a positive number.
In cell E5, enter a function to calculate the monthly payment. Modify the function to ensure that the result is a positive number.
5.000
5.000
5.000
12
In cell E6, enter a function to calculate the total interest paid after five payments. Modify the function to ensure that the result is a positive number. The formula will result in an error until the loan amortization table is completed.
7.000
12
12
121212
In cell E6, enter a function to calculate the total interest paid after five payments. Modify the function to ensure that the result is a positive number. The formula will result in an error until the loan amortization table is completed.
In cell E6, enter a function to calculate the total interest paid after five payments. Modify the function to ensure that the result is a positive number. The formula will result in an error until the loan amortization table is completed.
In cell E6, enter a function to calculate the total interest paid after five payments. Modify the function to ensure that the result is a positive number. The formula will result in an error until the loan amortization table is completed.
7.000
7.000
7.000
13
In cell B11, create a relative reference to cell B7 and in cell C11, create a relative reference to cell E2. In cell C12, enter a relative reference to cell F11 and copy the formula to the range C13:C15.
4.000
13
13
131313
In cell B11, create a relative reference to cell B7 and in cell C11, create a relative reference to cell E2. In cell C12, enter a relative reference to cell F11 and copy the formula to the range C13:C15.
In cell B11, create a relative reference to cell B7 and in cell C11, create a relative reference to cell E2. In cell C12, enter a relative reference to cell F11 and copy the formula to the range C13:C15.
In cell B11, create a relative reference to cell B7 and in cell C11, create a relative reference to cell E2. In cell C12, enter a relative reference to cell F11 and copy the formula to the range C13:C15.
B7E2F11
4.000
4.000
4.000
14
In cell B12, insert a nested DATE function to enter the payment date for the next month. Copy the function to the range B13:B15.
7.000
14
14
141414
In cell B12, insert a nested DATE function to enter the payment date for the next month. Copy the function to the range B13:B15.
In cell B12, insert a nested DATE function to enter the payment date for the next month. Copy the function to the range B13:B15.
In cell B12, insert a nested DATE function to enter the payment date for the next month. Copy the function to the range B13:B15.
DATE
7.000
7.000
7.000
15
In cell D11, enter the financial function to calculate the interest paid for the first payment period. The result should be a positive value.
7.000
15
15
151515
In cell D11, enter the financial function to calculate the interest paid for the first payment period. The result should be a positive value.
In cell D11, enter the financial function to calculate the interest paid for the first payment period. The result should be a positive value.
In cell D11, enter the financial function to calculate the interest paid for the first payment period. The result should be a positive value.
7.000
7.000
7.000
16
In cell E11, enter the financial function to calculate the principal payment for the first payment period. The result should be a positive value.
7.000
16
16
161616
In cell E11, enter the financial function to calculate the principal payment for the first payment period. The result should be a positive value.
In cell E11, enter the financial function to calculate the principal payment for the first payment period. The result should be a positive value.
In cell E11, enter the financial function to calculate the principal payment for the first payment period. The result should be a positive value.
7.000
7.000
7.000
17
In cell F11, subtract the principal payment in cell E11 from the beginning balance in cell C11. Copy the functions and formulas from the range D11:F11 to the range D12:F15.
5.000
17
17
171717
In cell F11, subtract the principal payment in cell E11 from the beginning balance in cell C11. Copy the functions and formulas from the range D11:F11 to the range D12:F15.
In cell F11, subtract the principal payment in cell E11 from the beginning balance in cell C11. Copy the functions and formulas from the range D11:F11 to the range D12:F15.
In cell F11, subtract the principal payment in cell E11 from the beginning balance in cell C11. Copy the functions and formulas from the range D11:F11 to the range D12:F15.
5.000
5.000
5.000
18
Save the file making sure the worksheets are in the following order: Sales, Database, and Addition. Close Excel. Submit the file as directed.
0.000
18
18
181818
Save the file making sure the worksheets are in the following order: Sales, Database, and Addition. Close Excel. Submit the file as directed.
Save the file making sure the worksheets are in the following order: Sales, Database, and Addition. Close Excel. Submit the file as directed.
Save the file making sure the worksheets are in the following order: Sales, Database, and Addition. Close Excel. Submit the file 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