# Information Technology Quiz – 94

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

Information Technology Quiz – 93

#### Be the first to comment

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