EXCEL CRASH COURSE PRACTICE EXAM
2026/2027 | EXCEL | 80 VERIFIED Q&A |
DETAILED RATIONALES | NGN-ALIGNED |
PASS GUARANTEED – A+ GRADED
SECTION 1: EXCEL FUNDAMENTALS & INTERFACE – Questions 1-16
Q1: Excel Workbook Definition
In Microsoft Excel, a workbook is:
A. A single sheet of cells
B. A collection of one or more worksheets
C. A chart
D. A formula
Correct Answer: B
Rationale: A workbook is the Excel file itself, which can contain multiple worksheets (tabs). A
worksheet is a single grid of cells within the workbook.
Q2: Active Cell Identification
The active cell in Excel is:
A. Always A1
B. The cell that is currently selected and ready for data entry
C. The cell with the most data
D. A locked cell
Correct Answer: B
Rationale: The active cell is the currently selected cell, indicated by a thick border. Data entered
via the keyboard goes into the active cell.
Q3: Name Box Function
What does the Name Box in Excel display?
A. The current time
B. The address of the active cell or the name of a selected range
C. The formula in the active cell
D. The file name
Correct Answer: B
Rationale: The Name Box is located to the left of the formula bar and shows the reference of the
active cell (e.g., A1) or the name assigned to a range.
Q4: Formula Bar Purpose
,The Formula Bar in Excel is used to:
A. Format cells
B. Display and edit the contents of the active cell
C. Insert charts
D. Save the workbook
Correct Answer: B
Rationale: The Formula Bar shows the actual contents of the active cell, whether it's text, a
number, or a formula. You can edit the content directly in the Formula Bar.
Q5: Column and Row Labels
In Excel, columns are labeled with ______ and rows are labeled with ______.
A. Numbers; letters
B. Letters; numbers
C. Symbols; numbers
D. Letters; symbols
Correct Answer: B
Rationale: Columns are identified by letters (A, B, C, ...) and rows by numbers (1, 2, 3, ...). A cell
reference combines both, like A1.
Q6: Cell Reference Interpretation
The cell reference "C5" refers to:
A. Column C, Row 5
B. Row C, Column 5
C. The fifth cell in row C
D. A named range
Correct Answer: A
Rationale: In Excel, the column letter comes first, followed by the row number. So C5 is column
C, row 5.
Q7: Range Reference Meaning
The range "A1:B10" includes:
A. Only cells A1 and B10
B. All cells from A1 to B10 in a rectangular block
C. All cells in column A and row B
D. Only cells in row 1 and column B
Correct Answer: B
Rationale: A range reference like A1:B10 includes all cells in the rectangle defined by the
top-left cell (A1) and the bottom-right cell (B10).
Q8: Data Entry Confirmation
, To enter data into a cell, you can:
A. Type and press Enter
B. Type and press Tab
C. Type and click another cell
D. All of the above
Correct Answer: D
Rationale: You can confirm cell entry by pressing Enter (moves down), Tab (moves right), or by
clicking another cell. All are valid methods.
Q9: Editing Cell Content
To edit the contents of a cell without retyping, you can:
A. Double-click the cell
B. Press F2
C. Click the Formula Bar
D. All of the above
Correct Answer: D
Rationale: Double-clicking the cell, pressing F2, or clicking the Formula Bar all allow you to edit
the existing content of a cell.
Q10: Undo Shortcut
The keyboard shortcut for Undo in Excel is:
A. Ctrl + Z
B. Ctrl + Y
C. Ctrl + U
D. Ctrl + X
Correct Answer: A
Rationale: Ctrl + Z undoes the last action. Ctrl + Y redoes an action that was undone. Ctrl + X
cuts, and Ctrl + U underlines.
Q11: Redo Shortcut
The keyboard shortcut for Redo in Excel is:
A. Ctrl + Z
B. Ctrl + Y
C. Ctrl + R
D. Ctrl + D
Correct Answer: B
Rationale: Ctrl + Y redoes an action that was previously undone. Ctrl + Z is undo.
Q12: Save As Command
The "Save As" command allows you to:
2026/2027 | EXCEL | 80 VERIFIED Q&A |
DETAILED RATIONALES | NGN-ALIGNED |
PASS GUARANTEED – A+ GRADED
SECTION 1: EXCEL FUNDAMENTALS & INTERFACE – Questions 1-16
Q1: Excel Workbook Definition
In Microsoft Excel, a workbook is:
A. A single sheet of cells
B. A collection of one or more worksheets
C. A chart
D. A formula
Correct Answer: B
Rationale: A workbook is the Excel file itself, which can contain multiple worksheets (tabs). A
worksheet is a single grid of cells within the workbook.
Q2: Active Cell Identification
The active cell in Excel is:
A. Always A1
B. The cell that is currently selected and ready for data entry
C. The cell with the most data
D. A locked cell
Correct Answer: B
Rationale: The active cell is the currently selected cell, indicated by a thick border. Data entered
via the keyboard goes into the active cell.
Q3: Name Box Function
What does the Name Box in Excel display?
A. The current time
B. The address of the active cell or the name of a selected range
C. The formula in the active cell
D. The file name
Correct Answer: B
Rationale: The Name Box is located to the left of the formula bar and shows the reference of the
active cell (e.g., A1) or the name assigned to a range.
Q4: Formula Bar Purpose
,The Formula Bar in Excel is used to:
A. Format cells
B. Display and edit the contents of the active cell
C. Insert charts
D. Save the workbook
Correct Answer: B
Rationale: The Formula Bar shows the actual contents of the active cell, whether it's text, a
number, or a formula. You can edit the content directly in the Formula Bar.
Q5: Column and Row Labels
In Excel, columns are labeled with ______ and rows are labeled with ______.
A. Numbers; letters
B. Letters; numbers
C. Symbols; numbers
D. Letters; symbols
Correct Answer: B
Rationale: Columns are identified by letters (A, B, C, ...) and rows by numbers (1, 2, 3, ...). A cell
reference combines both, like A1.
Q6: Cell Reference Interpretation
The cell reference "C5" refers to:
A. Column C, Row 5
B. Row C, Column 5
C. The fifth cell in row C
D. A named range
Correct Answer: A
Rationale: In Excel, the column letter comes first, followed by the row number. So C5 is column
C, row 5.
Q7: Range Reference Meaning
The range "A1:B10" includes:
A. Only cells A1 and B10
B. All cells from A1 to B10 in a rectangular block
C. All cells in column A and row B
D. Only cells in row 1 and column B
Correct Answer: B
Rationale: A range reference like A1:B10 includes all cells in the rectangle defined by the
top-left cell (A1) and the bottom-right cell (B10).
Q8: Data Entry Confirmation
, To enter data into a cell, you can:
A. Type and press Enter
B. Type and press Tab
C. Type and click another cell
D. All of the above
Correct Answer: D
Rationale: You can confirm cell entry by pressing Enter (moves down), Tab (moves right), or by
clicking another cell. All are valid methods.
Q9: Editing Cell Content
To edit the contents of a cell without retyping, you can:
A. Double-click the cell
B. Press F2
C. Click the Formula Bar
D. All of the above
Correct Answer: D
Rationale: Double-clicking the cell, pressing F2, or clicking the Formula Bar all allow you to edit
the existing content of a cell.
Q10: Undo Shortcut
The keyboard shortcut for Undo in Excel is:
A. Ctrl + Z
B. Ctrl + Y
C. Ctrl + U
D. Ctrl + X
Correct Answer: A
Rationale: Ctrl + Z undoes the last action. Ctrl + Y redoes an action that was undone. Ctrl + X
cuts, and Ctrl + U underlines.
Q11: Redo Shortcut
The keyboard shortcut for Redo in Excel is:
A. Ctrl + Z
B. Ctrl + Y
C. Ctrl + R
D. Ctrl + D
Correct Answer: B
Rationale: Ctrl + Y redoes an action that was previously undone. Ctrl + Z is undo.
Q12: Save As Command
The "Save As" command allows you to:
