Information Technology Quiz – 66

information technology

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. Which Chart can be created in Excel?
(A) Area
(B) Line
(C) Pie
(D) All of the above

2. What will be the output if you format the cell containing 5436.8 as ‘#,##0.00′?
(A) 5,430.00
(B) 5,436.80
(C) 5,436.8
(D) 6.8

3. How do you display the current date and time in MS Excel?
(A) Date ()
(B) Today ()
(C) Now ()
(D) Time ()

4. How do you display the current date only in MS Excel?
(A) Date ()
(B) Today ()
(C) Now ()
(D) Time ()

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

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

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

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

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

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

About pankaj 837 Articles
Pankaj is passionate about his work. Because he loves what he does. He is a full time blogger and also has experience in Computer as well as in Teaching Field. DHGK is the dream Project of his own Mind to help aspirants.

Be the first to comment

Leave a Reply

Your email address will not be published.


*


This site uses Akismet to reduce spam. Learn how your comment data is processed.