Scribd
Upload
3 views5 pages

Excel Practical Questions

The document outlines a series of practical Excel tasks designed to enhance data entry and calculation skills. It includes exercises on basic data entry, calculating totals, averages, and using functions like COUNT, MAX, and MIN, as well as formatting cells and performing worksheet operations. Additionally, it features a mini project for creating a student report card and real-life applications for tracking daily expenses.

Uploaded by

souvikc1982
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
3 views5 pages

Excel Practical Questions

The document outlines a series of practical Excel tasks designed to enhance data entry and calculation skills. It includes exercises on basic data entry, calculating totals, averages, and using functions like COUNT, MAX, and MIN, as well as formatting cells and performing worksheet operations. Additionally, it features a mini project for creating a student report card and real-life applications for tracking daily expenses.

Uploaded by

souvikc1982
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

EXCEL PRACTICAL QUESTIONS

🔹 PRACTICAL 1: Basic Data Entry &


Total
🎯 Task:

Create the following table:

A (Name) B (Marks)
Ravi 45
Sita 55
Aman 65
Neha 75

✅ Questions:

1. Enter the data in Excel


2. Calculate Total Marks using formula
3. Save file as [Link]

👉 Expected Formula:

=SUM(B2:B5)

🔹 PRACTICAL 2: Average Marks


🎯 Task:

Using previous data:

1. Find Average Marks

👉 Formula:

=AVERAGE(B2:B5)

2. Write result in a new cell


🔹 PRACTICAL 3: Maximum & Minimum
🎯 Task:

1. Find Highest Marks


2. Find Lowest Marks

👉 Formulas:

=MAX(B2:B5)
=MIN(B2:B5)

🔹 PRACTICAL 4: Using COUNT Function


🎯 Task:

1. Count how many students are present

👉 Formula:

=COUNT(B2:B5)

🔹 PRACTICAL 5: Copying Formula


🎯 Task:

Create:

A B C
10 20 =A1+B1

Steps:

1. Write formula in C1
2. Copy formula to C2, C3

👉 Observe how values change automatically

🔹 PRACTICAL 6: Cell Referencing


🎯 Task:
1. Enter:
o A1 = 5
o B1 = 10
2. Write formula:

=A1+B1

3. Copy formula to next row

👉 Question:

 What happens to formula?

🔹 PRACTICAL 7: Formatting Cells


🎯 Task:

1. Enter any data


2. Apply:
o Bold
o Center alignment
o Borders

🔹 PRACTICAL 8: Worksheet Operations


🎯 Task:

1. Insert a new worksheet


2. Rename it as TestSheet
3. Delete another sheet

🔹 PRACTICAL 9: Create a Bill


🎯 Task:

Item Price Quantity Total


Pen 10 2 ?
Book 50 3 ?

Questions:
1. Calculate total for each item

👉 Formula:

=B2*C2

2. Find Grand Total

🔹 PRACTICAL 10: Range Selection


🎯 Task:

1. Select:
o Entire row
o Entire column
o Entire sheet

👉 Write shortcut keys used

🔹 PRACTICAL 11: Error Finding


🎯 Task:

Identify wrong formulas:

1. SUM(A1:A5)
2. =A1+B1
3. =SUM(A1:A5)
4. A1+B1

👉 Correct the wrong ones

🔹 PRACTICAL 12: Mini Project


(IMPORTANT)
🎯 Task: Student Report Card

Create:
Name Maths Science English Total Average

Questions:

1. Enter marks
2. Calculate Total
3. Calculate Average
4. Highlight highest marks

🔹 PRACTICAL 13: Real-Life Application


🎯 Task: Daily Expenses

Day Expense
Mon 100
Tue 150
Wed 200

Questions:

1. Find total expense


2. Find average expense

🔹 PRACTICAL 14: Advanced Thinking


Questions:

1. Why is Excel better than calculator?


2. What happens if you copy formula with relative reference?

You might also like