Citco Interview Question

Asked related some excel formulas