Excell Formatting & Shortcut MCQs

Cell Formatting Shortcuts (Excel)



  • Open Format Cells dialog box → Ctrl + 1

  • Apply General format → Ctrl + Shift + ~

  • Apply Currency format → Ctrl + Shift + $

  • Apply Percentage format → Ctrl + Shift + %

  • Apply Date format → Ctrl + Shift + #

  • Apply Time format → Ctrl + Shift + @

  • Apply Number format (2 decimals) → Ctrl + Shift + !


Font & Style Shortcuts



  • Bold text → Ctrl + B

  • Italic text → Ctrl + I

  • Underline text → Ctrl + U


Border & Alignment Shortcuts



  • Add outline border → Ctrl + Shift + &

  • Remove outline border → Ctrl + Shift + _

  • Center align → Alt + H + A + C

  • Left align → Alt + H + A + L

  • Right align → Alt + H + A + R


==============================================================


Excell Formatting & Shortcut MCQs


1. Which shortcut opens the Format Cells dialog box?


Format Cells dialog box āĻ–ā§āĻ˛āĻŋāĻŦāĻ˛ā§ˆ āĻ•ā§‹āĻ¨āĻŸā§‹ shortcut āĻŦā§āĻ¯ā§ąāĻšāĻžā§° āĻšāĻ¯āĻŧ ?
A) Ctrl + F | B) Ctrl + 1 | C) Ctrl + Shift + F | D) Alt + F
Ans: B) Ctrl + 1
Explanation: Opens full formatting options. āĻŦā§āĻ¯āĻžāĻ–ā§āĻ¯āĻž: āĻāĻ‡āĻŸā§‹āĻ¤ āĻ¸āĻ•āĻ˛ā§‹ formatting āĻŦāĻŋāĻ•āĻ˛ā§āĻĒ āĻ–ā§‹āĻ˛ā§‡āĨ¤


2. Shortcut for General number format is: General format āĻĻāĻŋāĻŦāĻ˛ā§ˆ shortcut āĻ•āĻŋ ?
A) Ctrl + Shift + ~ | B) Ctrl + Shift + # | C) Ctrl + Shift + @ | D) Ctrl + Shift + %
Ans: A) Ctrl + Shift + ~
Explanation: Removes specific formats. āĻŦā§āĻ¯āĻžāĻ–ā§āĻ¯āĻž: āĻ¸āĻ•āĻ˛ā§‹ āĻŦāĻŋāĻļā§‡āĻˇ format āĻ†āĻāĻ¤ā§°āĻžāĻ‡ āĻ¸āĻžāĻ§āĻžā§°āĻŖ āĻ•ā§°ā§‡āĨ¤


3. Currency format shortcut is: Currency formatā§° āĻŦāĻžāĻŦā§‡ shortcut āĻ•āĻŋ ?
A) Ctrl + Shift + % | B) Ctrl + Shift + $ | C) Ctrl + Shift + @ | D) Ctrl + Shift + !
Ans: B) Ctrl + Shift + $
Explanation: Adds currency symbol. āĻŦā§āĻ¯āĻžāĻ–ā§āĻ¯āĻž: āĻŸāĻ•āĻžā§° āĻšāĻŋāĻ¨ āĻ¯ā§‹āĻ— āĻ•ā§°ā§‡āĨ¤


4. Percentage format shortcut is: Percentage formatā§° shortcut āĻ•āĻŋ ?
A) Ctrl + Shift + # | B) Ctrl + Shift + % | C) Ctrl + Shift + $ | D) Ctrl + Shift + ~
Ans: B) Ctrl + Shift + %
Explanation: Converts number into percentage. āĻŦā§āĻ¯āĻžāĻ–ā§āĻ¯āĻž: āĻ¸āĻ‚āĻ–ā§āĻ¯āĻžāĻ• āĻļāĻ¤āĻžāĻ‚āĻļāĻ˛ā§ˆ ā§°ā§‚āĻĒāĻžāĻ¨ā§āĻ¤ā§° āĻ•ā§°ā§‡āĨ¤


5. Date format shortcut is: Date formatā§° shortcut āĻ•āĻŋ ?
A) Ctrl + Shift + # | B) Ctrl + Shift + @ | C) Ctrl + Shift + ! | D) Ctrl + Shift + %
Ans: A) Ctrl + Shift + #
Explanation: Displays date format. āĻŦā§āĻ¯āĻžāĻ–ā§āĻ¯āĻž: āĻ¤āĻžā§°āĻŋāĻ– ā§°ā§‚āĻĒāĻ¤ āĻĻā§‡āĻ–ā§ā§ąāĻžāĻ¯āĻŧāĨ¤


6. Time format shortcut is: Time formatā§° shortcut āĻ•āĻŋ ?
A) Ctrl + Shift + # | B) Ctrl + Shift + @ | C) Ctrl + Shift + ~ | D) Ctrl + Shift + $
Ans: B) Ctrl + Shift + @
Explanation: Displays time format. āĻŦā§āĻ¯āĻžāĻ–ā§āĻ¯āĻž: āĻ¸āĻŽāĻ¯āĻŧ ā§°ā§‚āĻĒāĻ¤ āĻĻā§‡āĻ–ā§ā§ąāĻžāĻ¯āĻŧāĨ¤


7. Number format with 2 decimals shortcut: 2 decimal āĻĨāĻ•āĻž Number formatā§° shortcut āĻ•āĻŋ ?
A) Ctrl + Shift + ! | B) Ctrl + Shift + % | C) Ctrl + Shift + $ | D) Ctrl + Shift + @
Ans: A) Ctrl + Shift + !
Explanation: Applies numeric format. āĻŦā§āĻ¯āĻžāĻ–ā§āĻ¯āĻž: āĻ¸āĻžāĻ§āĻžā§°āĻŖ āĻ¸āĻ‚āĻ–ā§āĻ¯āĻž format āĻĒā§ā§°āĻ¯āĻŧā§‹āĻ— āĻ•ā§°ā§‡āĨ¤


