PrepAway - Latest Free Exam Questions & Answers

Which of the following options will he choose to accomplish the task with least amount of effort?

Rick is working on a worksheet in Excel 2010. He has entered data in the worksheet as shown in the image below:

He wants to hide column B of the worksheet. Which of the following options will he choose to
accomplish the task with least amount of effort?

PrepAway - Latest Free Exam Questions & Answers

A.
Select the column B > Use Ctrl+X command to cut the column > Paste the column in the different
worksheet.

B.
Select the column B > Use Ctrl+X command to cut the column > Paste the column at the last
column in the worksheet.

C.
Select the column B > Click the Hide option in the Window ribbon at the View tab.

D.
Select the column B > Right-click on the selected column > Click the Hide option in the menu.

Explanation:
According to the question, Rick wants to hide column B. Take the following steps to hide a column:
1.Select the column you want to hide.

2.Right click on the selected column. Click the Hide option on the menu.

3.The selected column will hide.

Answer B and A are incorrect. These options will move the contents of the column. They will not
hide the column.
Answer C is incorrect. This will hide the current window opened in Excel.


Leave a Reply