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
102. In Excel you can use a function to combine text from two cells into one cell. But you can use an operator to do the same thing. Which operator is that ?
- & (ampersan (D)
- = (equal sign)
- (space)
- All of the above
104. In Excel to add two cells (A1 and A2) together you use the following formula
- = A1 + A2
- =Add (A1 + A2)
- =together(A1:A2)
- A1 plus A2
105. In Excel on an excel sheet the active cell in indicated by
- A dark wide boarder
- A dotted border
- A blinking border
- None of above
106. In Excel on an Excel sheet the active cell in indicated by
- A dark wide border
- A dotted border
- A blinking border
- None of above
107. In Excel using the F11 shortcut key to create a chart on chart sheet creates
- A default chart
- A 2-dimensional column chart
- A 2-dimensional bar chart
- A 3-dimensional line chart
108. In Excel you can print
- A range of cells by range name
- An entire worksheet
- A single worksheet
- All of the above
109. In Excel you can create only a horizontal page break by first selecting
- A row below the row where you want the page break to occure
- A cell in row 1
- A cell in column A
- (A) and (C)
110. In Excel you can create hyperlinks from excel workbook to
- A webpage on company internet
- A web page on the internet
- Other office application documents
- All