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
191. In Excel which of the following is not a valid data type in excel
- Number
- Character
- Label
- Data/time
192. Excell worksheet cells work very similarly to what ommon element of the windows graphical user interface
- Option buttons
- List boxes
- Text boxes
- Combo boxes
193. In Excel which of the following options is not located in Page Setup Dialog box ?
- Page Break Preview
- Page Orientation
- Margins
- Headers and Footers
194. In excel one want to track the progress of the stck market on a daily basis. which type of charts should one use ?
- Pie chart
- Row chart
- Line chart
- Column chart
195. In excel without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a speradsheet ?
- Press Ctrl + Home
- press Home
- Press Shift + Home
- Press Alt + Home
196. Which of the following methods cannot be used to edit the contents of a cell in Excel ?
- Press the alt Key
- Clicking the formula bar
- Pressing the F2 key
- Double clicking the cell
197. In Excel if you begin typingg and entry into a cell and then realize that you don't want your entry placed into a cell, you
- Press the Erase key
- Press Esc
- Press the Enter button
- Press the Edit formula button
198. In Excel defaut style for new data keyed in a new workbook is
- Comma
- Currency
- Normal
- Per cent
199. In Excel LEN function does what ?
- Compares the content in two cells
- Counts the numbers of characters in a cell
- Deletes extra space in text
- All of above
200. In Excel this function onverts miles to kilometers, kilograms to pounds, and so on
- Convert
- Product
- Change
- All of above