Discussion
In MS Excel, which shortcut opens the Format Cells dialogue?
Answer: D
Correct answer: Ctrl + 1
Ctrl + 1 opens the Format Cells dialogue, which holds every formatting option in one place: number format, alignment, font, border, fill and protection. The Number tab is the one that repays study, since Excel’s handling of numbers is entirely a matter of format. A date is a serial number displayed as a date; a percentage is a fraction displayed with a per cent sign; and a custom format code can display a number in almost any way without changing its value. The Protection tab is where cells are marked Locked or Unlocked - a setting that does nothing until the sheet itself is protected, which catches many users out. The neighbouring number shortcuts are worth knowing: Ctrl + 9 hides the selected rows, Ctrl + 0 hides columns, and Ctrl + Shift + 9 and 0 unhide them. Ctrl + F finds, and Ctrl + P prints.
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development