**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. Which of the following is an absolute cell reference?**

(A) !A!1

(B) $A$1

(C) #a#1

(D) A1

**2. What symbol is used before a number to make it a label?**

(A) “ (quote)

(B) = (equal)

(C) _ (underscore)

(D) ‘ (apostrophe)

**3. Which symbol must all formula begin with?**

(A) =

(B) +

(C) (

(D) @

**4. Which of the following formulas is not entered correctly?**

(A) =10+50

(B) =B7*B1

(C) =B7+14

(D) 10+20

**5. Which of the following formulas will Excel not be able to calculate?**

(A) =SUM(Sales) – A3

(B) =SUM(A1:A5)* .5

(C) =SUM(A1:A5) / (10 – 10)

(D) =SUM(A1:A5) – 10

**6. Atypical worksheet has _______ number of columns?**

(A) 128

(B) 256

(C) 512

(D) 1024

**7. How many characters can be typed in a single cell in Excel?**

(A) 256

(B) 1024

(C) 32000

(D) 65535

**8. A worksheet can have a maximum of ______ number of rows?**

(A) 256

(B) 1024

(C) 32000

(D) 65535

**9. Which of the following is not an example of a value?**

(A) 350

(B) May 10, 2019

(C) 0.50

(D) Serial number 50771

**10. The chart wizard term data series refer to?**

(A) A chart legend

(B) A collection of chart data markers

(C) A set of values you plot in chart

(D) A data label

## Be the first to comment