Question

Which shortcut opens the Format Cells dialog box?

• A. Ctrl + 1
• B. Ctrl + Shift + $
• C. Ctrl + B
• D. F2

Answer 1

Answer:

A. Ctrl + 1

Context: Spreadsheets (e.g., Microsoft Excel, Google Sheets, LibreOffice Calc)

• The keyboard shortcut Ctrl + 1 is universally used across most spreadsheet applications to instantly open the Format Cells dialog box.

• This dialog box provides comprehensive options for customizing the appearance of cells, including:

  • Number Formatting: Changing how numbers are displayed (e.g., currency, percentage, date, scientific notation).

  • Alignment: Adjusting text orientation, horizontal and vertical alignment, and text wrapping.

  • Font: Modifying font type, size, color, and applying effects like bold, italic, or strikethrough.

  • Borders: Adding, removing, or styling cell borders.

  • Fill: Applying background colors or patterns to cells.

  • Protection: Locking cells or hiding formulas (often used in conjunction with sheet protection).