Excel Crash Course Exam 1 Question and
Answers with Rationales Latest Version Top
Rated A+
Questions 1–20
Question 1
Which of the following is the correct file extension for a modern Excel workbook?
A. .docx
B. .xlsx
C. .pptx
D. .txt
Correct Answer: B. .xlsx
Rationale:
The default file format for Microsoft Excel workbooks since Excel 2007 is .xlsx. Older Excel
files use .xls.
Question 2
What is the intersection of a row and a column called in Excel?
A. Range
B. Worksheet
C. Cell
D. Formula
Correct Answer: C. Cell
Rationale:
A cell is the individual box where a row and column meet. Each cell has a unique address, such
as A1 or C5.
,Question 3
Which symbol must every Excel formula begin with?
A. +
B. =
C. #
D. @
Correct Answer: B. =
Rationale:
Excel recognizes calculations and formulas when they begin with an equal sign (=).
Example:
=A1+B1
Question 4
Which function is used to add numbers in Excel?
A. COUNT
B. SUM
C. ADD
D. TOTAL
Correct Answer: B. SUM
Rationale:
The SUM() function adds numbers in selected cells.
Example:
=SUM(A1:A10)
Question 5
What does the formula =AVERAGE(A1:A5) calculate?
A. The largest value
B. The smallest value
C. The mean value
D. The number of cells
,Correct Answer: C. The mean value
Rationale:
The AVERAGE() function calculates the arithmetic average of selected numbers.
Question 6
Which Excel feature allows you to quickly copy formulas or patterns by dragging a small
square?
A. Ribbon
B. Fill Handle
C. Formula Bar
D. Status Bar
Correct Answer: B. Fill Handle
Rationale:
The Fill Handle is the small square at the bottom-right corner of a selected cell. Dragging it
copies formulas or continues patterns.
Question 7
Which function counts cells containing numbers?
A. COUNTA
B. COUNT
C. COUNTIF
D. NUMBER
Correct Answer: B. COUNT
Rationale:
COUNT() counts cells containing numeric values.
Example:
=COUNT(A1:A20)
Question 8
, Which shortcut saves an Excel workbook?
A. Ctrl + P
B. Ctrl + S
C. Ctrl + C
D. Ctrl + X
Correct Answer: B. Ctrl + S
Rationale:
Ctrl + S saves the current workbook.
Question 9
What does the IF function do?
A. Creates charts
B. Tests a condition and returns results
C. Sorts data
D. Deletes formulas
Correct Answer: B. Tests a condition and returns results
Rationale:
The IF() function evaluates whether a condition is true or false.
Example:
=IF(A1>=50,"Pass","Fail")
Question 10
Which Excel tool is used to organize data alphabetically or numerically?
A. Sort
B. Filter
C. Freeze Panes
D. Format Painter
Correct Answer: A. Sort
Rationale:
The Sort feature arranges data in ascending or descending order.
Answers with Rationales Latest Version Top
Rated A+
Questions 1–20
Question 1
Which of the following is the correct file extension for a modern Excel workbook?
A. .docx
B. .xlsx
C. .pptx
D. .txt
Correct Answer: B. .xlsx
Rationale:
The default file format for Microsoft Excel workbooks since Excel 2007 is .xlsx. Older Excel
files use .xls.
Question 2
What is the intersection of a row and a column called in Excel?
A. Range
B. Worksheet
C. Cell
D. Formula
Correct Answer: C. Cell
Rationale:
A cell is the individual box where a row and column meet. Each cell has a unique address, such
as A1 or C5.
,Question 3
Which symbol must every Excel formula begin with?
A. +
B. =
C. #
D. @
Correct Answer: B. =
Rationale:
Excel recognizes calculations and formulas when they begin with an equal sign (=).
Example:
=A1+B1
Question 4
Which function is used to add numbers in Excel?
A. COUNT
B. SUM
C. ADD
D. TOTAL
Correct Answer: B. SUM
Rationale:
The SUM() function adds numbers in selected cells.
Example:
=SUM(A1:A10)
Question 5
What does the formula =AVERAGE(A1:A5) calculate?
A. The largest value
B. The smallest value
C. The mean value
D. The number of cells
,Correct Answer: C. The mean value
Rationale:
The AVERAGE() function calculates the arithmetic average of selected numbers.
Question 6
Which Excel feature allows you to quickly copy formulas or patterns by dragging a small
square?
A. Ribbon
B. Fill Handle
C. Formula Bar
D. Status Bar
Correct Answer: B. Fill Handle
Rationale:
The Fill Handle is the small square at the bottom-right corner of a selected cell. Dragging it
copies formulas or continues patterns.
Question 7
Which function counts cells containing numbers?
A. COUNTA
B. COUNT
C. COUNTIF
D. NUMBER
Correct Answer: B. COUNT
Rationale:
COUNT() counts cells containing numeric values.
Example:
=COUNT(A1:A20)
Question 8
, Which shortcut saves an Excel workbook?
A. Ctrl + P
B. Ctrl + S
C. Ctrl + C
D. Ctrl + X
Correct Answer: B. Ctrl + S
Rationale:
Ctrl + S saves the current workbook.
Question 9
What does the IF function do?
A. Creates charts
B. Tests a condition and returns results
C. Sorts data
D. Deletes formulas
Correct Answer: B. Tests a condition and returns results
Rationale:
The IF() function evaluates whether a condition is true or false.
Example:
=IF(A1>=50,"Pass","Fail")
Question 10
Which Excel tool is used to organize data alphabetically or numerically?
A. Sort
B. Filter
C. Freeze Panes
D. Format Painter
Correct Answer: A. Sort
Rationale:
The Sort feature arranges data in ascending or descending order.
