Question 1

While Finding and Replacing some data in Excel, which of the following statement is valid?

Accepted Answer

Correct Answer: You can Find and Replace within the sheet or workbook

Explanation: Excel's Find & Replace tool is powerful. You can set the scope to search only the current 'Sheet' OR the entire 'Workbook' (all sheets). This validates statement A. Excel definitely DOES have 'Match Case' and CAN replace text, making B and C incorrect.

Question 2

Which of the following action removes a sheet from workbook?

Accepted Answer

Correct Answer: Select the sheet, then choose Edit >> Delete Sheet

Explanation: To permanently remove a worksheet, the command is 'Delete Sheet'. In older Excel menus, this was under 'Edit'. Option B only 'Hides' the sheet (it's still there, just invisible). Option C inserts a new one. Therefore, only A effectively removes it.

Question 3

By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?

Accepted Answer

Correct Answer: Right click on Sheet Tab of third sheet and choose Delete from the context menu

Explanation: The quickest way to remove an unwanted sheet is to Right-Click on its tab (at the bottom of the screen, e.g., 'Sheet3') and select 'Delete' from the pop-up menu. You can also delete it from the Home ribbon > Delete > Delete Sheet.

Question 4

If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

Accepted Answer

Correct Answer: From Edit menu choose Clear and then Formats

Explanation: Excel separates data from design. If you want to keep your data but strip away all bold, colors, and borders, you use 'Edit > Clear > Formats'. This resets the selected cells to the default plain style while keeping the text and numbers safe.

Question 5

The Delete key of keyboard is assigned to which command in Excel?

Accepted Answer

Correct Answer: Edit >> Clear >> Contents

Explanation: Pressing the 'Delete' key on the keyboard performs the 'Clear Contents' action. It removes text and numbers but leaves the formatting (colors, borders) and comments intact. It does NOT delete the actual cell object (which would require Ctrl + -).

Question 6

To remove the content of selected cells you must issue command

Accepted Answer

Correct Answer: Edit >> Clear >> Contents

Explanation: To erase what is written inside a cell without deleting the cell itself (so rows don't shift), you use the 'Clear Contents' command. This is equivalent to pressing the 'Delete' key on your keyboard. 'Edit >> Delete' would remove the cell entirely.

Question 7

Edit >> Delete command

Accepted Answer

Correct Answer: Deletes selected cells

Explanation: The 'Delete' command (found in the Edit menu or Right-click menu) physically removes the cell itself from the sheet structure, causing surrounding cells to shift up or left to fill the gap. To remove just the text/content without shifting cells, you would use 'Clear Contents'.

Question 8

Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

Accepted Answer

Correct Answer: Divide

Explanation: The 'Operation' section of Paste Special allows you to perform math on the destination cells using the copied data. The valid operations are Add, Subtract, Multiply, and Divide. Options like Square, Percentage, or Goal Seek are not part of the paste operations.

Question 9

Which of the following you can paste selectively using Paste Special command?

Accepted Answer

Correct Answer: All of above

Explanation: Paste Special is extremely versatile. You can choose to paste only the 'Formulas' (without formatting), only the 'Formats' (colors/fonts without text), or even only the 'Data Validation' rules (dropdowns/restrictions) applied to a cell. Hence, all options are correct.

Question 10

Which of the following series type is not valid for Fill Series dialog box?

Accepted Answer

Correct Answer: Time

Explanation: In the 'Series' dialog box (Edit > Fill > Series), the available types are Linear, Growth, Date, and AutoFill. While there are units for Date (like Day, Month, Year), there is no top-level Series Type called 'Time'. Therefore, 'Time' is the invalid option here.

Question 11

The command Edit >> Fill Across Worksheet is active only when

Accepted Answer

Correct Answer: When many sheets are selected

Explanation: 'Fill Across Worksheets' is a powerful feature to copy data/formatting to multiple sheets at once. This option remains grayed out (inactive) unless you have 'Grouped' (selected) multiple sheet tabs at the bottom. Once grouped, you can fill data across all of them simultaneously.

Question 12

The short cut key Ctrl + R is used in Excel to:

Accepted Answer

Correct Answer: Fill the selection with active cells to the right

Explanation: Ctrl + R is the shortcut for 'Fill Right'. If you have data in the first cell of a row and you select blank cells to its right, pressing Ctrl + R copies that data into all selected cells instantly. It does NOT right-align text (that doesn't have a standard single Ctrl shortcut).

Question 13

Ctrl + P shortcut key in Excel will

Accepted Answer

Correct Answer: None of these

Explanation: The universal shortcut 'Ctrl + P' opens the 'Print' dialog box to print the document. The book options seem to be confusing it with other shortcuts (e.g., Ctrl+D is for Fill Down, Ctrl+Shift+F is for Font). Since 'Open Print Dialog' is not listed, the correct answer is 'None of these'.

Question 14

When a row of data is to be converted into columns

Accepted Answer

Correct Answer: Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK

Explanation: To switch data from rows to columns (or vice versa), we use the 'Transpose' feature. The correct process is: 1. Copy the data. 2. Click on a NEW cell (destination). 3. Go to Paste Special. 4. Check the 'Transpose' box. Option B is incorrect because it mentions copying a 'column' when the question asks about a 'row', and C is incorrect because Transpose is not in Format Cells.

Question 15

Long text can be broken down into many lines within a cell. You can do this through We have 83

Accepted Answer

Correct Answer: Wrap Text in Format > Cells

Explanation: To make long text fit inside a cell by stacking it on multiple lines (wrapping), you use the 'Wrap Text' feature. This is found in the 'Format Cells' dialog (Alignment tab) or by clicking the 'Wrap Text' button on the Home tab ribbon.

Question 16

You can auto fit the width of column by

Accepted Answer

Correct Answer: Double clicking on column right border on column header

Explanation: To instantly adjust a column's width to fit its longest content (AutoFit), you must Double-Click the boundary line on the RIGHT side of the Column Header (e.g., the line between A and B to fit A). Doing it on the left side adjusts the previous column.

Question 17

Which of the cell pointer indicate that you can move the content to other cell?

Accepted Answer

Correct Answer: Mouse Pointer with anchor at the tip

Explanation: To move data using drag-and-drop, you hover over the border of the selected cell. The cursor changes to an arrow with a four-way move icon (sometimes described as an anchor or arrow). Clicking and dragging with this cursor moves the actual data to a new location.

Question 18

Which of the cell pointer indicates that you can fill series?

Accepted Answer

Correct Answer: small thin plus icon

Explanation: When you hover your mouse over the bottom-right corner of the active cell (the Fill Handle), the cursor changes to a 'Small Thin Black Plus'. This indicates that you are ready to use 'AutoFill' to copy data or extend a series (like 1, 2, 3...).

Question 19

Which of the cell pointer indicates you that you can make selection?

Accepted Answer

Correct Answer: Doctor's symbol (Big Plus)

Explanation: Excel has different cursors for different jobs. The default cursor is a thick white cross (often called the 'Doctor's Symbol' or Big Plus). This specific cursor is used to SELECT cells. If you see this, clicking and dragging will highlight a range.

Question 20

It is acceptable to let long text flow into adjacent cells on a worksheet when

Accepted Answer

Correct Answer: no data will be entered in the adjacent cells

Explanation: Excel allows text to visually 'spill over' into the next cell if it is too long to fit. However, this only happens if the neighbor cell is EMPTY. If the adjacent cell contains any data, the long text will be cut off (truncated) at the border.

MS Excel MCQs