HP Computer Practice Set 112 | Interactive MCQ Mock Test

1. A company wants to evaluate the impact of different sales targets and cost values in their budget worksheet. Which MS Excel feature should they use for this analysis?

Computer 📄 JOA IT (2026)

A. Data Table B. Remove Duplicates C. AutoFilter D. Scenario Manager

2. A company wants to evaluate the impact of different sales targets and cost values in their budget worksheet. Which MS Excel feature should they use for this analysis?

Computer 📄 JOA IT (2026)

A. Data Table B. Remove Duplicates C. AutoFilter D. Scenario Manager

3. A company wants to evaluate the impact of different sales targets and cost values in their budget worksheet. Which MS Excel feature should they use for this analysis?

Computer 📄 JOA IT (2026)

A. Data Table B. Remove Duplicates C. AutoFilter D. Scenario Manager

4. After applying a filter to a table in Excel, what happens if you copy and paste the visible rows into a new worksheet?

Computer 📄 JOA IT (2026)

A. Only the visible (filtered) rows are copied and pasted. B. The filter settings are transferred but not the data. C. The filter is removed from the original worksheet. D. All rows, including hidden ones, are copied.

5. After applying a filter to a table in Excel, what happens if you copy and paste the visible rows into a new worksheet?

Computer 📄 JOA IT (2026)

A. Only the visible (filtered) rows are copied and pasted. B. The filter settings are transferred but not the data. C. The filter is removed from the original worksheet. D. All rows, including hidden ones, are copied.

6. After applying a filter to a table in Excel, what happens if you copy and paste the visible rows into a new worksheet?

Computer 📄 JOA IT (2026)

A. Only the visible (filtered) rows are copied and pasted. B. The filter settings are transferred but not the data. C. The filter is removed from the original worksheet. D. All rows, including hidden ones, are copied.

7. After applying a filter to a table in Excel, what happens if you copy and paste the visible rows into a new worksheet?

Computer 📄 JOA IT (2026)

A. Only the visible (filtered) rows are copied and pasted. B. The filter settings are transferred but not the data. C. The filter is removed from the original worksheet. D. All rows, including hidden ones, are copied.

8. After applying a filter to a table in Excel, what happens if you copy and paste the visible rows into a new worksheet?

Computer 📄 JOA IT (2026)

A. Only the visible (filtered) rows are copied and pasted. B. The filter settings are transferred but not the data. C. The filter is removed from the original worksheet. D. All rows, including hidden ones, are copied.

9. After applying a filter to a table in Excel, what happens if you copy and paste the visible rows into a new worksheet?

Computer 📄 JOA IT (2026)

A. Only the visible (filtered) rows are copied and pasted. B. The filter settings are transferred but not the data. C. The filter is removed from the original worksheet. D. All rows, including hidden ones, are copied.

10. After applying a filter to a table in Excel, what happens if you copy and paste the visible rows into a new worksheet?

Computer 📄 JOA IT (2026)

A. Only the visible (filtered) rows are copied and pasted. B. The filter settings are transferred but not the data. C. The filter is removed from the original worksheet. D. All rows, including hidden ones, are copied.

11. After applying a filter to a table in Excel, what happens if you copy and paste the visible rows into a new worksheet?

Computer 📄 JOA IT (2026)

A. Only the visible (filtered) rows are copied and pasted. B. The filter settings are transferred but not the data. C. The filter is removed from the original worksheet. D. All rows, including hidden ones, are copied.

12. A user in MS Excel (Microsoft 365 and Office 2021) wants to present survey results with a visual ranking of categories. Which chart type will best facilitate this objective?

Computer 📄 JOA IT (2026)