USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which formula can add all the numeric values in a range of cells and place the result in a different cell?
|
|
Count
|
|
|
Average
|
|
|
Sum
|
|
|
Max
|
Explanation:
Detailed explanation-1: -Here’s a formula that uses two cell ranges: =SUM(A2:A4, C2:C3) sums the numbers in ranges A2:A4 and C2:C3. You’d press Enter to get the total of 39787. To create the formula: Type =SUM in a cell, followed by an opening parenthesis (.
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: -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.
There is 1 question to complete.