Information Technology Quiz – 82

Dear Aspirants,

Daily Information Technology 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. Which of the following format you can decide to apply or not in the AutoFormat dialog box?
(A) Number format
(B) Border format
(C) Font format
(D) All of the above

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

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

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

5. When all the numbers between 0 and 100 in a range should be displayed in red color, apply?
(A) Use =if() function to format the required number red
(B) Apply conditional formatting command on the Format menu
(C) Select the cells that contain a number between 0 and 100 then click a red color on the text color tool
(D) All of the above

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

7. 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

8. Which of the following is an invalid statement?
(A) Sheet tabs can be colored
(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

9. You can use the formula palette too?
(A) Format cells containing numbers
(B) Create and edit formula containing functions
(C) Enter assumptions data
(D) Copy a range of cells

10. When a range is selected, how can you activate the previous cell?
(A) Press Alt key
(B) Press Tab
(C) Press Enter
(D) None of the above