Excel Quiz
Check what you have learned in this Excel tutorial. Choose an answer for each question to see if you are right.
Tips
- Open Excel and try each formula yourself if you are unsure
- Read the explanation after each answer
- Go back to a chapter if you miss a question
The questions use this small sheet:
| A | B | C | |
|---|---|---|---|
| 1 | Name | Marks | City |
| 2 | Ali | 72 | Karachi |
| 3 | Ayesha | 88 | Lahore |
| 4 | Bilal | 45 | Karachi |
For example, this formula counts the students from Karachi:
Example
=COUNTIF(C2:C4, "Karachi")| Result |
|---|
| 2 |
Questions
Exercise
What does =SUM(B2:B4) return for the sheet above?
Exercise
What is the result of =(2+3)*4?
Exercise
You copy =B2*$F$1 from row 2 down to row 3. What does the formula become?
Exercise
Which function counts cells that are not empty, including text?
Exercise
What does =IF(B4>=50, "Pass", "Fail") show for Bilal?
Exercise
Which formula joins the name and city as "Ali - Karachi"?
Exercise
Which formula returns Ayesha's city by searching for her name?
Exercise
A cell shows #DIV/0!. What does it mean?
Exercise
Which shortcut quickly inserts a SUM formula below a column of numbers?
Exercise
Which tool summarises thousands of rows by category using drag and drop?