Question

What is the shortcut key to increase the number of decimal places in Excel?
1. Alt + H + 9
2. Alt + H + P
3. Alt + H + D
4. Alt + H + 0

Answer 1

Correct Answer - Option 4 : Alt + H + 0

The correct answer is Alt + H + 0

• An MS Excel worksheet contains rows 1,048,576 rows and 16,384 columns to store the test and numbers and merged into a single workbook knows as a File. ​Workbooks are the Excel files that one can open and share, while Excel worksheets are individual spreadsheets within them.

 

•  Formatting Shortcuts
• CTRL + 1: Format Box
• ALT + E + S + T: Copy Format
• ALT + H + 0: Increase Decimal
• ALT + H + 9: Decrease Decimal
• CTRL + SHIFT + 7: Boxing
• ALT + O + C + A: Fit Column Width
• ALT + H + O + R: Change Tab Name
• ALT + W + F: (Un)Split Panes
• ALT + W + S: (Un)freeze windows
• SHIFT + CTRL + #: Date Format
• SHIFT + CTRL + $ $: Dollar Format
• SHIFT + CTRL + % %: Percentage Format
• ALT + "=": Sum Function