Question

You are required to prepare a rank list for admission to the B.Com course. The Index mark is calculated as follows. Sum of mark secured in Plus 2, Mark obtained in Accountancy and -25% of Mark obtained in Business studies. Give the entries in Libre Office Calc to get the index mark.

Answer 1

• A1 → Total Mark 
• B1 → Mark in Accountancy
• C1 → Mark in Business Studies 
• D1 → Index Mark 
• A2 → Enter the Marks 
• B2 → Enter the Marks 
• C2 → Enter the Marks 
• D2 → =A2 + B2 + (C2 * 25%)