Q1. We are instructed to prepare a dashboard of the queries to have all information in a single sheet.

A. Present data in visualized form.

B. Use progress charts, conditional charts and infographics to make visualization attractive.

C. Also automize the visualization using slicers ,timeline and sparklines(if necessary)

D. Also besides the dashboard create another sheet to have all the summary data in a single sheet.

Q. Mr. X took a loan of Rs 80,000 payable in 10 semi-annual instalments, rate of interest being 8% p.a. compounded semi-annually.

Find: A. The amount of each instalment

B. Loan outstanding after 4th payment

C. Interest component of 5th payment and