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
21. Documentation should include
- destination and users of the output data
- source of input data
- a printout of the worksheets in the workbook
- all of above
22. Which of the following is not a worksheet design criterion?
- efficiency
- auditibility
- description
- clarity
23. To center worksheet titles across a range of cells, you must
- select the cells containing the title text and use the fill handle to center the text across a range of cells
- widen the columns
- select the cells with the comma style
- none of the above
24. You can use the formula palette to
- format cells containing numbers
- create and edit formulas containing functions
- enter assumptions data
- copy a range of cells
25. To active the previous cell in a preselected range, press
- the ALT key
- the TAB key
- the ENTER key
- none of the above
26. You can select a single range of cells by
- clicking the upper-left cell in a group of cells and then pressing the SHIFT key while clicking the lower-right cell in a group of cells
- pressing the CTRL key while dragging over the desired cells
- pressing the SHIFT key and an arrow key
- dragging over the desired cells
27. Rounding errors can occur
- when you use multiplication, division, or exponentiation in a formula
- when you use addition and subtraction in a formula
- because excel uses hidden decimal places in computation
- none of the above
28. The AutoCalculate 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
- all of above
29. Which of the following is a correct order of precedence in a formula calculation?
- multiplication and division, exponentiation, positive and negative values
- multiplication and division, positive and negative values, addition and subtraction
- addition and subtraction, positive and negative values, exponentiation
- none of the above
30. In a worksheet you can select
- the entire worksheet
- rows
- columns
- all of the above