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
71. In Excel it is acceptable of let long text flow into adjacent cells on a worksheet when
- Data will be entered in the adjacent cells
- No data will be entered in the adjacent cells
- There is not suitable abbreviation of the text
- There is not time to format the next
72. In Excel how can you delete a record ?
- Delete the column from the worksheet
- Select Data > Form from the menu to open the Data form dialog box, fnd the record and click the Delete button
- Select Data > Delete Record from the menu
- Click the Delete button on the Standard toolbar
73. Right clicking something in Excel
- Deletes the object
- Nothing the right mouse button is there ffor left handed people
- Opens a shortcut menu listing everything you can do to the object
- Selects the object
74. In Excel documentation should include
- Destination and users of the output data
- Source of input data
- Information on the purpose of the workbook
- All of the above
76. In Excel to delete an embeded objects, first
- Double click the object
- Select the object by clicking it
- Press the Shift + Delete keys
- Select it and then press the delete key
77. In Excel comments can be added to cells using
- Edit > Comments
- Insert > Comments
- File > Comments
- View > Comments
78. In Excel which of the following is not a worksheet design criterion ?
- Efficiency
- Aditibility
- Description
- Clarity
79. In Excel suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page ?
- Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles.
- Click page setup on the file menu, click the page tab, click the options button, then enter your choices.
- Click page setup on the file menu, click the sheet tab, and make a selection under the print heading.
- All of above
80. In Excel a fast way to add up this column of number is to click in the cell below the numbers and then
- Click subtotals on the data menu
- View the sum in the formula bar
- Click the autosum button on the standard toolbar, then press enter
- All of above