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?
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.