USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
If you enter 1 as the return type in the WEEKDAY function, what number represents a Monday?
|
|
1
|
|
|
2
|
|
|
3
|
|
|
4
|
Explanation:
Detailed explanation-1: -Numbers 0 (Monday) through 6 (Sunday). Numbers 1 (Monday) through 7 (Sunday). Numbers 1 (Tuesday) through 7 (Monday).
Detailed explanation-2: -The WEEKDAY Function[1] is an Excel DATE and TIME Function. The function will return an integer that is a representation of the day of the week for a given date. WEEKDAY is quite useful in financial analysis.
Detailed explanation-3: -Formula: =A2-WEEKDAY(A2, 2)+1 Note: This formula =A2-WEEKDAY(A2, 2)+1 will return Monday as the beginning of week based on the given date.
There is 1 question to complete.