FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
This feature automatically adds up values in a row or column.
A
AutoCorrect
B
AutoSum
C
AutoFill
D
None of these
Explanation: 

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 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.

Detailed explanation-3: -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-4: -You can access the AutoSum command from either the Home tab or the Formulas tab, but there is a keyboard shortcut that makes it even faster: Alt+=. To use this shortcut, simply hold down the Alt key, then press the equals sign on your keyboard. Watch the video below to see examples of this shortcut in action.

Detailed explanation-5: -Autosum is a very handy tool in Excel to sum cells very fast. Autosum adds up a range of numbers automatically and places the result in a nearby cell. To perform Autosum, click a nearby cell and click Autosum on the Home tab and press Enter. In this tutorial, you will learn how to use autosum in Excel.

There is 1 question to complete.