FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

If you add seven days to an existing date that was a Monday, using the WORKDAY function, and within those seven days, there’s one national holiday, what is the resulting day of the week?

A	Monday
B	Tuesday
C	Wednesday
D	Thursday

Explanation:

Detailed explanation-1: -The method to use this function in Excel is as follows =WORKDAY ( Start date, Days, Holidays). The first two arguments are mandatory; however, the argument for holidays is optional. For example, =WORKDAY(A1, B1). A1-1/01/2020 (starting date), B1-45 days(days for completion)which gives 4-03-2020 in cell C1.

Detailed explanation-2: -=WORKDAY(start date, days, [holidays]) The function uses the following arguments: Start date (required function) – This is a date that represents the start date. Days (It is a required function) – The number of workdays to be added to start date.

Detailed explanation-3: -WORKDAY is a function in Excel that calculates the date that is x days after a given date. The function takes two arguments: the date that you want to find the days since, and the number of days. For example, if you want to find the date that is 7 days after June 1st, you would use the function =WORKDAY(6/1, 7).

Detailed explanation-4: -The WEEKDAY function syntax has the following arguments: Serial number Required. A sequential number that represents the date of the day you are trying to find. Dates should be entered by using the DATE function, or as results of other formulas or functions.

There is 1 question to complete.