FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To hide the rows in a worksheet go to
A
Home tab
B
Home tab
C
Home tab
D
Home tab-Format
Explanation: 

Detailed explanation-1: -Select a cell within the row(s) to be hidden. On the Home command tab, in the Cells group, click Format. From the Format menu, in the Visibility section, select Hide & Unhide ยป Hide Rows. The row is hidden.

Detailed explanation-2: -If you want to hide rows based on a formula, you can do so by using a conditional formatting rule. To do this, select the rows you want to hide and then go to the Home tab > Styles group > Conditional Formatting > New Rule.

Detailed explanation-3: -On the Home tab, in the Cells group, click Format. Do one of the following: Under Visibility, click Hide & Unhide, and then click Unhide Rows or Unhide Columns.

Detailed explanation-4: -Click the Home tab in the Ribbon or press Ctrl + A (twice if necessary). In the Cells group, click Format. A drop-down menu appears. Click Visibility, select Hide & Unhide and then Unhide Rows.

There is 1 question to complete.