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