Information Technology Quiz – 54

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. What is the percentage in Excel?
(A) 10
(B) 100
(C) 300
(D) 500

2. The spelling tool is placed on ______ toolbar?
(A) Standard
(B) Formatting
(C) Drawing
(D) Reviewing

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

4. Can you set 0.5 inches left an indentation for a cell in Excel?
(A) Excel does not have an indentation feature
(B) You can specify indentation only if you turn the rulers on
(C) Indentation can be set from Format Cells dialog box
(D) The indentation can be specified only when printing

5. You can automatically adjust the size of the text in a cell if they do not fit in width by?
(A) Double-clicking on the right border of a column header
(B) From Format choose Columns and then Autofit Selection
(C) From Format Cells, dialog box mark Shrink to fit checkbox
(D) All of above

6. Formatting a cell in Currency, you can specify?
(A) Decimal Places
(B) Currency Symbol
(C) Both of the above
(D) None of above

7. Formatting a cell in Number format you can’t set?
(A) Decimal Places
(B) Use 1000 separator
(C) Negative numbers
(D) Currency Symbol

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

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

10. Special category of Number tab in Format Cells dialog box can be used to apply formats like?
(A) Zip Code
(B) Phone Number
(C) Both of above
(D) None of above