Information Technology Quiz – 52

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. How you can auto fit the width of the column by?
(A) Double-clicking on the column name on the column header
(B) Double click on the cell pointer in a worksheet
(C) Double-clicking on column right border on the column header
(D) Double-clicking on the column left border of column header

2. Long text can be broken down into many lines within a cell. You can do this through?
(A) Wrap text in Format >> Cells
(B) Justify in Edit >> Cells
(C) Text wrapping in Format >> Cells, Layout tab
(D) All of above

3. MS Excel provides the default value for step in Fill Series dialog box?
(A) 0
(B) 1
(C) 5
(D) 10

4. When a row of data is to be converted into columns?
(A) Copy the cells in row, select the same number of cells in row and paste
(B) Copy the cells in the column then choose Edit >> Paste Special, then click Transpose and OK
(C) Copy the cells then go to Format >> Cells then on Alignment tab click Transpose checkbox and click OK
(D) Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose checkbox and click OK

5. Ctrl + D shortcut key in Excel will?
(A) Open the font dialog box
(B) Apply double underline for the active cell
(C) Fill down in the selection
(D) None of above

6. The short cut key Ctrl + R is used in Excel to?
(A) Right align the content of the cell
(B) Remove the cell contents of selected cells
(C) Fill the selection with active cells to the right
(D) None of above

7. The command Edit >> Fill Across Worksheet is active only when?
(A) One sheet is selected
(B) When many sheets are selected
(C) When no sheet is selected
(D) None of above

8. Which of the following series type is not valid for the fill Series dialog box?
(A) Linear
(B) Growth
(C) Autofill
(D) Time

9. Which of the following you can paste selectively using Paste Special command?
(A) Validation
(B) Formats
(C) Formulas
(D) All of above

10. Paste Special allows some operation while you paste to a new cell. Which of the following operation is valid?
(A) Square
(B) Percentage
(C) Goal Seek
(D) Divide