EXCEL CRASH COURSE
EXAM 2025
1. Question:
You have a dataset with the following columns: Name, Age, and Salary. How would
you calculate the average salary?
Answer: Use the AVERAGE function. Example formula:
=AVERAGE(C2:C10)
(where C2:C10 is the range of salary values).
2. Question:
,What formula would you use to find the highest number in a list of values from A1 to
A10?
Answer: Use the MAX function. Example formula:
=MAX(A1:A10)
3. Question:
You have a range of data and want to sum only the values greater than 100. Which
function can you use?
Answer: Use the SUMIF function. Example formula:
=SUMIF(A1:A10, ">100")
4. Question:
If you want to combine text from cells A1 and B1 into one cell with a space in
between, which formula would you use?
Answer: Use the CONCATENATE function (or the "&" operator). Example formula:
=A1 & " " & B1
or
=CONCATENATE(A1, " ", B1)
5. Question:
What would the formula =IF(A1 > 10, "Yes", "No") return if A1 contains the value 12?
Answer: It will return "Yes" because 12 is greater than 10.
6. Question:
How do you freeze the top row in Excel to keep it visible while scrolling?
Answer: Go to the "View" tab, then click "Freeze Panes," and select "Freeze Top
Row."
,7. Question:
Which Excel function can you use to count the number of non-empty cells in a range
from B1 to B10?
Answer: Use the COUNTA function. Example formula:
=COUNTA(B1:B10)
8. Question:
You have the value "2025-01-28" in cell A1. Which function would you use to extract
the year from this date?
Answer: Use the YEAR function. Example formula:
=YEAR(A1)
9. Question:
What shortcut key is used to copy data in Excel?
Answer: Ctrl + C
10. Question:
Which Excel feature allows you to automatically fill a range of cells with data based
on a pattern?
Answer: Use the AutoFill feature by dragging the fill handle (a small square at the
bottom-right corner of a selected cell).
11. Question:
What function would you use to look up a value in a vertical list and return a
corresponding value from another column?
Answer: Use the VLOOKUP function. Example formula:
, =VLOOKUP(A1, B1:C10, 2, FALSE)
12. Question:
How do you remove duplicate values from a dataset in Excel?
Answer: Go to the "Data" tab, click "Remove Duplicates," and select the columns
where duplicates should be checked.
13. Question:
Which formula would you use to find the number of cells in the range A1 to A10 that
contain the value "Apple"?
Answer: Use the COUNTIF function. Example formula:
=COUNTIF(A1:A10, "Apple")
14. Question:
What is the shortcut key to undo an action in Excel?
Answer: Ctrl + Z
15. Question:
If you want to display "Pass" if the value in cell A1 is greater than or equal to 50,
otherwise display "Fail," which function would you use?
Answer: Use the IF function. Example formula:
=IF(A1 >= 50, "Pass", "Fail")
16. Question:
What is the function to calculate the average of a range of cells that meet a specific
condition?
Answer: Use the AVERAGEIF function. Example formula:
EXAM 2025
1. Question:
You have a dataset with the following columns: Name, Age, and Salary. How would
you calculate the average salary?
Answer: Use the AVERAGE function. Example formula:
=AVERAGE(C2:C10)
(where C2:C10 is the range of salary values).
2. Question:
,What formula would you use to find the highest number in a list of values from A1 to
A10?
Answer: Use the MAX function. Example formula:
=MAX(A1:A10)
3. Question:
You have a range of data and want to sum only the values greater than 100. Which
function can you use?
Answer: Use the SUMIF function. Example formula:
=SUMIF(A1:A10, ">100")
4. Question:
If you want to combine text from cells A1 and B1 into one cell with a space in
between, which formula would you use?
Answer: Use the CONCATENATE function (or the "&" operator). Example formula:
=A1 & " " & B1
or
=CONCATENATE(A1, " ", B1)
5. Question:
What would the formula =IF(A1 > 10, "Yes", "No") return if A1 contains the value 12?
Answer: It will return "Yes" because 12 is greater than 10.
6. Question:
How do you freeze the top row in Excel to keep it visible while scrolling?
Answer: Go to the "View" tab, then click "Freeze Panes," and select "Freeze Top
Row."
,7. Question:
Which Excel function can you use to count the number of non-empty cells in a range
from B1 to B10?
Answer: Use the COUNTA function. Example formula:
=COUNTA(B1:B10)
8. Question:
You have the value "2025-01-28" in cell A1. Which function would you use to extract
the year from this date?
Answer: Use the YEAR function. Example formula:
=YEAR(A1)
9. Question:
What shortcut key is used to copy data in Excel?
Answer: Ctrl + C
10. Question:
Which Excel feature allows you to automatically fill a range of cells with data based
on a pattern?
Answer: Use the AutoFill feature by dragging the fill handle (a small square at the
bottom-right corner of a selected cell).
11. Question:
What function would you use to look up a value in a vertical list and return a
corresponding value from another column?
Answer: Use the VLOOKUP function. Example formula:
, =VLOOKUP(A1, B1:C10, 2, FALSE)
12. Question:
How do you remove duplicate values from a dataset in Excel?
Answer: Go to the "Data" tab, click "Remove Duplicates," and select the columns
where duplicates should be checked.
13. Question:
Which formula would you use to find the number of cells in the range A1 to A10 that
contain the value "Apple"?
Answer: Use the COUNTIF function. Example formula:
=COUNTIF(A1:A10, "Apple")
14. Question:
What is the shortcut key to undo an action in Excel?
Answer: Ctrl + Z
15. Question:
If you want to display "Pass" if the value in cell A1 is greater than or equal to 50,
otherwise display "Fail," which function would you use?
Answer: Use the IF function. Example formula:
=IF(A1 >= 50, "Pass", "Fail")
16. Question:
What is the function to calculate the average of a range of cells that meet a specific
condition?
Answer: Use the AVERAGEIF function. Example formula:
