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
141. In Excel when integrating word and excel, word is usually the
- Server
- Destination
- Client
- Both (A) and (C)
142. In Excel when a label is too long to fit within a worksheet cell, you typically must
- Shorten the label
- Increase the column width
- Decrease the column width
- Adjust the row height
143. In Excel 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
144. In Excel comments put in cells are called
- smart tip
- Cell tip
- Web tip
- Soft tip
145. In Excel 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
- Edit the contents of a cell
- View different worksheets
146. In Excel Multiple calculations can be made in a single formula using
- Standard formula using
- Array formulas
- Complex formulas
- Smart formula
147. Excel to Select several cells or ranges that are not touching each other, you would ..........while selecting
- hold down the Ctrl key
- hold down the Shift key
- hold down the Alt key
- Hold down Ctrl + Shift key
148. In Excel a certain spreadsheet shows in page Break Preview that cells in Rows 1-25 have white background. the cells in row 26 that contain data have a dark grey background, when you click the print button
- Nothing will print because some cells with data have been omitted
- Only the cells with gray background will print
- the whole sheet will print
- Only the cells with white background will print
149. In Excel constant is another name for this type of data
- number
- Equation
- Formula
- Description
150. In Excel the view that puts a blue a blue line around each page that would be printed is the
- Print preview
- Normal View
- Page Break Preview
- Split view