Excel Test: Executive, Customer Support & Product Sourcing

Dear applicants,

Please go through the following problems/situations and solve these using excel and forward the solution as instructed to the < [email protected] > by 9:00 AM of Thursday, April 30th, 2015.   And we hope to see you on the upcoming Interview session.   Thank you very much
    Kind regards.
HR, Bismillah technologies Limited
Phone: +880 1776 300 900
House# 21/C, 1st Floor#2, Zigatola
(Near Japan Bangladesh Freind Ship Hospital,
Zigatola Bus Stand)
Dhanmondi, Dhaka-1205.
    *Note you can seek help from Professor Google on specific formula. In that case let us know which formula you have searched and what was the "key word" you have used for that search.