Information Technology Quiz – 76

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. How do you display the current date and time in MS Excel?
(A) Date()
(B) Today()
(C) Now()
(D) Time()

2. How do you merge cells in Excel?
(A) Select cells -> home menu -> merge cells
(B) Select cells -> insert menu -> merge cells
(C) Select cells -> view menu -> merge cells
(D) Select cells -> page layout menu -> merge cells

3. How do you display wrap the text in a cell?
(A) Format, cells, font
(B) Format, cells, protection
(C) Format, cells, number
(D) Format, cells alignment

4. What does the COUNTA() function do?
(A) Counts cells having alphabets
(B) Counts empty cells
(C) Counts cells having a number
(D) Counts non-empty cells

5. What is the short cut key to highlight the entire column?
(A) Ctrl + C
(B) Ctrl + enter
(C) Ctrl + page up
(D) Ctrl + space bar

6. In the formula, which symbol specifies the fixed columns or rows?
(A) $
(B) *
(C) %
(D) &

7. Excel displays the current cell address in the?
(A) Formula bar
(B) Status bar
(C) Name bar
(D) Title bar

8. What is the correct way to refer to the cell A10 on sheet3 from sheet1?
(A) Sheet3!A10
(B) Sheet1!A10
(C) Sheet3.A10
(D) A10

9. Which language is used to correct macros in Excel?
(A) Visual Basic
(B) C
(C) Visual C++
(D) Java

10. Which of the following is not a term of MS-Excel?
(A) Cells
(B) Rows
(C) Columns
(D) Document