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
121. In Excel you can select a single range of cells by
- Clicking the upper-left cell in a 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
122. In excell to copy cell contents using drag and drop press the
- End key
- Shift key
- Ctrl key
- Esc key
123. In Excel when you copy a formula
- Excel erases the original copy of the formula
- excel edits cell references in the newly copied formula
- Excel adjusts absolute cell references
- Excel doesn't adjust relative cell references
124. In Excel autofill feature
- Extends a sequential series of data
- Automatically adds range of cell values
- Applies a boarder around the selected cells
- None of the above
125. In Excel which menu option can be sued to split windows into two
- Format > window
- View > window > split
- Window > split
- View > split
126. In Excel whch of the following special function keys allow the content in cell
- Esc
- Shift
- Return
- Tab
127. In Excel which is not an advantage of using computerized spreadsheets ?
- Flexibility of moving entries
- Speed of calculation
- Ability of generate tables
- Cost of initial setup
128. In Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
- Unfreeze panes command on the window menu
- Freeze panes command on the window menu
- Hold titles command on the edit menu
- Split command on the window menu
129. In excel the following will not cut information
- Pressing Ctrl + C
- Selecting Edit > Cut from the menu
- Clicking the Cut button on the standard
- Pressing Ctrl + X
130. In Excel which of the following is not a way to complete a cell entry ?
- Pressing enter
- Pressing any arrow key on the keyboard
- Clicking the Enter button on the Formula bar
- Pressing spacebar