DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Fill
|
|
I am self
|
|
Find
|
|
Clear
|
Detailed explanation-1: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10.
Detailed explanation-2: -Select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges. You can also select the first cell or range of cells, and then press SHIFT+F8 to add another nonadjacent cell or range to the selection.
Detailed explanation-3: -The SUM function adds values. This is used to add individual values, cell references or ranges or a mix of all three. Select a cell next to the numbers you want to sum, click on the AutoSum of Home tab and click the enter button.
Detailed explanation-4: -Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells.