DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Click Subtotals on the Data menu
|
|
|
View the sum in the formula bar
|
|
|
Click the AutoSum button on the Standard toolbar, then press ENTER
|
|
|
None of the above
|
Detailed explanation-1: -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. Excel will automatically sense the range to be summed.
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. To avoid any additional actions like range selection, click on the first empty cell below the column you need to sum.
Detailed explanation-3: -The quickest and easiest way to sum a range of cells is to use the Excel AutoSum button. It automatically enters an Excel SUM function in the selected cell.