DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Insert, Table
|
|
|
Insert, Row
|
|
|
Insert, Column
|
|
|
Delete, Column
|
Detailed explanation-1: -To insert a single column: Right-click the whole column to the right of where you want to add the new column, and then select Insert Columns. To insert multiple columns: Select the same number of columns to the right of where you want to add new ones. Right-click the selection, and then select Insert Columns.
Detailed explanation-2: -On the Page Layout tab, click Columns, then click the layout you want. To apply columns to only part of your document, with your cursor, select the text that you want to format. On the Page Layout tab, click Columns, then click More Columns.
Detailed explanation-3: -To add a column to the left of the selected cell, click Insert Left. To add a column to the right of the selected cell, click Insert Right. Note: To add multiple columns at once, using your mouse, drag to select an equal number of columns to the amount that you want to add, and then click Insert Left or Insert Right.