DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Count
|
|
|
Average
|
|
|
Sum
|
|
|
None of the above
|
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: -The SUMIF function, also known as Excel conditional sum, is used to add up cell values based on a certain condition. The function is available in Excel 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, and lower.
Detailed explanation-3: -SUMIF function adds all the numeric values in a range of cell ignoring those which are not numeric and place the result in a different cell.
Detailed explanation-4: -COUNTIF formula to count all cells with text.
Detailed explanation-5: -Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20). In this example, if five of the cells in the range contain numbers, the result is 5.