EXCEL CRASH COURSE EXAM 2026 LATEST VERSION FROM WALL STREET
QUESTIONS AND 100% CORRECT ANSWERS (BRAND NEW!!)/WSP EXCEL CRASH
COURSE
1. What is Microsoft Excel primarily used for?
☑ A. Data analysis and calculations
☐ B. Graphic design
☐ C. Video editing
☐ D. Web development
Rationale: Excel is designed for organising, analysing, and calculating data.
2. What is a cell in Excel?
☑ A. The intersection of a row and a column
☐ B. A worksheet
☐ C. A workbook
☐ D. A formula
Rationale: Each cell holds data and is identified by a column letter and row number.
3. Which symbol must all Excel formulas begin with?
☑ A. =
☐ B. +
☐ C. #
☐ D. @
Rationale: Excel recognises formulas by the equals sign.
4. Which function is used to add numbers in Excel?
☑ A. SUM
☐ B. ADD
☐ C. TOTAL
☐ D. PLUS
Rationale: SUM adds values in selected cells.
5. Which function finds the average of values?
☑ A. AVERAGE
☐ B. MEAN
☐ C. MID
,☐ D. COUNT
Rationale: AVERAGE calculates the mean of numbers.
6. What does the COUNT function do?
☑ A. Counts cells containing numbers
☐ B. Counts text cells
☐ C. Adds numbers
☐ D. Finds maximum value
Rationale: COUNT only counts numeric entries.
7. Which function counts non-empty cells?
☑ A. COUNTA
☐ B. COUNT
☐ C. COUNTBLANK
☐ D. SUM
Rationale: COUNTA counts all non-empty cells.
8. What does COUNTBLANK do?
☑ A. Counts empty cells
☐ B. Counts text cells
☐ C. Deletes cells
☐ D. Hides cells
Rationale: COUNTBLANK counts blank cells.
9. Which function returns the highest value?
☑ A. MAX
☐ B. TOP
☐ C. HIGH
☐ D. LARGE
Rationale: MAX identifies the largest number.
10. Which function returns the lowest value?
☑ A. MIN
☐ B. LOW
☐ C. SMALL
☐ D. BOTTOM
Rationale: MIN finds the smallest number.
,11. What does the IF function do?
☑ A. Performs logical tests
☐ B. Adds numbers
☐ C. Formats cells
☐ D. Sorts data
Rationale: IF returns different results based on a condition.
12. Which formula tests if A1 is greater than 10?
☑ A. =IF(A1>10,"Yes","No")
☐ B. =IF(A1<10,"Yes","No")
☐ C. =IF(A1=10,"Yes","No")
☐ D. =IF(A1>=100,"Yes","No")
Rationale: Correct logical comparison is used.
13. Which symbol is used for absolute cell reference?
☑ A. $
☐ B. &
☐ C. #
☐ D. !
Rationale: $ locks rows or columns in formulas.
14. What does $A$1 mean?
☑ A. Both row and column are fixed
☐ B. Only row is fixed
☐ C. Only column is fixed
☐ D. Cell is hidden
Rationale: Absolute reference prevents movement when copied.
15. What does relative cell referencing do?
☑ A. Changes references when copied
☐ B. Locks cells
☐ C. Deletes formulas
☐ D. Formats cells
Rationale: Relative references adjust automatically.
, 16. Which function looks up data vertically?
☑ A. VLOOKUP
☐ B. HLOOKUP
☐ C. MATCH
☐ D. INDEX
Rationale: VLOOKUP searches down columns.
17. Which function looks up data horizontally?
☑ A. HLOOKUP
☐ B. VLOOKUP
☐ C. FIND
☐ D. SEARCH
Rationale: HLOOKUP searches across rows.
18. What does the CONCAT function do?
☑ A. Joins text together
☐ B. Splits text
☐ C. Counts characters
☐ D. Formats numbers
Rationale: CONCAT combines text strings.
19. Which function finds text within a cell (case-sensitive)?
☑ A. FIND
☐ B. SEARCH
☐ C. LOOKUP
☐ D. MATCH
Rationale: FIND distinguishes uppercase and lowercase.
20. Which function finds text but is not case-sensitive?
☑ A. SEARCH
☐ B. FIND
☐ C. MID
☐ D. LEFT
Rationale: SEARCH ignores case differences.
21. What does the LEFT function do?
☑ A. Extracts text from the left
QUESTIONS AND 100% CORRECT ANSWERS (BRAND NEW!!)/WSP EXCEL CRASH
COURSE
1. What is Microsoft Excel primarily used for?
☑ A. Data analysis and calculations
☐ B. Graphic design
☐ C. Video editing
☐ D. Web development
Rationale: Excel is designed for organising, analysing, and calculating data.
2. What is a cell in Excel?
☑ A. The intersection of a row and a column
☐ B. A worksheet
☐ C. A workbook
☐ D. A formula
Rationale: Each cell holds data and is identified by a column letter and row number.
3. Which symbol must all Excel formulas begin with?
☑ A. =
☐ B. +
☐ C. #
☐ D. @
Rationale: Excel recognises formulas by the equals sign.
4. Which function is used to add numbers in Excel?
☑ A. SUM
☐ B. ADD
☐ C. TOTAL
☐ D. PLUS
Rationale: SUM adds values in selected cells.
5. Which function finds the average of values?
☑ A. AVERAGE
☐ B. MEAN
☐ C. MID
,☐ D. COUNT
Rationale: AVERAGE calculates the mean of numbers.
6. What does the COUNT function do?
☑ A. Counts cells containing numbers
☐ B. Counts text cells
☐ C. Adds numbers
☐ D. Finds maximum value
Rationale: COUNT only counts numeric entries.
7. Which function counts non-empty cells?
☑ A. COUNTA
☐ B. COUNT
☐ C. COUNTBLANK
☐ D. SUM
Rationale: COUNTA counts all non-empty cells.
8. What does COUNTBLANK do?
☑ A. Counts empty cells
☐ B. Counts text cells
☐ C. Deletes cells
☐ D. Hides cells
Rationale: COUNTBLANK counts blank cells.
9. Which function returns the highest value?
☑ A. MAX
☐ B. TOP
☐ C. HIGH
☐ D. LARGE
Rationale: MAX identifies the largest number.
10. Which function returns the lowest value?
☑ A. MIN
☐ B. LOW
☐ C. SMALL
☐ D. BOTTOM
Rationale: MIN finds the smallest number.
,11. What does the IF function do?
☑ A. Performs logical tests
☐ B. Adds numbers
☐ C. Formats cells
☐ D. Sorts data
Rationale: IF returns different results based on a condition.
12. Which formula tests if A1 is greater than 10?
☑ A. =IF(A1>10,"Yes","No")
☐ B. =IF(A1<10,"Yes","No")
☐ C. =IF(A1=10,"Yes","No")
☐ D. =IF(A1>=100,"Yes","No")
Rationale: Correct logical comparison is used.
13. Which symbol is used for absolute cell reference?
☑ A. $
☐ B. &
☐ C. #
☐ D. !
Rationale: $ locks rows or columns in formulas.
14. What does $A$1 mean?
☑ A. Both row and column are fixed
☐ B. Only row is fixed
☐ C. Only column is fixed
☐ D. Cell is hidden
Rationale: Absolute reference prevents movement when copied.
15. What does relative cell referencing do?
☑ A. Changes references when copied
☐ B. Locks cells
☐ C. Deletes formulas
☐ D. Formats cells
Rationale: Relative references adjust automatically.
, 16. Which function looks up data vertically?
☑ A. VLOOKUP
☐ B. HLOOKUP
☐ C. MATCH
☐ D. INDEX
Rationale: VLOOKUP searches down columns.
17. Which function looks up data horizontally?
☑ A. HLOOKUP
☐ B. VLOOKUP
☐ C. FIND
☐ D. SEARCH
Rationale: HLOOKUP searches across rows.
18. What does the CONCAT function do?
☑ A. Joins text together
☐ B. Splits text
☐ C. Counts characters
☐ D. Formats numbers
Rationale: CONCAT combines text strings.
19. Which function finds text within a cell (case-sensitive)?
☑ A. FIND
☐ B. SEARCH
☐ C. LOOKUP
☐ D. MATCH
Rationale: FIND distinguishes uppercase and lowercase.
20. Which function finds text but is not case-sensitive?
☑ A. SEARCH
☐ B. FIND
☐ C. MID
☐ D. LEFT
Rationale: SEARCH ignores case differences.
21. What does the LEFT function do?
☑ A. Extracts text from the left
