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
171. In Excel what does SUMIF function do ?
- Adds up cell values based on a c ondition
- Adds all the numbers in a range of cells
- Returns a subtotal in a list or database
- All of above
172. In Excel you can insert labels for
- All the data markers on a chart
- A data series
- A selected data marker
- All of the above
173. In Excel Tab scrolling buttons
- Allow you to view a different worksheet
- Allow you to view additional worksheet row down
- Allow you to view additional worksheet columns to the right
- Allow you to view additional sheet tabs
174. In Excel All macro keyboard shortcuts include the .........key
- Alt
- Ctrl
- F11
- Shift
175. In Excel to open the Format Cells dialog box, press
- Alt + 1
- Ctrl + 1
- Ctrl + Sjoft + 1
- F1
176. In Excel you can add a hyperlink to your worksheet by pressing
- Alt + K
- Ctrl + H
- Ctrl + K
- Ctrl + Shift + K
177. In Excel to move to the previous worksheet, press
- Alt + PgUp
- Ctrl + PgUp
- Ctrl + PgDn
- Shift + Tab
178. In Excel you can select a single range of cells by
- Clicking the upper-left cell in group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
- Pressing the Ctrl key while dragging over the desired cells
- Pressing the Shift key and an arrow key
- Dragging over the desired cells
179. In Excel which of these will not select all the cells in a document ?
- Clicking three times with the right mouse button in the spreadsheet
- Using the Edit Select all menu
- Pressing Ctrl + A on the keyboard
- Pressing Ctrl + A on the keyboard
180. In Excel you can use the formula palette to
- Format cells containing numbers
- Create and edit formulas containing functions
- Enter assumptions data
- Copy a range of cells