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
201. In Excel you can use the drag and drop method to
- Copy cel contents
- Delete cells contents
- Add cell contents
- All of above
202. In Excel to balance your checkbook, your best method is
- Copy your check amounts into excel so that you'll have a neat printout to work on
- Use Excel to check your arithmetic
- Downloads the Checkbook register templates from Templates on Microsoft Office Online
- All of above
203. In Excel which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the resulting a difference cell
- Count
- Average
- Sum
- None of above
204. In Excel to name a constant, you use the ................... dialog box
- Create names
- Define name
- Paste name
- Format cells
206. In Excel the function caculates depreciation at the same amount each year over an asset's useful life
- DB (fixed-declining balance)
- SLN (straight line)
- Single Accounting
- Double Accounting
207. In Excel to center wrksheet titles across a rage of cell, you must
- Select the cells containing the title text and use the fill handle to center the text across a range fo cells
- Widen the columns
- Select the cells containing the title text and use the fill handle to center the text
- Widen the column
208. In Excel when integration Ms-Word and Excel Word is usually the
- Server
- Source
- Client
- None
209. In Excel charts tips can
- Shw the formatting of a data label
- Show the name f a data series
- Show the value of data point
- Both (B) and (C)
210. In Excel the Name box
- shows the location of the previously active cell
- Appears the left of the formula bar
- Appears below the status bar
- Appears below the menu bar