Advertisements
Advertisements
Question
Which formulae would result in TRUE if C4 is less than 10 and D4 is less than 100?
Options
=AND(C4>10, D4>10)
=AND(C4>10, C4<100)
=AND(C4>10, D4<10)
=AND(C4<10, D4,100)
MCQ
Solution
=AND(C4<10, D4,100)
shaalaa.com
Features Offered by Electronic Spreadsheet
Is there an error in this question or solution?
RELATED QUESTIONS
Which key combination collapses the ribbon?
What category of functions is used in this formula: =PMT (C10/12, C8, C9,1)
When Extend Selection is active, what is the keyboard shortcut for selecting all data up to and including the last row?
Which of the following arguments in a financial function represents the total number of payments?
Give the meaning of the MODE Junction in Excel with an example.
When editing a cell in Excel, which key or combination of keys is pressed to toggle between relative, absolute and mixed cell references?
