While Finding and Replacing some data in Excel, which of the following statement is valid?
✅ 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.
22
Which of the following action removes a sheet from workbook?
✅ 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.
23
By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
✅ 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.
24
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
✅ 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.
25
The Delete key of keyboard is assigned to which command in Excel?
✅ 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 + -).
26
To remove the content of selected cells you must issue command
✅ 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.
27
Edit >> Delete command
✅ 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'.
28
Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
✅ 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.
29
Which of the following you can paste selectively using Paste Special command?
✅ 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.
30
Which of the following series type is not valid for Fill Series dialog box?
✅ 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.
31
The command Edit >> Fill Across Worksheet is active only when
✅ 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.
32
The short cut key Ctrl + R is used in Excel to:
✅ 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).
33
Ctrl + P shortcut key in Excel will
✅ 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'.
34
When a row of data is to be converted into columns
✅ 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.
35
Long text can be broken down into many lines within a cell. You can do this through We have 83
✅ 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.
36
You can auto fit the width of column by
✅ 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.
37
Which of the cell pointer indicate that you can move the content to other cell?
✅ 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.
38
Which of the cell pointer indicates that you can fill series?
✅ 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...).
39
Which of the cell pointer indicates you that you can make selection?
✅ 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.
40
It is acceptable to let long text flow into adjacent cells on a worksheet when
✅ 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.