Information Technology Quiz – 79

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. MS Excel provides the default value for step in fill series dialog box?
(A) 0
(B) 1
(C) 5
(D) 10

2. When a row of data is to be converted into columns?
(A) Copy the cells in a row, select the same number of cells in a row, and paste
(B) Copy the cells in a column then choose edit >> paste special, then click transpose and ok
(C) Copy the cells then go to format >> cells then on the alignment tab click the transpose checkbox and click ok
(D) Select the cells then place the cell pointer on new cell and choose edit >> paste special, mark the transpose checkbox and click ok

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

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

5. The command edit >> fill across the 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 the above

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

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

8. Paste special allows some operation while you paste to a new cells. Which of the following operation is valid?
(A) Square
(B) Percentage
(C) Goal seek
(D) Divide

9. Edit >> delete command?
(A) Deletes the content of a cell
(B) Deletes formats of cell
(C) Deletes the comment of cell
(D) Deletes selected cells

10. To remove the content of selected cell you must use which of the following command?
(A) Edit >> delete
(B) Edit >> clear >> content
(C) Edit >> clear >> all
(D) Data >> delete