Question 101 markMCQMedium
A spreadsheet formula must give a value for every real input , with no "undefined" error, and it must also be able to output .
Which formula meets both requirements?
Confirming your payment
Competency-Based Questions (CBQ) · Question 10 of 80
A spreadsheet formula must give a value for every real input , with no "undefined" error, and it must also be able to output .
Which formula meets both requirements?
(A)
(B)
(C)
(D)
Option (D) is correct.
Explanation:
Recall the domains: and are defined for all real ; and are undefined at the odd multiples of ; and are undefined at the multiples of .
Test (D). The numerator is defined everywhere. Since , the denominator , so it is never zero. So is defined for every real . Also . Both requirements hold.
| formula | defined for every real ? | can output ? |
|---|---|---|
| yes | yes, at | |
| no, fails at | yes, at | |
| no, fails at | no, it equals | |
| no, fails at | yes, at |
Why the other options are wrong