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