Microsoft Excel Questions and Answers
Microsoft Excel questions with answers are frequently asked in campus placements and government exams to test candidates’ data-handling and analytical abilities. As part of programming questions and answers, Excel is not only a spreadsheet tool but a mini-programming environment through its formulas, macros, and data functions. Mastering Excel helps in automating tasks, analyzing large datasets, and building reports efficiently. This topic covers essential Excel MCQs focusing on functions like VLOOKUP, pivot tables, charts, conditional formatting, and data analysis tools. Whether you’re preparing for TCS, Infosys, or SSC exams, practicing Excel questions enhances your technical aptitude and boosts your problem-solving efficiency.
Microsoft Excel
Showing 10 of
255 questions
81. In Excel which of the following is an absolute ceeel referrence ?
- !A!1
- $A$1
- #a#1
- A1
82. In Excel what symbol is used before a number to make it a label ?
- "(quote)
- =(equal)
- -(underscore)
- '(apostrophe)
84. In Excel which of the following formula is not entered correctluy ?
- =10+50
- =B7*B1
- =B7+14
- 10+50
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
86. In Excel typical worksheet has ................. Number of columns
- 128
- 256
- 512
- 1024
87. In Excel how many characters can be typed in a single cell ?
- 256
- 1024
- 32000
- 65535
88. In Excel worksheet can have a maximum of ............... number of rows
- 256
- 1024
- 32000
- 65535
89. In Excel the follwing is not an example of a value
- 350
- May 10, 2001
- 57 & per cent;
- Serial Number 50771
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