1. Which of the following is true when using the "Fill Handle" in
Excel?
A. It copies the exact value of the selected cell to the adjacent
cells
B. It fills adjacent cells with a continuous series of values or a
formula
C. It allows you to freeze rows and columns simultaneously
D. It clears the content of adjacent cells
Answer: B) It fills adjacent cells with a continuous series of values
or a formula
Rationale: The Fill Handle allows you to drag a formula or value
across adjacent cells to copy or extend the series.
2. Which of the following is NOT a type of chart available in
Excel?
A. Line chart
B. Bar chart
C. Radar chart
D. Pyramid chart
Answer: D) Pyramid chart
,Rationale: While Excel offers line, bar, and radar charts, there is
no "Pyramid chart" option by default.
3. What is the primary purpose of the Data Validation feature in
Excel?
A. To sort data in ascending order
B. To ensure that only valid data is entered into a cell
C. To perform calculations on a range of cells
D. To change the appearance of a cell
Answer: B) To ensure that only valid data is entered into a cell
Rationale: Data Validation restricts the type of data that can be
entered into a cell, helping to prevent errors.
4. Which option is used to automatically recalculate formulas in
Excel?
A. Tools > Recalculate
B. File > Options > Formulas
C. Data > Recalculate
D. Home > Calculation
Answer: B) File > Options > Formulas
Rationale: You can enable automatic calculation in Excel through
the "Formulas" section in the File > Options menu.
, 5. Which Excel feature would you use to group related rows or
columns together?
A. Merge Cells
B. Group and Outline
C. Freeze Panes
D. Conditional Formatting
Answer: B) Group and Outline
Rationale: The "Group and Outline" feature allows you to group
rows or columns together for easier management and visibility.
6. Which of the following is a valid use for Excel's
CONCATENATE function?
A. Adding two cells together
B. Combining multiple text strings into one
C. Counting the number of cells in a range
D. Creating a chart
Answer: B) Combining multiple text strings into one
Rationale: CONCATENATE (or the newer CONCAT function)
combines multiple text strings into a single string.
7. What is the function of the TEXT function in Excel?
A. Converts a value to text in a specific format
Excel?
A. It copies the exact value of the selected cell to the adjacent
cells
B. It fills adjacent cells with a continuous series of values or a
formula
C. It allows you to freeze rows and columns simultaneously
D. It clears the content of adjacent cells
Answer: B) It fills adjacent cells with a continuous series of values
or a formula
Rationale: The Fill Handle allows you to drag a formula or value
across adjacent cells to copy or extend the series.
2. Which of the following is NOT a type of chart available in
Excel?
A. Line chart
B. Bar chart
C. Radar chart
D. Pyramid chart
Answer: D) Pyramid chart
,Rationale: While Excel offers line, bar, and radar charts, there is
no "Pyramid chart" option by default.
3. What is the primary purpose of the Data Validation feature in
Excel?
A. To sort data in ascending order
B. To ensure that only valid data is entered into a cell
C. To perform calculations on a range of cells
D. To change the appearance of a cell
Answer: B) To ensure that only valid data is entered into a cell
Rationale: Data Validation restricts the type of data that can be
entered into a cell, helping to prevent errors.
4. Which option is used to automatically recalculate formulas in
Excel?
A. Tools > Recalculate
B. File > Options > Formulas
C. Data > Recalculate
D. Home > Calculation
Answer: B) File > Options > Formulas
Rationale: You can enable automatic calculation in Excel through
the "Formulas" section in the File > Options menu.
, 5. Which Excel feature would you use to group related rows or
columns together?
A. Merge Cells
B. Group and Outline
C. Freeze Panes
D. Conditional Formatting
Answer: B) Group and Outline
Rationale: The "Group and Outline" feature allows you to group
rows or columns together for easier management and visibility.
6. Which of the following is a valid use for Excel's
CONCATENATE function?
A. Adding two cells together
B. Combining multiple text strings into one
C. Counting the number of cells in a range
D. Creating a chart
Answer: B) Combining multiple text strings into one
Rationale: CONCATENATE (or the newer CONCAT function)
combines multiple text strings into a single string.
7. What is the function of the TEXT function in Excel?
A. Converts a value to text in a specific format
