EXCEL CRASH COURSE EXAM 2026 LATEST VERSION 200 QUESTIONS AND 100% CORRECT ANSWERS WITH RATIONALES (BRAND NEW!!)

EXCEL CRASH COURSE EXAM 2026 LATEST VERSION 200 QUESTIONS AND 100%
CORRECT ANSWERS WITH RATIONALES (BRAND NEW!!)
1. Which function calculates the sum of a range of cells?
☐ A. AVERAGE
☑ B. SUM
☐ C. COUNT
☐ D. MAX
Rationale: SUM adds all numeric values in a range.



2. Which function returns the largest value in a range?
☐ A. MIN
☑ B. MAX
☐ C. AVERAGE
☐ D. SUM
Rationale: MAX identifies the highest value in a dataset.



3. Which function returns the smallest value in a range?
☑ A. MIN
☐ B. MAX
☐ C. COUNT
☐ D. SUM
Rationale: MIN identifies the lowest value in a dataset.



4. Which function calculates the average of a range of cells?
☐ A. SUM
☑ B. AVERAGE
☐ C. COUNT
☐ D. MAX
Rationale: AVERAGE sums values and divides by the count of numbers.



5. Which function counts all numeric values in a range?
☑ A. COUNT
☐ B. COUNTA
☐ C. COUNTBLANK
☐ D. SUM
Rationale: COUNT only counts cells containing numbers.

,6. Which function counts all non-empty cells?
☐ A. COUNT
☑ B. COUNTA
☐ C. COUNTBLANK
☐ D. SUM
Rationale: COUNTA counts all cells with any type of content.



7. Which function counts empty cells in a range?
☐ A. COUNT
☐ B. COUNTA
☑ C. COUNTBLANK
☐ D. COUNTIF
Rationale: COUNTBLANK returns the number of blank cells.



8. Which function returns the current date?
☑ A. TODAY
☐ B. NOW
☐ C. DATE
☐ D. TIME
Rationale: TODAY returns the system date only.



9. Which function returns the current date and time?
☐ A. TODAY
☑ B. NOW
☐ C. DATE
☐ D. TIME
Rationale: NOW returns both date and time.



10. Which function adds up values based on a condition?
☐ A. SUM
☑ B. SUMIF
☐ C. COUNTIF
☐ D. AVERAGEIF
Rationale: SUMIF sums cells that meet a specified condition.

,11. Which function counts cells that meet a specific condition?
☑ A. COUNTIF
☐ B. SUMIF
☐ C. SUM
☐ D. AVERAGEIF
Rationale: COUNTIF counts cells matching a single condition.



12. Which function calculates the average of cells meeting a condition?
☐ A. SUMIF
☐ B. COUNTIF
☑ C. AVERAGEIF
☐ D. IF
Rationale: AVERAGEIF averages values that satisfy a criterion.



13. Which feature fills cells automatically based on a detected pattern?
☐ A. AutoSum
☑ B. Flash Fill
☐ C. Fill Handle
☐ D. Data Validation
Rationale: Flash Fill detects patterns and completes the series automatically.



14. Which feature copies formulas or values across cells?
☑ A. Fill Handle
☐ B. Flash Fill
☐ C. AutoFill
☐ D. Data Table
Rationale: Fill Handle lets you drag formulas to adjacent cells.



15. Which function joins two or more text strings into one?
☐ A. TEXTJOIN
☑ B. CONCATENATE / CONCAT
☐ C. MERGE
☐ D. REPLACE
Rationale: CONCATENATE (or CONCAT) combines multiple text strings.



16. Which function joins text with a delimiter?
☑ A. TEXTJOIN

, ☐ B. CONCAT
☐ C. CONCATENATE
☐ D. MERGE
Rationale: TEXTJOIN allows you to include separators between text values.



17. Which function converts all text to uppercase?
☐ A. LOWER
☑ B. UPPER
☐ C. PROPER
☐ D. CAPITALIZE
Rationale: UPPER converts all letters in a cell to capital letters.



18. Which function converts all text to lowercase?
☑ A. LOWER
☐ B. UPPER
☐ C. PROPER
☐ D. CAPITALIZE
Rationale: LOWER converts all letters in a cell to lowercase.



19. Which function capitalizes the first letter of each word?
☐ A. UPPER
☑ B. PROPER
☐ C. LOWER
☐ D. CAPITALIZE
Rationale: PROPER formats text with initial capitals.



20. Which function removes extra spaces from text?
☐ A. CLEAN
☑ B. TRIM
☐ C. SUBSTITUTE
☐ D. REPLACE
Rationale: TRIM removes extra spaces, leaving single spaces between words.



21. Which function removes non-printable characters?
☑ A. CLEAN
☐ B. TRIM
☐ C. SUBSTITUTE