The Excel bank
Excel Questions
18 graded Excel questions themed around companies you'll actually interview at in the region. Solve them right here, in your browser.
18 of 18
easyApply a fixed cashback rate down a columnBoost · aggregationFree→easyAverage downtime per incident, without erroring on zero incidentsPetronas · logicalFree→easyClassify a member's loyalty tier by monthly spendSetel · logicalFree→easyExtract the department code from a Padini SKUNewPadini · textFree→easyFind the last day of a booking's check-in monthTraveloka · dateFree→easyFlag Carousell listings that were posted more than onceCarousell · aggregationFree→easyLook up a product's price by SKULazada · lookupFree→easyTotal fare for completed trips in one cityGrab · aggregationFree→mediumBuild a two-way cross-tab of Boost wallet top-upsBoost · aggregationBasic→mediumBusiness days between booking and departureAirAsia · dateBasic→mediumClean a messy discount label into a usable decimalZalora · cleaningFree→mediumExtract the outlet code from an order IDFoodpanda · textFree→mediumFind a branch code by city — a leftward lookupCIMB · lookupFree→hardAssign a credit tier from a score, using a range lookupGXBank · lookupBasic→hardClean a messy status column, then roll it up by branchMr DIY · cleaningBasic→hardCompute a loan's exact tenure in complete monthsRHB Bank · dateBasic→hardFlag duplicate DBS Bank transactions by customer and date togetherDBS Bank · aggregationBasic→hardTop Electronics sellers by sales, filtered and sorted in one formulaTokopedia · lookupBasic→