Information Technology Quiz – 87

Dear Aspirants,

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. Except for the _____ function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result?
(A) IF
(B) AND
(C) OR
(D) NOT

2. Macros are run or executed from which of the following menu?
(A) Insert
(B) Format
(C) Tools
(D) Data

3. You can open the consolidated dialog box but choosing consolidate from which of the following menu?
(A) Insert
(B) Format
(C) Tools
(D) Data

4. Each excel file is called a workbook because?
(A) It can contain text and data
(B) It can be modified
(C) It can contain many sheets including worksheets and chart sheets
(D) You have to work hard to create it

5. Which type of charts can Excel produce?
(A) Line graphs and pie charts only
(B) Only line graphs
(C)Bar charts, line graphs, and pie charts
(D) Bar charts and line graphs only

6. How are data organized in a spreadsheet?
(A) Lines and spaces
(B) Layers and planes
(C) Rows and columns
(D) Height and width

7. What does the VLOOKUP function do?
(A) Looks up text that contains ‘V’
(B) Checks whether a text is the same in one cell as n the next
(C) Finds related records
(D) All of the above

8. Gridlines?
(A) May be turned off for display but turned on for printing
(B) Maybe turned on or off for printing
(C) The be turned off for display and printing
(D) All of the above

9. You can print only an embedded chart by?
(A) Moving the chart to a chart before you print
(B) Formatting the chart before you print
(C) Selecting the chart before you print
(D) A and C

10. Which of the following is a correct order of precedence in a formula calculation?
(A) Multiplication and division, exponential positive and negative values
(B) Multiplication and division, positive and negative values, addition and subtraction
(C) Addition and subtraction, positive and negative values, exponentiation
(D) None of the above

Information Technology Quiz – 86