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
111. In Excell cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is
- B1-G10
- B1:G10
- B1;G10
- B1:G10
112. In Excel advantage of using a spreadsheet is
- Calculations can be done automatically.
- Changing data automatically updates calculations
- More flexibility
- All of the above
113. In Excel intersection of a row and column is called:
- Cata
- A field
- A cell
- An equation.
114. There are three types of data found in a sperad sheet
- data, words, numbers
- Equations, data, numbers
- words, numbers, labels
- numbers formulas, labels
115. In Excel to select a column the easiest method is to
- Double click any cell in the column
- Drag from the top cell in the colum to the last cell in the column
- Click the column heading
- Click the column label
116. In Excel if you press............. the cell accepts your typing as its contents.
- Enter
- Ctrl + Enter
- Tab
- Insert
117. In Excel to view a cell comment
- Click the edit comment command on the insert menu
- Click the display comment command on the window menu
- Position the mouse pointer over the cell
- Click the comment command on the view menu
118. In Excel when you want to insert a black imbedded excel object in a word document you can
- Click the object command on the insert menu
- Click the office links button on the standard toolbar
- Click the create worksheet button on the formatting toolbar
- Click the import excel command on the file menu
119. In Excel to save a workbook, you
- Click the save button on the standard toolbar from the menu
- Press Ctrl + F5
- Click Save on the Windows Start button
- Select Edit>Save
120. In Excel you can edit a cell by
- Clicking the formula button
- Double clicking the cell to edit it in-place
- Selecting Edit>Edit Cell from the menu
- None of above