Information Technology Quiz – 55

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.

1. Merge cells option can be applied from?
(A) Format cells dialogue box alignment tab
(B) Formatting toolbar
(C) Both of the above
(D) None of the both

2. Pre-made sheet formats like simple, classic, accounting, colourful etc. can be applied from?
(A) From format >> cells
(B) From format >> autoformat
(C) From table >> autoformat
(D) All of the above

3. Which of the following you can decide to apply or not in the AutoFormat dialogue box?
(A) Number format
(B) Border format
(C) Font format
(D) All of the above

4. How can you remove borders applied in cells?
(A) Choose none on the border tab of format cells
(B) Open the list on border tool in Formatting toolbar then choose the first tool (no border)
(C) Both A & B
(D) None of the above

5. Where can you set the shedding colour for a range of cells in Excel?
(A) Choose the required colour from patterns tab of format cells dialogue box
(B) Choose required colour on fill colour tool in the formatting toolbar
(C) Choose required colour on fill tool in the drawing toolbar
(D) All of the above

6. You can set the page border in Excel?
(A) From border tab in format cells dialogue box
(B) From border tool in the formatting toolbar
(C) From line style tool in the drawing toolbar
(D) You cannot set page border in Excel

7. When all the numbers between 0 and 100 in a range should be displayed in red colour apply?
(A) Use = if() function to the format the required numbers red
(B) Apply conditional formatting command on format menu
(C) Select the cell that contain number between 0 and 100 then click red colour on text colour tool
(D) None of these

8. You can check the conditions against____________ when applying conditional formatting?
(A) Cell value
(B) Formula
(C) Both A & B
(D) None of the above

9. Which of the following is not true regarding conditional formatting?
(A) You can add more than one condition to check
(B) You can set the condition to look for bold and apply italics on them
(C) You can apply font, border and pattern formats that meet the specified conditions
(D) You can delete any condition from conditional formatting dialog box if it is not required

10. Which of the following is an invalid statement?
(A) Sheet tab can be coloured
(B) Some pictures can be applied as a background of a sheet
(C) You can set the column width automatically fit the amount of text
(D) The width of a row and be specified manually or fit automatically