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
211. In Excel how do you change column width to fit the contents >
- Single-click the boundary to the left to the column heading
- Double click the boundary to the right of the column heading
- Press Alt and single click anywhere in the column
- All of above
212. In Excel when you work with large worksheets, you may need to
- Size the worksheet to fit on the specific number of pages
- Add and remove page breaks
- Specify only certain print areas
- All of above
213. In excel Hyperlinks cannot be
- Special shapes like stars and banners
- Drawing objects like rectangles ovals
- Pictures
- All can be hyperlink
214. In excel you can use the horizontal and vertica scroll bars to
- Split a worksheet into two panes
- View different rows and columns
- Edit the contents of a cell
- View different worksheets
215. What do we call a computer program that organizes data in rows and columns of cells ? you might use this type of program to keep a record of the money you earned moving lawns over the summer.
- Spreadsheet program
- Database program
- Wordprocessor program
- Desktop publisher program
216. In Excel you can add an image t template by cliking the Insert Picture from File button on the ......... Toolbar
- Standard
- Formatting
- Drawing
- Picture
217. In Excel to drag a selected range of data to another worksheet in the same workbook,l use the
- Tab key
- Alt key
- Shift key
- Ctrl key
218. In Excel when creating a vertical page break
- The active cell must be A1
- The active cell can be anywhere in the worksheet
- The active cell must be row 1
- The Active cell must be in column A
219. In Excel to activate the previous cell in preselected range, press
- The Alt Key
- the Tab key
- The Enter key
- None of above
220. In Excel when the formula bar is activated you can use
- The edit formula button
- the Cancel button
- the Enter button
- all of above