Daily MIS Practice

Seven checked mini-challenges rotate at midnight Asia/Kolkata. Practice formulas free, with an optional timer and device-only history.

Reconcile collections

Total the collections in B2:B4.

Sample cells: A1 = Branch; B1 = Collection; A2 = Mumbai; B2 = 62000; A3 = Pune; B3 = 49000; A4 = Nashik; B4 = 51000

Achievement against plan

Calculate collection B2 divided by target C2. Return a ratio, not a percentage multiplied by 100.

Sample cells: A1 = Branch; B1 = Collection; C1 = Target; A2 = Mumbai; B2 = 62000; C2 = 50000

Overdue cases

Count DPD values above 30 in B2:B5.

Sample cells: A1 = Loan; B1 = DPD; A2 = L1; B2 = 0; A3 = L2; B3 = 31; A4 = L3; B4 = 90; A5 = L4; B5 = 12

Branch collections

Sum Mumbai collections using branch names A2:A4 and amounts B2:B4.

Sample cells: A1 = Branch; B1 = Collection; A2 = Mumbai; B2 = 62000; A3 = Pune; B3 = 49000; A4 = Mumbai; B4 = 58000

Average ticket

Calculate the average of the three amounts in B2:B4.

Sample cells: A1 = Case; B1 = Amount; A2 = C1; B2 = 30000; A3 = C2; B3 = 45000; A4 = C3; B4 = 60000

Recover a blank denominator

Return zero when dividing B2 by C2 produces an error; otherwise return the ratio.

Sample cells: A1 = Branch; B1 = Collection; C1 = Target; A2 = New branch; B2 = 0; C2 = 0

Priority overdue balance

Sum B2:B4 only for rows with DPD C2:C4 above 90.

Sample cells: A1 = Loan; B1 = Balance; C1 = DPD; A2 = L1; B2 = 120000; C2 = 91; A3 = L2; B3 = 90000; C3 = 90; A4 = L3; B4 = 50000; C4 = 120

Interactive practice runs in your browser.