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
61. In Excel to copy cell contents using drag and drop, press the
- End key
- Shift key
- Esc key
- None of above
62. In Excel if you press.............the cell accepts your typing as its contents.
- Enter
- CTRL + Enter
- Tab
- Insert
63. In Excel the auto fill feature
- Extends a sequential series of data
- Automatially adds a range of cell values
- Applies a boarder around selected cells
- None of above
64. In Excel the keyboard shortcut (button or buttons to be press(D) for creating a chart from the selected cells
- F3
- F5
- F7
- F11
65. In Excel you can use the formula palette to
- Format cells containing numbers
- Create and edit formulas containing functions
- Entered assumptions data
- Copy a range of cells
66. What excel feature can you use if you want to work with one record at a time?
- Auto Complete
- Auto Filter
- Data Form
- Sub Totals
67. In Excel what chart object is horizontal or vertical line that extends across the plot area to make it easier to read and follow the values ?
- Category axiz
- Data marker
- Data point
- Gridline
68. In Excel what chart object is horizontal or vertical that extends across the plot area to make it easier to read and follow the values ?
- Category axis
- Data marker
- Function
- Range
69. In Excel value used in a formula that does not change is called a
- Contents
- Objects
- Scenarios
- All of above
70. In Excel you can use the drag and drop method to
- Copy cell contents
- Move cell contents
- Add cell contents
- (A) and (B)