Information Technology Quiz – 76

information technology

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. Which menu option can be used to split-window into two?
(A) Format -> window
(B) View -> window -> split
(C) Window ->split
(D) View -> split

2. Getting data from a cell located on a different sheet is called?
(A) Accessing
(B) Referencing
(C) Updating
(D) Functioning

3. Which of the following is not a valid data type in Excel?
(A) Number
(B) Character
(C) Label
(D) Date / time

4. Which element of a worksheet can be protected from accidental modification?
(A) Contents
(B) Objects
(C) Scenario
(D) All of the above

5. A number value can be treated as a label value if _______ precedes it?
(A) Apostrophe (‘)
(B) Exclamation (!)
(C) Hash (#)
(D) Tilde (~)

6. Concatenation of text can be done using?
A) Apostrophe (‘)
(B) Exclamation (!)
(C) Hash (#)
(D) Ampersand (&)

7. Which area in an Excel window allows entering values and formulas?
(A) Title bar
(B) Menu bar
(C) Formula bar
(D) Standard tool bar

8. Multiple calculations can be made in a single formula using?
(A) Standard formulas
(B) Array formula
(C) Complex formulas
(D) Smart formula

9. An Excel workbook is a collection of?
(A) Workbooks
(B) Worksheets
(C) Charts
(D) Worksheets and charts

10. What do you mean by a workspace?
(A) Group of columns
(B) Group of worksheets
(C) Group of rows
(D) Group of workbooks

About pankaj 853 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.