DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Single clicked
|
|
|
Double-clicked
|
|
|
Triple clicked
|
|
|
Right clicked
|
Detailed explanation-1: -The fill function can be double clicked to complete formulas in a range: Note: For the double click to work it has to see a recognizable pattern. For example: by using headers, or with the formulas in the columns or rows next to the data.
Detailed explanation-2: -You can also press Ctrl+D to fill the formula down in a column. First select the cell that has the formula you want to fill, then select the cells underneath it, and then press Ctrl+D. You can also press Ctrl+R to fill the formula to the right in a row.
Detailed explanation-3: -If you double click the bottom right corner of a cell, Excel will copy the data in that cell down until it hits the last adjacent cell with data in it.
Detailed explanation-4: -Place the mouse pointer over the fill handle in the bottom right corner of cell F1. When the mouse pointer changes to the small black plus sign ( + ), double click on the fill handle. The formula in cell F1 should be copied to cells F2:F6.
Detailed explanation-5: -Explanation: The fill function can be double-clicked to complete formulas in a range.