Bird
0
0

Which Excel shortcut autofits the column width to match content?

hard Q9 of 15
Computer Aptitude - Keyboard Shortcuts
Which Excel shortcut autofits the column width to match content?
AAlt + H + O + I
BAlt + A + C
CAlt + O + A
DCtrl + I
Step-by-Step Solution

  1. Step 1: Identify formatting task

    We need to automatically adjust column width.

  2. Step 2: Apply Excel ribbon shortcut

    Alt + H + O + I autofits the column width.

  3. Final Answer:

    Alt + H + O + I → Option A

  4. Quick Check:

    Select a column → run shortcut → width adjusts perfectly. ✅
Quick Trick: HOI → Home → Format → Autofit.
Common Mistakes:
MISTAKES
  • Assuming Ctrl shortcuts can autofit—they cannot.
Master "Keyboard Shortcuts" in Computer Aptitude

Start learning the concept with an interactive lesson.

Learn

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Computer Aptitude Quizzes
Keyboard Shortcuts - Browser Shortcuts - Quiz 8hard Keyboard Shortcuts - Function Key Shortcuts - Quiz 14medium Keyboard Shortcuts - File & Document Management Shortcuts - Quiz 14medium Keyboard Shortcuts - Navigation & Selection Shortcuts - Quiz 6medium Keyboard Shortcuts - File & Document Management Shortcuts - Quiz 10hard Keyboard Shortcuts - Word-Specific Formatting Shortcuts - Quiz 15medium Keyboard Shortcuts - Word-Specific Formatting Shortcuts - Quiz 14medium Keyboard Shortcuts - Browser Shortcuts - Quiz 15medium Keyboard Shortcuts - System Control / Windows Shortcuts - Quiz 9hard Keyboard Shortcuts - File Explorer Shortcuts - Quiz 3easy