Microsoft Excel Questions with Answers for Competitive Exams | Page 3

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.

Showing 10 of 255 questions

Per page:

Q21

Documentation should include

A destination and users of the output data
B source of input data
C a printout of the worksheets in the workbook
D all of above

Answer: Option D

Q22

Which of the following is not a worksheet design criterion?

A efficiency
B auditibility
C description
D clarity

Answer: Option C

Q23

To center worksheet titles across a range of cells, you must

A select the cells containing the title text and use the fill handle to center the text across a range of cells
B widen the columns
C select the cells with the comma style
D none of the above

Answer: Option A

Q24

You can use the formula palette to

A format cells containing numbers
B create and edit formulas containing functions
C enter assumptions data
D copy a range of cells

Answer: Option B

Q25

To active the previous cell in a preselected range, press

A the ALT key
B the TAB key
C the ENTER key
D none of the above

Answer: Option D

Q26

You can select a single range of cells by

A 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
B pressing the CTRL key while dragging over the desired cells
C pressing the SHIFT key and an arrow key
D dragging over the desired cells

Answer: Option D

Q27

Rounding errors can occur

A when you use multiplication, division, or exponentiation in a formula
B when you use addition and subtraction in a formula
C because excel uses hidden decimal places in computation
D none of the above

Answer: Option B

Q28

The AutoCalculate feature

A can only add values in a range of cells
B provides a quick way to view the results of an arithmetic operation on a range of cells
C automatically creates formulas and adds them to a worksheet
D all of above

Answer: Option B

Q29

Which of the following is a correct order of precedence in a formula calculation?

A multiplication and division, exponentiation, positive and negative values
B multiplication and division, positive and negative values, addition and subtraction
C addition and subtraction, positive and negative values, exponentiation
D none of the above

Answer: Option D

Q30

In a worksheet you can select

A the entire worksheet
B rows
C columns
D all of the above

Answer: Option D

📚 More from Computer Science & Engineering(CSE)

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search

Back to Computer Science & Engineering(CSE)

Microsoft Excel Questions and Answers

📚 More from Computer Science & Engineering(CSE)

Computer Science & Engineering(CSE)

Other Subjects

Microsoft Excel Questions and Answers

📚 More from Computer Science & Engineering(CSE)

Computer Science & Engineering(CSE)

Other Subjects

Report a Problem