C1 contains a random DATE. To confirm C1 is in the weekends or not, the needed function is:
A. =IF(OR(TEXT(C1, "dddd")= "Saturday",TEXT(C1, "dddd")= "Sunday"), "Weekend", "Weekday")
B. =IF(OR(WEEKDAY(C1)=7,WEEKDAY(C1)=1), "Weekend", "Weekday")
C. Both of the others are usable
C. Both of the others are usable
You might also like to view...
Disabling ________ prevents end users from making design changes in a custom database application
Fill in the blank(s) with correct word
Standardization means designing a workbook so that individuals cannot enter data into cells
Indicate whether the statement is true or false
What is the very first step that should be taken when performing work with a computer?
A. You should back up any important data. B. You should ground yourself. C. You should remove the power supply. D. You should power down the system and unplug it.
An alphabetical listing of topics covered in a document along with the page numbers where the topic is discussed.
What will be an ideal response?