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
11. Which of the following methods cannot be used to edit the contents of a cell?
- pressing the ALT key
- clicking the formula bar
- pressing the F2 key
- double-clicking the cell
12. Which of the following methods cannot be used to enter data in a cell?
- pressing an arrow key
- pressing the TAB key
- pressing the ESC key
- pressing the ENTER key
13. You can use the horizontal and vertical scroll bars to
- split a worksheet into two panes
- view different rows and columns
- edit the contents of a cell
- view different worksheets
14. When the formula bar is activated, you can see
- the edit formula button
- the enter button
- the contents of the active cell
- all of the above
15. Status indicators are located on the
- vertical scroll bar
- horizontal scroll bar
- formula bar
- standard toolbar
16. You can activate a cell by
- pressing the TAB key
- clicking the cell
- pressing an arrow key
- all of the above
17. Each excel file is called a workbook because
- it can contain text and data
- it can be modified
- it can contain many sheets including wroksheets and chart sheets
- you have to work hard to create it
18. Which of the following is not a basic step in creating a worksheet?
- save the workbook
- enter text and data
- copy the worksheet
- print the worksheet
19. Tab scrolling buttons
- 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 sheet tabs
20. The name box
- shows the location of the previously active cell
- appears to the left of the formula bar
- appears below the status bar
- appears below the menu bar