FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

BASICS OF BIG DATA

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A function that automatically identifies and adds ranges of cells in your worksheet.
A
AutoSum
B
AutoFill
C
Cell Address
D
Function
Explanation: 

Detailed explanation-1: -AutoSum – A function that automatically identifies and adds ranges of cells in your worksheet. Cell – The rectangular shaped area on a worksheet that is created by the intersection of columns and rows.

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. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.

Detailed explanation-3: -You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM(A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.

Detailed explanation-4: -Use AutoSum by selecting a range of cells that contains at least one numeric value. Then on the Formulas tab, click AutoSum > Count Numbers.

Detailed explanation-5: -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.

There is 1 question to complete.