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
231. In excel which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet ?
- use Ctrl to select all three cells, then click the paste button on the standard toolbar
- Copy the selected cell, then select the other two cells, click style on the format menu, then click modify
- Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
- All of above
232. To edit data in an embedded Excel worksheet object in a word document
- Use Ctrl to selet all three cells, then click the paste button on the standard toolbar
- Copy the selected cell, then select the other two cells, click style on the format menu then, click modify
- Click format painter on the Formatting toolbar twice then click in e ach cell you want to copy the formatting to
- All of above
233. In Excel Status indicators are located on the
- Verticall Scroll bar
- Horizontal scroll bar
- Formula bar
- Standard toolbar
234. In Excel Rounding errors can occur.
- When you use multiplication, dividion, or exponentiation in a formula
- When you use addition and subtraction in a formula
- Because excel uses hidden decimal places in computation
- When you shows the results of formulas with different decimal places that the calculated results
235. In Excel one can copy data or formulas
- With copy , paste and cut commands on the edit menu
- With commands on ta shortcut menu
- With buttons on the standard toolbars
- All of the above
236. In Excel you cannot link excel worksheet data to a word document
- With the right drag method
- With a hyperlink
- With the copy and paste special commands
- With the copy and paste buttons on the standard toolbar
237. An excel workbook is a collection of
- Workbooks
- Worksheets
- Charts
- Worksheets and charts
239. In Excel one can use the format painter mutiple times before one turn it off by
- You can use the format painter button only one time when you clik it
- Double clicking the format painter button
- Pressing the Ctrl key and clicking the for mat painter button
- Pressing the Alt key and clicking the format painter button
240. In Excel Status indiators are located on the
- Vertical scrollbar
- Horizontal Scroll bar
- Formula bar
- Formatting toolbar