DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Sum
|
|
|
Max
|
|
|
Min
|
|
|
Average
|
Detailed explanation-1: -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-2: -=SUM(ABOVE) adds the numbers in the column above the cell you’re in. =SUM(LEFT) adds the numbers in the row to the left of the cell you’re in. =SUM(BELOW) adds the numbers in the column below the cell you’re in. =SUM(RIGHT) adds the numbers in the row to the right of the cell you’re in.
Detailed explanation-3: -The SUM Function[1] is categorized under Excel Math and Trigonometry functions. The function will sum up cells that are supplied as multiple arguments. It is the most popular and widely used function in Excel. SUM helps users perform a quick summation of specified cells in MS Excel.
Detailed explanation-4: -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-5: -Python’s built-in function sum() is an efficient and Pythonic way to sum a list of numeric values. Adding several numbers together is a common intermediate step in many computations, so sum() is a pretty handy tool for a Python programmer.