Page 412 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

EXERCISE 68 : Use array formula

Objectives

At the end of this exercise you shall be able to
• use various array formula in your tasks.

Requirements

Tools/Materials

• PC/Laptop with Windows OS
• MS Excel 2013 or Higher

Procedure

TASK 1: Calculating Total Marks of Students
In our first task we’ll calculate the total marks for each student using an array formula in Excel. It’s simple and
easy. Just follow along.

Step 1: In Office 365, Select cell E5 and enter the following formula.
=C5:C14+D5:D14

397
CITS : IT & ITES - Computer Software Application - Exercise 67