Basic Computer: MS Excel Charts & Data Tools MCQ - Practice Questions with Answers

The list asks for common Excel data-tool uses. Remove Duplicates is used when repeated rows or repeated values in selected columns need to be removed. Data Validation controls acceptable cell entries, such as allowing only numbers in a range or choosing from a list. Text to Columns separates text from one column into multiple columns, usually by a delimiter or fixed width. Matching these gives 1-c, 2-b and 3-a, so option A is the correct combination.

The word AutoFilter points to narrowing what is visible in an Excel table. When a filter is applied, Excel displays only the rows that satisfy the selected condition, such as a city name, a date range or a mark above a limit. The other rows remain in the worksheet and can be shown again by clearing the filter. It is not a delete command, a formula-conversion tool or a chart command. Therefore, option B states the correct purpose.

The question asks for the incorrect statement. In an Excel record table, one row usually holds one complete record, such as name, roll number and marks. If only one column is sorted and the related columns are left unchanged, values can become mismatched across rows. Excel often warns the user with options such as Expand the selection for this reason. Text sorting, number sorting, and expanding the selection are normal and correct behaviours. Hence option A is the incorrect statement.

Data Validation controls what a user may enter in a cell, such as allowing only numbers in a range or values from a drop-down list. Remove Duplicates checks the selected range and removes repeated records based on the chosen columns. Text to Columns splits text stored in one column into separate columns, often using a delimiter such as a comma or space. Matching these uses gives 1-b, 2-c and 3-a. The other options either swap the tools or confuse entry restriction with text splitting.

Filtering in Excel is a display tool, not a deletion tool. The cue is the word temporarily in Statement 1. When a filter is applied, rows that do not satisfy the selected condition are hidden from view, but the data remains in the worksheet. Removing or clearing the filter brings those rows back. Permanent deletion is a separate action, such as deleting rows manually. Therefore, Statement 1 is true because it describes filtering correctly, and Statement 2 is false because it wrongly treats filtering as deletion.