Information Technology Quiz – 51

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. Where can you change automatic or manual calculation mode in Excel?
(A) Double CAL indicator on the status bar
(B) Go to Tools >> Options >> Calculation and mark the corresponding radio button
(C) Both of the above
(D) None of above

2. How can you show or hide the gridlines in Excel Worksheet?
(A) Go to Tools >> Options >> View tab and mark or remove the checkbox named Gridline
(B) Click Gridline tool on Forms toolbar
(C) Both of above
(D) None of above

3. Which of the following Excel screen components can NOT be turned on or off?
(A) Formula Bar
(B) Status Bar
(C) Tool Bar
(D) None of above

4. What happens when you press Ctrl + X after selecting some cells in Excel?
(A) The cell content of selected cells disappear from a cell and stored in the clipboard
(B) The cells selected are marked for cutting
(C) The selected cells are deleted and the cells are shifted left
(D) The selected cells are deleted and cells are shifted up

5. Which of the following option is not available in Paste Special dialog box?
(A) Add
(B) Subtract
(C) Divide
(D) SQRT

6. Which command will you choose to convert a column of data into row?
(A) Cut and Paste
(B) Edit >> Paste Special >> Transpose
(C) Both of above
(D) None of above

7. It is acceptable to let long text flow into adjacent cells on a worksheet when?
(A) Data will be entered in the adjacent cells
(B) No data will be entered in the adjacent cells
(C) There is no suitable abbreviation for the text
(D) There is not time to format the text

8. Which of the cell pointer indicates you that you can make the selection?
(A) Doctor’s symbol (Big Plus)
(B) Small thin plus icon
(C) Mouse Pointer with an anchor at the tip
(D) None of above

9. Which of the cell pointer indicates that you can fill series?
(A) Doctor’s symbol (Big Plus)
(B) Small thin plus icon
(C) Mouse Pointer with an anchor at the tip
(D) None of above

10. Which of the cell pointer indicates that you can move the content to other cells?
(A) Big Plus
(B) Small thin plus icon
(C) Mouse Pointer with anchor at the tip
(D) None of above