1. How is the cell at column B, row 3 addressed?
2. What does every Excel formula start with?
3. A number you typed sits on the left of its cell. This means:
4. Formatting 0.5 as a percentage results in:
5. What is the difference between relative and absolute references?
6. To keep E1 fixed while filling =C1*E1 down, you write:
7. What does =SUM(A1:A10) add?
8. To total only the rows where region is Nairobi, use:
9. What does =IF(B2>=50, "Pass", "Fail") do?
10. IFERROR is used to:
11. What does a lookup function do?
12. In VLOOKUP, ending with FALSE means:
13. What is the modern, more robust replacement for VLOOKUP?
14. The critical rule when sorting is:
15. The main benefit of an Excel Table (Ctrl+T) is:
16. A drop-down list for data entry ensures:
17. Before using Remove Duplicates you should:
18. A pivot table is for:
19. Which chart best shows change over time?
20. How is Excel skill usually verified in hiring?
