Information Technology Quiz – 44

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 + h + v + g is used for?
(A) Copy merging conditional formatting of the destination and source ranges
(B) Paste merging conditional formatting of the destination and source ranges
(C) Cut merging conditional formatting of the destination and source ranges
(D) Delete merging conditional formatting of the destination and source ranges

2. Alt + h + v + r is used for?
(A) Copy format
(B) Cut format
(C) Delete format
(D) Paste format

3. Alt + h + v + w is used for?
(A) Paste column widths
(B) Remove column widths
(C) Merge columns
(D) Paste row widths

4. Alt + ‘ is used for?
(A) Display the style dialog box
(B) Hide the style dialog box
(C) Display help option for a dialog box
(D) None of these

5. Alt + d is used for?
(A) Within border tab of format cells dialog box, add / remove downward border
(B) Within border tab of format cells dialog box, add / remove downward horizontal border
(C) Within border tab of format cells dialog box, add / remove downward vertical border
(D) Within border tab of format cells dialog box, add / remove downward diagonal border

6. Alt + h is used for?
(A) Within Border tab of Format Cells dialog box and when more than 1 row is selected, add/remove horizontal interior border
(B) Within Border tab of Format Cells dialog box and when more than 1 row is selected, add/remove vertical interior border
(C) Within Border tab of Format Cells dialog box and when more than 1 row is selected, add/remove diagonal interior border
(D) All of the above

7. Alt + h + o is used for?
(A) Increase the number of percentage display
(B) Increase the number of decimal display
(C) Increase the number of square display
(D) None of these

8. Alt + h + 3 + d is used for?
(A) Remove double underline only
(B) Apply double underline only
(C) Apply or remove double underline
(D) None of these

9. Alt + h + 5 is used for?
(A) Align text to the left cell
(B) Increase indent
(C) Decrease indent
(D) Align the text to the right cell

10. Alt + h + 6 is used for?
(A) Increase indent
(B) Decrease the number of decimal displayed
(C) Decrease the number of percentage displayed
(D) Decrease indent