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
251. To copy formatting from one area in a worksheet and apply it to another area you would use
- The Edit-Copy Format and Edit>Paste Format commands form the menu
- The copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu
- There is to way to copy and apply formatting in Excel- You have to do it manually
- The Format Painter button on the standard toolbar
252. In Excel in a worksheet you an select
- The entire worksheet
- Rows
- Columns
- All of the above
253. When you link data maintained in an excel workbook to a word document
- The word document cannot be edit
- The word document contains a reference to the original source application
- The word document must contain a hyperlink
- The word document contains a copy of the actual data
254. Which area in an excel window allows entering values and formulas ?
- Title bar
- Menu bar
- Formula bar
- Standard toolbar
255. In Microsoft Word shotcut CTRL + Z is for
- Undo something
- Delete something
- Paste something
- None of these