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
161. This tye of software contains rows and columns.
- Drawing
- Spreadsheet
- Database
- Word processing
162. In Excel to open an existing workbook, you can click the Open button on the.........toolbar
- drawing
- Formatting
- Forms
- Standard
163. In Excel you can activate a cell by
- Pressing the Tab key
- Clicking the cell
- Pressing an arrow key
- All of above
164. In Excel the following setup options cannot be set in the page setup dialog box ?
- Printer selection
- Vertical or horizontal placement
- Orientation
- Row and column titles
165. In Excel term refers to a specific set of values saved with the workbook
- Range
- Scenario
- Trend line
- What-if analysis
166. In Excel got functions ? No ? You need the insert function dialog box. How do you get it ?
- Right click a cell and then click insert
- Click the insert menu and then click function
- Type = in a cell
- All of the above
167. In Excel the following describes how to select all the cells in a single column ?
- Right click on column and select Pick from list
- Use data - text to columns menu item
- Left click the gray column title button
- Pressing Ctrl + A on the key board
168. In Excel when you use the fill effects in the format data series dialog box, you cannot
- Rotate text on the chart
- Select a fore ground color
- Select a pattern
- Select a background colour
169. In Excel paper speradsheets can have all the same advantages as an electronic sperad sheet except which of the following ?
- Rows and columns
- Headlings
- Speed
- None
170. In Excel the following is not a basic step in creating a worksheet
- Save the workbook
- Modify the worksheet
- Enter text and data
- Copy the worksheet