Texas Microsoft Excel Expert Course Questions and Correct Answers with Rationales

Texas Microsoft Excel Expert Course Questions
And Correct Answer with Rational (100%
verified answer) Q & A 2026 /
Instant download PDF

.


1. Which function is used to add a range of numbers in Excel?
A. AVERAGE
B. SUM
C. COUNT
D. MAX
Answer: B
Rationale: SUM adds all numeric values in a selected range.


2. What is the shortcut to save a workbook?
A. Ctrl + P
B. Ctrl + S
C. Ctrl + O
D. Ctrl + N
Answer: B
Rationale: Ctrl + S saves the current file.


3. Which symbol starts all Excel formulas?
A. #
B. @

,C. =
D. &
Answer: C
Rationale: All formulas begin with =.


4. Which function counts only numeric cells?
A. COUNTA
B. COUNT
C. COUNTIF
D. SUM
Answer: B
Rationale: COUNT counts only numbers.


5. What does VLOOKUP do?
A. Looks vertically for data
B. Calculates averages
C. Sorts data
D. Creates charts
Answer: A
Rationale: VLOOKUP searches vertically in a table.


6. Which feature helps organize data into rows and columns for analysis?
A. PivotTable
B. Chart
C. Filter
D. Macro
Answer: A
Rationale: PivotTables summarize data dynamically.

, 7. What is the extension of an Excel file?
A. .docx
B. .xlsx
C. .pptx
D. .pdf
Answer: B
Rationale: .xlsx is Excel’s default format.


8. Which function returns the largest value in a range?
A. MIN
B. MAX
C. LARGE
D. TOP
Answer: B
Rationale: MAX returns highest value.


9. What does Ctrl + Z do?
A. Redo
B. Undo
C. Save
D. Print
Answer: B
Rationale: Ctrl + Z undoes the last action.


10. Which tool removes duplicates?
A. Sort
B. Filter
C. Remove Duplicates
D. Data Validation