Microsoft Excel MCQ Question and Answer

Microsoft Excel MCQ Question and Answer
81. In Excel which of the following is an absolute ceeel referrence ?
  • !A!1
  • $A$1
  • #a#1
  • A1
Show Answer
82. In Excel what symbol is used before a number to make it a label ?
  • "(quote)
  • =(equal)
  • -(underscore)
  • '(apostrophe)
Show Answer
83. In Excel which symbol must all formula begin with ?
  • =
  • +
  • (
  • @
Show Answer
84. In Excel which of the following formula is not entered correctluy ?
  • =10+50
  • =B7*B1
  • =B7+14
  • 10+50
Show Answer
85. In Excel which of the following formulas will excel not be able to calculate ?
  • =SUM(Sales)-A3
  • =SUM(A1:A5)*.5
  • =SUM(A1:A5)(10-10)
  • =SUM(A1:A5)-10
Show Answer
86. In Excel typical worksheet has ................. Number of columns
  • 128
  • 256
  • 512
  • 1024
Show Answer
87. In Excel how many characters can be typed in a single cell ?
  • 256
  • 1024
  • 32000
  • 65535
Show Answer
88. In Excel worksheet can have a maximum of ............... number of rows
  • 256
  • 1024
  • 32000
  • 65535
Show Answer
89. In Excel the follwing is not an example of a value
  • 350
  • May 10, 2001
  • 57 & per cent;
  • Serial Number 50771
Show Answer
90. In Excel the following is not an example of a value
  • A chart legend
  • A collection of chart data markers
  • A set of values you plot in a chart
  • A data label
Show Answer
Questions and Answers for Competitive Exams Various Entrance Test