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
51. In Excel which of the following is not an option in the spelling dialog box
- Edit
- Ignore
- Ignore all
- Change
52. In Excel you can quickly change the appearance of your work by choosing Auto Format from the...............menu
- Edit
- View
- Format
- Tools
53. In Excel ................is a group of cells that form a rectangle on the screen
- Calculation
- Formula
- Range
- Range address
54. In Excel following term describes explanatory text attached to a cell
- Callout
- Comment
- Dialog
- Extension
55. In Excel the drag and drop method of copying or moving
- Can be used between worksheets but not workbooks
- Can be used between workbooks but not worksheets
- Can be used between workbooks but not worksheets
- None
56. In Excel 3-D reference in a formula
- Cannot be modified
- Only appears on summary worksheets
- Limits the formatting options
- Spans worksheets
57. In Excel the auto calculate feature
- Can only add values in a range of cells
- Provides a quick way to view the results of an arithmetic operation on a range of cells
- Automatically creates formulas and adds them to a worksheet
- None of the above
58. In Excel to protect a worksheet, you can choose protection and the protect sheet from the ...................... menu.
- Edit
- Format
- Tools
- Data
59. In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the ..............menu.
- Edit
- Insert
- Format
- Tools
60. In Excel which of the following is not a worksheet design criterion
- Effciency
- Auditability
- Description
- Clarity Correct Answer.