EXCEL CRASH COURSE
Actual Questions and Answers
Expert-Verified Explanation
This Exam contains:
✪ 40 Questions and Answers
✪ Multiple-choice and True/False Format
✪ Expert-Verified Explanations
✪ Verified with Trusted Textbooks
1. Which keyboard shortcut does NOT add a new worksheet in Excel?
A. Alt + I + W
B. Shift + F11
C. Alt + Shift + F1
D. Alt + H + I + W
Answer: D
EXPLANATION: Alt + H + I + W is not a valid shortcut. The rest are all used to insert new sheets.
2. What is the keyboard shortcut to open an existing file in Excel?
A. Ctrl + O
B. Ctrl + F
C. Ctrl + N
D. Alt + O
Answer: A
EXPLANATION: Ctrl + O opens an existing file. Ctrl + F is used for "Find." Ctrl + N opens a new file.
3. What is the recommended calculation setting for Excel?
A. Manual
B. Automatic
C. Iterate
D. Automatic except for Data Tables
Answer: D
EXPLANATION: "Automatic except for Data Tables" optimizes performance by excluding data tables,
which can slow Excel.
4. Which key allows you to jump between tabs in the Format Cells dialog?
A. Ctrl + Tab
B. Alt + Tab
C. Ctrl + Shift
D. Ctrl + 1
Answer: A
EXPLANATION: Ctrl + Tab switches between tabs in dialog boxes.
, 5. What is the shortcut to autofit column width?
A. Alt + O + C + A
B. Alt + H + O + W
C. Alt + H + O + I
D. Alt + O + C + W
Answer: C
EXPLANATION: Alt + H + O + I auto fits column width. Others control column width or height manually.
6. What is the keyboard shortcut to open the Format Cells dialog box?
A. Ctrl + 1
B. Ctrl + 2
C. Ctrl + Shift + 1
D. Ctrl + Shift + 2
Answer: A
EXPLANATION: Ctrl + 1 opens the Format Cells dialog.
7. What shortcut opens the Paste Special dialog?
A. Ctrl + V
B. Alt + E + S
C. Ctrl + H + V
D. Ctrl + E + S
Answer: B
EXPLANATION: Alt + E + S or Alt + H + V + S opens the Paste Special dialog.
8. What shortcut is used to freeze panes?
A. Alt + W + F + F
B. Alt + F + W + V
C. Alt + W + S
D. Alt + A + W + T
Answer: A
EXPLANATION: Alt + W + F + F freezes panes.
9. What shortcut splits a worksheet into two panes?
A. Alt + W + S
B. Alt + F + S
C. Alt + H + S
D. Alt + V + S
Answer: A
EXPLANATION: Alt + W + S splits the worksheet.
10. What key cycles through worksheet panes after splitting?
A. Tab
B. F6
C. Alt + Tab
D. Ctrl + F6
Answer: B
EXPLANATION: F6 jumps between panes in a split view.
Actual Questions and Answers
Expert-Verified Explanation
This Exam contains:
✪ 40 Questions and Answers
✪ Multiple-choice and True/False Format
✪ Expert-Verified Explanations
✪ Verified with Trusted Textbooks
1. Which keyboard shortcut does NOT add a new worksheet in Excel?
A. Alt + I + W
B. Shift + F11
C. Alt + Shift + F1
D. Alt + H + I + W
Answer: D
EXPLANATION: Alt + H + I + W is not a valid shortcut. The rest are all used to insert new sheets.
2. What is the keyboard shortcut to open an existing file in Excel?
A. Ctrl + O
B. Ctrl + F
C. Ctrl + N
D. Alt + O
Answer: A
EXPLANATION: Ctrl + O opens an existing file. Ctrl + F is used for "Find." Ctrl + N opens a new file.
3. What is the recommended calculation setting for Excel?
A. Manual
B. Automatic
C. Iterate
D. Automatic except for Data Tables
Answer: D
EXPLANATION: "Automatic except for Data Tables" optimizes performance by excluding data tables,
which can slow Excel.
4. Which key allows you to jump between tabs in the Format Cells dialog?
A. Ctrl + Tab
B. Alt + Tab
C. Ctrl + Shift
D. Ctrl + 1
Answer: A
EXPLANATION: Ctrl + Tab switches between tabs in dialog boxes.
, 5. What is the shortcut to autofit column width?
A. Alt + O + C + A
B. Alt + H + O + W
C. Alt + H + O + I
D. Alt + O + C + W
Answer: C
EXPLANATION: Alt + H + O + I auto fits column width. Others control column width or height manually.
6. What is the keyboard shortcut to open the Format Cells dialog box?
A. Ctrl + 1
B. Ctrl + 2
C. Ctrl + Shift + 1
D. Ctrl + Shift + 2
Answer: A
EXPLANATION: Ctrl + 1 opens the Format Cells dialog.
7. What shortcut opens the Paste Special dialog?
A. Ctrl + V
B. Alt + E + S
C. Ctrl + H + V
D. Ctrl + E + S
Answer: B
EXPLANATION: Alt + E + S or Alt + H + V + S opens the Paste Special dialog.
8. What shortcut is used to freeze panes?
A. Alt + W + F + F
B. Alt + F + W + V
C. Alt + W + S
D. Alt + A + W + T
Answer: A
EXPLANATION: Alt + W + F + F freezes panes.
9. What shortcut splits a worksheet into two panes?
A. Alt + W + S
B. Alt + F + S
C. Alt + H + S
D. Alt + V + S
Answer: A
EXPLANATION: Alt + W + S splits the worksheet.
10. What key cycles through worksheet panes after splitting?
A. Tab
B. F6
C. Alt + Tab
D. Ctrl + F6
Answer: B
EXPLANATION: F6 jumps between panes in a split view.
