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
151. In Excel AutoCalculate will quickly add selected cells if you
- right click on the status bar and select Sum
- Click the Auto Calculate button on the toolbar
- use the key combination Ctrl + $
- double click the selection
152. In Excel the cell labeled F5 refers to
- row F column 5
- Column F row 5
- Function available in cells
- function key F4
153. In Excel when you are typing an equation into a cell the first thing that must be entered is
- The first cell referenced
- Parenthesis
- Quotation marks
- an equal sign
154. In Excel using the Auto Sum button will replace in the selected cell
- the sum of values in the cell's column
- nothing until you select a range of cells
- the sum of the cell's row unless you change the range
- a formula which will add values in the range Excel guesses you want to add
155. In Excel book 1 is an example of how .......are numbered and named during each work session
- Active cell
- Formula bar
- Menu bar
- Name box
156. In Excel the following displays the contents of the active cell
- Active cell
- Formula bar
- Menu bar
- Name box
157. In Excel Graphics objects on a chart are used to
- Add emphasis to chart data
- Add interest to a chart
- Help explain the chart data
- All the above
158. In Excel to select a column the easiest method is to
- Doube click any cell in the column
- Drag from the top cell in the column to the last cell in the column
- Click the column heading
- Click the column label
159. In Excel to select an individual data marker or data label, you must
- Double clik the data series
- Right click selected marker
- Click once to select the series markers r labels and click the desired marker or label again
- Double click the marker or label
160. In Excel to delete and embedded object, first
- Double click the object
- Select the object by clicking it
- Press the Shift + Delete keys
- Select it and then press Delete key