Information Technology Quiz – 43

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. Alt + H + B is used for?
(A) Add a border
(B) Remove a border
(C) Apply outline border
(D) Remove outline border

2. Ctlr + shift + & is used for?
(A) Remove outline border
(B) Apply currency format
(C) Apply outline border
(D) Add a border

3. Ctrl + shift + _ (underscore) is used for?
(A) Add outline border
(B) Remove outline border
(C) Select a fill color
(D) Hide the selected rows

4. Ctrl + 9 is used for?
(A) Hide the worksheet
(B) Hide the selected cell
(C) Hide the selected column
(D) Hide the selected rows

5. Ctrl + 0 is used for?
(A) Hide the worksheet
(B) Hide the selected columns
(C) Hide the selected rows
(D) Hide the selected cell

6. Ctrl + 1 is used for?
(A) Close the format cells dialog box
(B) Open the format column dialog box
(C) Open the format row dialog box
(D) Open the format cells dialog box

7. Ctrl + 5 is used for?
(A) Apply or remove strikethrough
(B) Apply strikethrough only
(C) Remove strikethrough only
(D) None of these

8. Ctrl + shift + $ is used for?
(A) Apply border
(B) Remove currency format
(C) Apply currency format
(D) All of the above

9. Ctrl + shift + % is used for?
(A) Apply percent format
(B) Remove percent format
(C) Add or remove bold
(D) Add or remove underline

10. Ctrl + 6 is used for?
(A) Alternate hiding object
(B) Alternate between hiding and showing object
(C) Alternate showing object
(D) Zoom in / out