DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
type each cell location and type a plus sign in between each
|
|
|
use the SUM function
|
|
|
use the TOTAL function
|
|
|
click on each cell and type a plus sign in between each
|
Detailed explanation-1: -Answer: 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: -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. The SUM function totals one or more numbers in a range of cells.
Detailed explanation-3: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three.
Detailed explanation-4: -Excel SUM is a math and trig function that adds values. The syntax of the SUM function is as follows: SUM(number1, [number2], …) The first argument is required, other numbers are optional, and you can supply up to 255 numbers in a single formula.
Detailed explanation-5: -A function in a spreadsheet program that inserts a formula in the selected cell that adds the numbers in the column above it. It sets the range of cells by looking for numeric data above the selected cell.