USING MICROSOFT EXCEL
WORKBOOK THEMES
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
True
|
|
False
|
|
Either A or B
|
|
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: -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: -If the adjacent cell has a specified text, we can use the function: =SUMIF(Text Range, ” Text, ” cells range for sum). For example, if we have data on a company’s sales and want to calculate the total sales or need to sum based on names having specific text.
Detailed explanation-4: -The [sum range] is the range where the function calculates the sum. Note: The [sum range] is optional. If not specified, the function calculates the sum of the same range as the condition.