Information Technology Quiz – 47

Dear Aspirants,

Daily IT Quiz is the basic part of the Himachal GK. It is helpful to increase your knowledge based on information technology. It is a series of Himachal Gk MCQs. You can also play our weekly quiz and download all quizzes PDF as well.

General Program Shortcuts for formatting cell for MS Excel:

1. Ctrl + shift + ! is used for?
(A) Apply alphabetically format (Default settings are: (1) 2 decimal places, (2) 1000 separator, and (3) minus (-) sign for negative values)
(B) Apply number format (Default settings are: (1) 2 decimal places, (2) 1000 separator, and (3) minus (-) sign for negative values)
(C) Apply symbolic format (Default settings are: (1) 2 decimal places, (2) 1000 separator, and (3) minus (-) sign for negative values)
(D) All of the above

2. Ctrl + shift + # is used for?
(A) Remove date formatting (Default setting is the date, month and year)
(B) Apply percentage format
(C) Apply number format
(D) Apply date format (Default setting is date, month and year)

3. Ctrl + shift + $ is used for?
(A) Apply currency format (Default settings are: (1) 2 decimal places, (2) 1000 separator, and (3) negative values within parentheses ( ))
(B) Apply date format
(C) Remove currency format (Default settings are: (1) 2 decimal places, (2) 1000 separator, and (3) negative values within parentheses ( ))
(D) Apply bold format

4. Ctrl + shift + % is used for?
(A) Apply percentage format (Default setting is without decimal places)
(B) Apply number format (Default setting is without decimal places)
(C) Apply symbolic format (Default setting is without decimal places)
(D) Apply alphabetically format (Default setting is without decimal places)

5. Ctrl + shift + & is used for?
(A) Remove inside borders to the selected cell(s)
(B) Add inside borders to the selected cell(s)
(C) Remove outside borders to the selected cell(s)
(D) Add outside borders to selected cell(s)

6. Ctrl + shift + ^ is used for?
(A) Apply scientific format (Default setting is with 2 decimal places)
(B) Apply date format
(C) Remove scientific format (Default setting is with 2 decimal places)
(D) Apply percentage format

7. Ctrl + shift + @ is used for?
(A) Apply scientific format (Default setting is with 2 decimal places)
(B) Apply time format (Default settings are: (1) hour and minute, and (2) AM or PM)
(C) Apply percentage format (Default setting is without decimal places)
(D) Remove time format (Default settings are: (1) hour and minute, and (2) AM or PM)

8. Ctrl + shift + _ is used for?
(A) Apply outside borders
(B) Remove inside borders
(C) Remove outside borders
(D) Apply inside borders

9. Ctrl + shift + ~ is used for?
(A) Remove general format
(B) Apply scientific format
(C) Apply general format
(D) Apply time format

10. Ctrl + u / l is used for?
(A) Display the create a table dialog box
(B) Hide the create a table dialog box
(C) Display the edit table dialog box
(D) Hide the edit table dialog box