CBSE Class 9 Computer Applications
Question 38 of 39
Microsoft Excel 2010 - I — Question 4
Back to all questions 4
Question Question 4
Which logical values are recognized by most of the functions? What are the corresponding numeric values of those logical values?
In Excel, logical values are represented by the TRUE and FALSE values. These logical values are widely recognized by most functions for conditional testing and logical operations. The corresponding numeric values are:
TRUE — corresponds to the numeric value 1.
FALSE — corresponds to the numeric value 0.
When we use TRUE or FALSE in a numeric context, Excel automatically treats them as 1 and 0, respectively.