Virginia Tech — ACIS 1504 Introduction
to Business Analytics & BI — Final Exam
With Questions And Answers With
Rationales
PART I: EXCEL FUNDAMENTALS & KEYBOARD
SHORTCUTS (Questions 1-15)
1. Which of the following is a keyboard shortcut
to save a workbook in Excel?
• A) Ctrl + S
• B) Ctrl + P
• C) Ctrl + O
• D) Ctrl + N
• E) Ctrl + Z
Answer: A
Rationale: Ctrl + S is the shortcut to save a
,workbook. Ctrl + P prints, Ctrl + O opens, Ctrl + N
creates a new workbook, and Ctrl + Z undoes the
last action.
2. Which Excel Ribbon tab contains the Sort &
Filter options?
• A) Home
• B) Insert
• C) Page Layout
• D) Data
• E) View
Answer: D
Rationale: The Data tab contains sorting and
filtering options, as well as other data tools. The
Home tab contains basic formatting and editing
tools.
,3. Which keyboard shortcut undoes the last action
in Excel?
• A) Ctrl + Y
• B) Ctrl + Z
• C) Ctrl + X
• D) Ctrl + C
• E) Ctrl + V
Answer: B
Rationale: Ctrl + Z is the undo shortcut. Ctrl + Y
redoes, Ctrl + X cuts, Ctrl + C copies, and Ctrl + V
pastes.
4. The Excel Ribbon is organized into:
• A) Tabs, groups, and commands
• B) Menus and submenus
• C) Toolbars only
• D) Dialog boxes
, • E) Formulas and functions
Answer: A
Rationale: The Excel Ribbon is organized
into tabs (e.g., Home, Insert, Data), groups within
each tab, and commands within each group.
5. Which of the following is NOT a valid way to
select a range of cells in Excel?
• A) Click and drag
• B) Shift + arrow keys
• C) Ctrl + A to select all
• D) Type the range address in the Name Box
• E) Right-click and select "Select Range"
Answer: E
Rationale: Right-clicking does not provide a "Select
Range" option. Valid selection methods include
clicking and dragging, using Shift + arrow keys, using
to Business Analytics & BI — Final Exam
With Questions And Answers With
Rationales
PART I: EXCEL FUNDAMENTALS & KEYBOARD
SHORTCUTS (Questions 1-15)
1. Which of the following is a keyboard shortcut
to save a workbook in Excel?
• A) Ctrl + S
• B) Ctrl + P
• C) Ctrl + O
• D) Ctrl + N
• E) Ctrl + Z
Answer: A
Rationale: Ctrl + S is the shortcut to save a
,workbook. Ctrl + P prints, Ctrl + O opens, Ctrl + N
creates a new workbook, and Ctrl + Z undoes the
last action.
2. Which Excel Ribbon tab contains the Sort &
Filter options?
• A) Home
• B) Insert
• C) Page Layout
• D) Data
• E) View
Answer: D
Rationale: The Data tab contains sorting and
filtering options, as well as other data tools. The
Home tab contains basic formatting and editing
tools.
,3. Which keyboard shortcut undoes the last action
in Excel?
• A) Ctrl + Y
• B) Ctrl + Z
• C) Ctrl + X
• D) Ctrl + C
• E) Ctrl + V
Answer: B
Rationale: Ctrl + Z is the undo shortcut. Ctrl + Y
redoes, Ctrl + X cuts, Ctrl + C copies, and Ctrl + V
pastes.
4. The Excel Ribbon is organized into:
• A) Tabs, groups, and commands
• B) Menus and submenus
• C) Toolbars only
• D) Dialog boxes
, • E) Formulas and functions
Answer: A
Rationale: The Excel Ribbon is organized
into tabs (e.g., Home, Insert, Data), groups within
each tab, and commands within each group.
5. Which of the following is NOT a valid way to
select a range of cells in Excel?
• A) Click and drag
• B) Shift + arrow keys
• C) Ctrl + A to select all
• D) Type the range address in the Name Box
• E) Right-click and select "Select Range"
Answer: E
Rationale: Right-clicking does not provide a "Select
Range" option. Valid selection methods include
clicking and dragging, using Shift + arrow keys, using
