Ad
Sponsored by Sir Tauqeer
CLICK HERE TO JOIN SIR TAUQUEER WHATSAPP GROUP
FOR PREPARATION CLASSES AND JOBS UPDATES
Join Now

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

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


The correct answer is Ctrl+Shift+6 because this built-in shortcut combination instantly applies the Scientific (exponential) number format to the active cells.



    • Ctrl+Shift+6: This is the correct choice. On a standard keyboard layout, the number 6 key houses the caret symbol (^), meaning this command is also represented as Ctrl + Shift + ^. Executing it converts long digits into scientific notation displaying a decimal value followed by an 'E' exponent parameter (e.g., 120,000 becomes 1.20E+05) to easily manage large numerical figures.

    • Incorrect Options:

      • Ctrl+Shift+3: This is incorrect. This combination applies the Date format (day, month, and year) to selected cell values.

      • Ctrl+Shift+4: This is incorrect. This shortcut applies the Currency format (using the dollar/local currency symbol with two trailing decimal places).

      • Ctrl+Shift+5: This is incorrect. This command applies the Percentage format with no trailing decimal representation.




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