DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
TO convert a range of cells into a table go to:
|
|
Home tab-> Conditional Formatting
|
|
|
Insert tab
|
|
|
Home tab
|
|
|
Insert tab
|
Explanation:
Detailed explanation-1: -Convert range to table in Excel. The quickest way to convert a data range to a table is this: Select any cell in your dataset and press the Ctrl + T keys together.
Detailed explanation-2: -Tables can be reversed and converted back to range. Tables can be converted to ranges by selecting a cell in the table range and clicking on the Convert to Range command. The command to convert to range is found in the Table Design tab, in the Tools group.
There is 1 question to complete.