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
91. In Excel Chart Wizard term data categories refers to
- A chart plot area
- A horizontal axis
- The organization of individual values with a chart's data series
- The data range that supply chart data
92. In Excel worksheet range is a
- A command used for data modeling
- A range of values sucha as from 23 to 234
- A group of cells
- A group of worksheets
93. In Excel getting data from a cell located in a different sheet is called
- Accessing
- Referencing
- Updating
- Functioning
94. In Excel Tab scrolling button
- Allow you to view a different worksheet
- Allow you to view additional worksheet rows down
- Allow you to view additional worksheet Columns to the right
- Allow you to view additional sheets tabs
95. In Excel numeric value can be treated as a label value if it preceds with
- apostrophe(')
- Exclamation(!)
- hash(#)
- Ampresand(&)
96. In Excel numeric value can be treated as a label value if it preceds with
- Apostrophe(')
- Exclamation(!)
- hash(#)
- Ampersand(&)
97. In Excel to view a cell comment
- Click the edit comment commands on the insert menu
- Click the Display comment command on the window menu
- Position the mouse pointer over the cell
- Click the comment command on the view menu
98. In Excel say that you want to paste a formula result - but not the underlying formula - to another cell . In excel 2002. you would copy the cell with the formula. then place the insertion point in the cell yu want to copy to what next ?
- Click the Paste button on the Standard toolbar
- Click the arrow on the paste button on the standard toolbar, then click formulas
- Click the arrow on the paste button on the standard toolbar, then click values.
- All of above.
99. In Excel you can select a single range of cells by
- Clicking the upper-Left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
- Pressing the Ctrl key while dragging over the desired cells
- Pressing the Shift key and an arrow key
- Dragging over the desired cells
100. In Excel you can select a single range of cells by
- Clicking the upper-left cell in a group of cells and then pressing the Shft key while clicking the lower right cell in a group of cells
- Pressing the Ctrl key while dragging over the desired cells
- Pressing the Shift key and an arrow key
- Dragging over the desired cells