EXCEL PRACTICAL QUESTIONS - 1

EXCEL PRACTICAL QUESTIONS
BASIC FORMULAS, SUM, AVERAGE, IF, SUMIF, COUNTIF

WORKSHOP - 1
Create the following data sheet in MS Excel.

1. Write a formula to calculate all the allowances by basic salary.

2. Write a formula to calculate ESI 2% and PF 12.5% by basic salary.

3. Calculate 'Net salary' by appropriate formula.

WORKSHOP - 2

Create the following data sheet in MS Excel.

1. In the following Excel data sheet, find the grades by help of IF formula with the following conditions.

Condition 1: If the avg >= 33 and avg <= 50
C Grade

Condition 2: If the avg > 50 and avg <= 75

B Grade

Condition 3: If the avg > 75 and avg <= 100

A Grade

Condition 4: If the avg < 33
Fail

LEARN IF FORMULA IN EXCEL

WORKSHOP - 3
Create the following data sheet in MS Excel.

In the following Excel data sheet, perform the below operations with the help of CountIf formula.

1. Count total number of students in the English subject.

2. Count the total number of students, who got distinction in Maths.

3. Count the number of students who marks between 60 - 80 in Science subject.  

LEARN COUNTIF FORMULA IN EXCEL


WORKSHOP - 4

Create the following data sheet in MS Excel.

1. Calculate sum of total Sales amount with the help of SumIF formula.

2. Calculate sum of total Sales and Purchase amount with the help of SumIF formula.

LEARN SUMIF AND SUMIFS FORMULA

PRACTICE QUESTION (SET - 1)

PRACTICE QUESTION (SET - 2)

PRACTICE QUESTION (SET - 3)

PRACTICE QUESTION (SET - 4)

PRACTICE QUESTION (SET - 5)

HOME