Microsoft Excel Questions and Answers

Practice Mode
Showing 10 of 255 questions
Q81
In Excel which of the following is an absolute ceeel referrence ?
  • A !A!1
  • B $A$1
  • C #a#1
  • D A1
Answer: Option B
Q82
In Excel what symbol is used before a number to make it a label ?
  • A "(quote)
  • B =(equal)
  • C -(underscore)
  • D '(apostrophe)
Answer: Option B
Q83
In Excel which symbol must all formula begin with ?
  • A =
  • B +
  • C (
  • D @
Answer: Option A
Q84
In Excel which of the following formula is not entered correctluy ?
  • A =10+50
  • B =B7*B1
  • C =B7+14
  • D 10+50
Answer: Option D
Q85
In Excel 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
Answer: Option A
Q86
In Excel typical worksheet has ................. Number of columns
  • A 128
  • B 256
  • C 512
  • D 1024
Answer: Option B
Q87
In Excel how many characters can be typed in a single cell ?
  • A 256
  • B 1024
  • C 32000
  • D 65535
Answer: Option D
Q88
In Excel worksheet can have a maximum of ............... number of rows
  • A 256
  • B 1024
  • C 32000
  • D 65535
Answer: Option D
Q89
In Excel the follwing is not an example of a value
  • A 350
  • B May 10, 2001
  • C 57 & per cent;
  • D Serial Number 50771
Answer: Option D
Q90
In Excel the following is not an example of a value
  • A A chart legend
  • B A collection of chart data markers
  • C A set of values you plot in a chart
  • D A data label
Answer: Option B

📚 More from Computer Science & Engineering(CSE)

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Computer Science & Engineering(CSE)
Back to Computer Science & Engineering(CSE)
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test