# FUNDAMENTALS OF COMPUTER

## USING MICROSOFT EXCEL

### HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
In the formula =SUMIFS(C5:C16, F5:F16, β<=60", B5:B16, β>200000"), what does <=60 means?
 A Ifthe value in C5:C16 is greater than or equal to 60, the value in C5:C16 will beincluded in the total. B Ifthe value in F5:F16 is greater than or equal to 60, the value in C5:C16 will beincluded in the total. C Ifthe value in B5:BF16 is less than or equal to 60, the value in C5:C16 will beincluded in the total. D If the value in F5:F16 is less than orequal to 60, the value in C5:C16 will be included in the total.
Explanation:

Detailed explanation-1: -5. In the formula =SUMIFS(C5:C16, F5:F16, "<=60", B5:B16, β>200000"), what does <=60 means? If the value in C5:C16 is greater than or equal to 60, the value in C5:C16 will be included in the total. If the value in F5:F16 is greater than or equal to 60, the value in C5:C16 will be included in the total.

Detailed explanation-2: -What does criteria range in a formula refer to? The range containing a condition that must be met in order for data to be included in the result.

Detailed explanation-3: -COUNTIFS applies criteria to cells across multiple ranges, and counts the number of times all criteria are met. This is the syntax of the COUNTIFS function.

Detailed explanation-4: -Use the IF function, one of the logical functions, to return one value if a condition is true and another value if itβs false. For example: =IF(A2>B2, "Over Budget", "OK") =IF(A2=B2, B4-A4, "")

Detailed explanation-5: -The COUNTIFS function applies criteria to cells across multiple ranges and counts the number of times all criteria are met.

There is 1 question to complete.
{"found_math": false, "script_math_tex": 0, "script_math_asciimath": 0, "math_annotations": 0, "math_alttext": 0, "mathml": 0, "mathjax_tag": 0, "mathjax_inline_tex": 0, "mathjax_display_tex": 0, "mathjax_asciimath": 0, "img_math": 0, "codecogs_latex": 0, "wp_latex": 0, "mimetex.cgi": 0, "/images/math/codecogs": 0, "mathtex.cgi": 0, "katex": 0, "math-container": 0, "wp-katex-eq": 0, "align": 0, "equation": 0, "x-ck12": 0, "texerror": 0}