Font & Style MCQs (āĻĻā§āĻŦāĻŋāĻ­āĻžāĻˇāĻŋāĻ•)


8. Bold text shortcut is: Bold āĻ•ā§°āĻŋāĻŦāĻ˛ā§ˆ shortcut āĻ•āĻŋ ?
A) Ctrl + U | B) Ctrl + B | C) Ctrl + I | D) Ctrl + Shift + B
Ans: B) Ctrl + B
Explanation: Makes text bold. āĻŦā§āĻ¯āĻžāĻ–ā§āĻ¯āĻž: āĻ˛āĻŋāĻ–āĻ¨ā§€ āĻĄāĻžāĻ™ā§° āĻ†ā§°ā§ āĻ—āĻžāĻĸāĻŧ āĻ•ā§°ā§‡āĨ¤


9. Italic text shortcut is: Italic āĻ•ā§°āĻŋāĻŦāĻ˛ā§ˆ shortcut āĻ•āĻŋ ?
A) Ctrl + 1 | B) Ctrl + I | C) Ctrl + U | D) Ctrl + Shift + I
Ans: B) Ctrl + I
Explanation: Makes text slanted. āĻŦā§āĻ¯āĻžāĻ–ā§āĻ¯āĻž: āĻ˛āĻŋāĻ–āĻ¨ā§€ āĻĸāĻžāĻ˛ā§ āĻ•ā§°ā§‡āĨ¤


10. Underline shortcut is: Underline āĻ•ā§°āĻŋāĻŦāĻ˛ā§ˆ shortcut āĻ•āĻŋ ?
A) Ctrl + I | B) Ctrl + B | C) Ctrl + U | D) Ctrl + Shift + U
Ans: C) Ctrl + U
Explanation: Underlines text. āĻŦā§āĻ¯āĻžāĻ–ā§āĻ¯āĻž: āĻ˛āĻŋāĻ–āĻ¨ā§€ā§° āĻ¤āĻ˛āĻ¤ ā§°ā§‡āĻ–āĻž āĻ†āĻāĻ•ā§‡āĨ¤


Border & Alignment MCQs (āĻĻā§āĻŦāĻŋāĻ­āĻžāĻˇāĻŋāĻ•)


11. Add outline border shortcut is: Border āĻ¯ā§‹āĻ— āĻ•ā§°āĻŋāĻŦāĻ˛ā§ˆ shortcut āĻ•āĻŋ ?
A) Ctrl + Shift + & | B) Ctrl + Shift + _ | C) Ctrl + B | D) Ctrl + Alt + &
Ans: A) Ctrl + Shift + &
Explanation: Adds border to cells. āĻŦā§āĻ¯āĻžāĻ–ā§āĻ¯āĻž: cellā§° āĻšāĻžā§°āĻŋāĻ“āĻĢāĻžāĻ˛ā§‡ border āĻ¯ā§‹āĻ— āĻ•ā§°ā§‡āĨ¤


12. Remove border shortcut is: Border āĻ†āĻāĻ¤ā§°āĻžāĻŦāĻ˛ā§ˆ shortcut āĻ•āĻŋ ?
A) Ctrl + Shift + & | B) Ctrl + Shift + _ | C) Ctrl + Shift + - | D) Ctrl + Alt + _
Ans: B) Ctrl + Shift + _
Explanation: Removes border. āĻŦā§āĻ¯āĻžāĻ–ā§āĻ¯āĻž: border āĻ†āĻāĻ¤ā§°āĻžāĻ¯āĻŧāĨ¤


13. Center align shortcut is: Center align āĻ•ā§°āĻŋāĻŦāĻ˛ā§ˆ shortcut āĻ•āĻŋ ?
A) Alt + H + A + L | B) Alt + H + A + R | C) Alt + H + A + C | D) Ctrl + E
Ans: C) Alt + H + A + C
Explanation: Aligns text center. āĻŦā§āĻ¯āĻžāĻ–ā§āĻ¯āĻž: āĻ˛āĻŋāĻ–āĻ¨ā§€ āĻŽāĻžāĻœāĻ¤ ā§°āĻžāĻ–ā§‡āĨ¤


14. Left align shortcut is: Left align āĻ•ā§°āĻŋāĻŦāĻ˛ā§ˆ shortcut āĻ•āĻŋ ?
A) Alt + H + A + C | B) Alt + H + A + L | C) Alt + H + A + R | D) Ctrl + L
Ans: B) Alt + H + A + L
Explanation: Aligns left. āĻŦā§āĻ¯āĻžāĻ–ā§āĻ¯āĻž: āĻŦāĻžāĻ“āĻāĻĢāĻžāĻ˛ā§‡ ā§°āĻžāĻ–ā§‡āĨ¤


15. Right align shortcut is: Right align āĻ•ā§°āĻŋāĻŦāĻ˛ā§ˆ shortcut āĻ•āĻŋ?
A) Alt + H + A + R | B) Alt + H + A + L | C) Alt + H + A + C | D) Ctrl + R
Ans: A) Alt + H + A + R


Explanation: Aligns right. āĻŦā§āĻ¯āĻžāĻ–ā§āĻ¯āĻž: āĻ¸ā§‹āĻāĻĢāĻžāĻ˛ā§‡ ā§°āĻžāĻ–ā§‡āĨ¤