FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
In the formula =SUMIFS(C5:C16, F5:F16, “<=60", B5:B16, “>200000"), which of the following is the range of cells to be added?
A
= KH: S16
B
=F5:F16
C
=B5:B16
D
=S5:F16
Explanation: 

Detailed explanation-1: -The range of cells that you want evaluated by criteria. Cells in each range must be numbers or names, arrays, or references that contain numbers. Blank and text values are ignored. The selected range may contain dates in standard Excel format (examples below).

Detailed explanation-2: -The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose profits exceed a specific dollar value.

Detailed explanation-3: -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.

There is 1 question to complete.
Previous
Next