1. Suppose cell L2 contains a formula for the number of payments that would have to have been made on the loan for it to be current as of the reporting date. The following formula, applied to the first loan, is used to represent loan currency as of the reporting date. Copying this formula for all the loans would give results that: = H2/L2

Question options:

1)	give the correct loan currency for all loans

2)	understate or overstate loan currency for different loans

3)	understate loan currency for some loans

4)	overstate loan currency for some loans

Hide Feedback

Feedback: Because the formula does not set calculated loan currencies that are greater than one to one, loans for which the loan holder has made advance payments will have a calculated loan currency that is greater than one. The correct formula is: = IF((H2/L2<=1), H2/L2, 1)

2.Suppose there are hundreds of dealers and hundreds of thousands of loans. The best approach for achieving the objective of showing the analysis by dealerID and vehicle category is to:

Question options:

1)	add the dealer location field to the pivot table that shows the dealerID values and, in a separate pivot table, add the category values

2)	create a new pivot table that includes values for the dealerID, the dealer location, and the category values

3)	join the loan and sales tables on loanID and sales and acquisitions tables on vehicleID and then perform the required analysis

4)	set up two pivot tables, one by dealerID with dealer location concatenated to it, and one by the category values

Hide Feedback

No configuration of pivot tables can overcome the inherent limitation of spreadsheets being unable to join information in separate worksheets on a primary key. To achieve the objective, join the loan and sales tables on loanID and the acquisitions and sales tables on vehicleID and then perform the required analysis with database querying.

Please, find right the answers, and you can see the feedbacks. above answers are wrong answers.