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
31. The AutoFill feature
- extends a sequential series of data
- automatically adds a range of cell values
- selects a range of cells
- none of the above
32. You can copy data or formulas
- with the copy, paste and cut commands on the edit menu
- with commands on a shortcut menu
- with buttons on the standard toolbar
- all of the above
33. To view a cell comment
- click the edit comment command on theinsert 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
34. To hold row and column titles in place so that they do not scroll when you scroll when you scroll a worksheet, click the
- unfreeze panes command on the window menu
- freeze panes command on the window menu
- hold titles command on the edit menu
- split command on the window menu
35. In Excel default header for a worksheet is
- Your name
- The date and time
- None
- The sheet tab name
36. In Excel which of the following is not an option in the spelling dialog box
- Edit
- Ignore
- Ignore all
- Change
37. Excel uses the ............. Function when creating a data table
- Average
- Count
- Sum
- Table
38. In Excel you can copy cell formats from one cell to another by using the
- Backspace key
- Default font
- Format painter
- Formatting toolbar
39. In Excel accounting style shows negative numbers in
- Bold
- Brackets
- Parentheses
- Quotes
40. In Excel you can use drag and drop to embed excel worksheet data in a word document
- By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
- By dragging a range of excel data to the Word button on the taskbar while pressing Shift key
- By Displaying both applications side-by-side and dragging a selected range of Excel data into the word application window while pressing the Ctrl key
- (A) and (C)