MCQ (Multiple Choice Questions)
1. In Excel, rows are identified by:
A) Letters
B) Numbers
C) Symbols
D) Colors
2. The intersection of a row and a column is called:
A) Box
B) Table
C) Cell
D) Sheet
3. Which symbol must every Excel formula start with?
A) +
B) @
C) =
D) #
4. The formula =SUM(A1:A10) is used to:
A) Find the average
B) Count the cells
C) Add values from A1 to A10
D) Find the maximum value
5. Which function is used to calculate the average?
A) SUM
B) MEAN
C) AVG
D) AVERAGE
6. Conditional Formatting is mainly used to:
A) Change data values
B) Delete data
C) Highlight data visually
D) Sort data
7. Which Excel function is used to find the highest value?
A) MIN
B) MAX
C) TOP
D) HIGH
8. What happens when you drag the fill handle down a formula cell?
A) The formula is deleted
B) The formula is copied
C) The value is fixed
D) The worksheet is protected
9. Which symbol is used for absolute cell referencing?
A) #
B) %
C) $
D) &
10. Pivot Tables are mainly used to:
A) Enter data
B) Format cells
C) Analyze and summarize data
D) Draw pictures
Short Answer
1. Define a cell in Microsoft Excel.
A cell is the intersection of a row and a column where data is entered in Excel.
2. What is the difference between rows and columns?
Rows are horizontal and identified by numbers, while columns are vertical and identified
by letters.
3. Write the formula used to calculate the sum of cells A1 to A10.
=SUM(A1:A10)
4. What does the AVERAGE function do?
It calculates the mean (average) of a selected range of numbers.
5. Why do Excel formulas always start with “=” ?
To tell Excel that the entered value is a formula and needs to be calculated.
6. What is Conditional Formatting?
It is a feature used to visually format cells based on specific conditions without changing
the data.
7. Explain the use of the IF function in Excel.
The IF function checks a condition and returns one value if the condition is true and
another value if it is false.
8. What is meant by relative cell referencing?
It means that cell references change automatically when a formula is copied to another
cell.
9. Why is absolute referencing used in formulas?
To keep a specific cell reference fixed when copying a formula, using the $ symbol.
10. What is the main purpose of charts in Excel?
To present data visually and make comparisons and trends easier to understand.
(Numerical / Practical)
1. The mid-session marks of 10 students are stored in cells A1:A10.
Write the Excel formula to calculate:
a) The total marks
b) The average marks
Solution:
a) Formula to calculate the total marks:
=SUM(A1:A10)
b) Formula to calculate the average marks:
=AVERAGE(A1:A10)
2. If the mid-session mark is in cell A2 (40%) and the final exam mark is in cell B2 (60),
write the Excel formula to calculate the total mark in cell C2.
Solution:
Mid-session mark is in cell A2 (40%)
Final exam mark is in cell B2 (60%)
The Excel formula in cell C2 is:
=A2*0.4 + B2*0.6
3. Marks of students are stored in cells A1:[Link] the Formula to find:
a) Total marks
b) Maximum mark
c) Minimum mark
Solution:
a) =SUM(A1:A10)
b) =MAX(A1:A10)
c) =MIN(A1:A10)
4. The average of marks stored in cells B1:B10 is required.
Solution: =AVERAGE(B1:B10)
5. If the mid-session mark is in A2 and the final exam mark is in B2,
and both have equal weight (50% each), write the formula in C2.
Solution: =A2*0.5 + B2*0.5
6. Final exam marks are in column B.
Write an IF formula in C2 to display:
“Pass” if the mark is 60 or more
“Fail” if it is less than 60
Solution:
=IF(B2>=60,"Pass","Fail")
7. Marks are stored in A1:A10.
Write the formula to calculate the total using AutoSum manually.
Solution:
=SUM(A1:A10)
8. The mid-session weight is stored in cell D1 and the final exam weight in E1.
Mid mark in A2, Final mark in B2.
Write the formula using absolute referencing.
Solution:
=A2*$D$1 + B2*$E$1
9. Write the formula to calculate the total of cells C1:C5.
Solution:
=SUM(C1:C5)