DocMCQs Educational Banner

In Excel which key is used for format number in percentage format?

A. Ctrl+Shift+6
B. Ctrl+Shift+3
C. Ctrl+Shift+5
D. Ctrl+1
Correct Answer: C. Ctrl+Shift+5
Explanation:


The correct answer is Ctrl+Shift+5 because this exact key combination applies the percentage formatting rule directly to selected values in Microsoft Excel.



    • Step 1 (Formatting Action): When a number is input into a cell and you strike Ctrl+Shift+5, the software multiplies the numerical value by 100 and appends the standard percentage sign (%) at the end without decimals.

    • Step 2 (Mnemonic Association): A quick way to memorize this shortcut is by noting that the number 5 key on standard keyboard configurations houses the physical percentage symbol (%) directly above it as a shifted character.

    • Incorrect Options:

      • Ctrl+Shift+6 applies exponential scientific tracking notation to the active numeric field.

      • Ctrl+Shift+3 formats the numbers into a standardized Day-Month-Year calendar layout.

      • Ctrl+1 is incorrect because it opens the comprehensive 'Format Cells' properties dialog box instead of instantly applying a percentage shortcut.




If you think there is any confusion in given MCQS You can comment.

Follow us on WhatsApp

Drop of Change Academy is Pakistan No.1 online Plate form to prepare all types of Exams including PPSC, FPSC, KPSC, SPSC, Ministry of Defence, And for all one paper MCQS , Pedagogy MCQS, docmcqs  general knowledge MCQS, current affair MCQS and alot more

 

 

Leave a Comment

Your email address will not be published. Required fields are marked *

Join Our WhatsApp Channel ×
Scroll to Top