DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Autocorrect
|
|
|
Autocalculate
|
|
|
Auto adjust
|
|
|
Autosum
|
Detailed explanation-1: -If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you’re done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
Detailed explanation-2: -If you want to sum up a column in Excel and keep the result in your table, you can employ the AutoSum function. It will automatically add up the numbers and will show the total in the cell you select.
Detailed explanation-3: -One quick and easy way to add values in Excel is to use AutoSum. Just select an empty cell directly below a column of data. Then on the Formula tab, click AutoSum > Sum.
Detailed explanation-4: -Excel Basics: AutoFill: AutoSum The AutoSum feature makes it easy to total columns or rows. Excel will guess what cells you want to add based on which cells are empty. A neat trick! AutoFill can help copy a formula across a row or down a column.