Information Technology Quiz – 83

Dear Aspirants,

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. If you need a text to show vertically in a cell. How will you achieve this?
(A) Choose vertical on text alignment in format cells dialog box
(B) Choose 90 degrees in orientation of format cells dialog box
(C) Choose distributed from the vertical drop down list of format cells dialog box
(D) Choose center across selection from horizontal combo box in format cells dialog box

2. Can you set an inch left indentation for a cell in Excel?
(A) Excel does not have indentation feature
(B) You can specify indentation only if you turn the rules on
(C) Indentation can be set from format cells dialog box
(D) the indentation can be specified only when printing

3. You can automatically adjust the size of text in a cell if they do not fit in width by?
(A) Double-clicking on the right border of column header
(B) From format choose columns and autofit selection
(C) From format cells dialog box mark shrink to fit check box
(D) All of above

4. Formatting a cell in currency, you can specify?
(A) Decimal places
(B) Currency symbol
(C) Both A & B
(D) None of above

5. Formatting a cell in number format you can’t set?
(A) Decimal places
(B) use 1000 separation
(C) Negative numbers
(D) Currency symbol

6. What is entered by the function =today()?
(A) The date value for the day according to system clock
(B) The time value according to system clock
(C) Today’s date as text format
(D) All of the above

7. Which function will you use to enter current time in a worksheet cell?
(A) =today()
(B) =now()
(C) =time()
(D) =currentTime()

8. Special category of number tab in format cells dialog box can be used to apply formats like?
(A) Zipcode
(B) Phone number
(C) Both A & B
(D) None of the above

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

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