BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+
GRADED
DAY function
=DAY(serial_number)
MONTH function
=MONTH(serial_number)
YEAR function
=YEAR(serial_number)
DAYS function
=DAYS(end_date, start_date)
NETWORKDAYS function
=NETWORKDAYS(start_date, end_date, [holidays])
YEARFRAC function
=YEARFRAC(start_date, end_date)
WEEKDAY function
=WEEKDAY(serial_number, [return_type])
DAYS360 function =DAYS360(start_date, end_date, [method])
Calculates the number of days between two dates based on a 360-day year, using 30
days per month.
DATE function =DATE(year,month,day)
Displays the date when provided with the numeric year, month, and date arguments.
WORKDAY function =WORKDAY(start_day, days, [holidays])
calculates a serial number of a date, given a specific number of days before or after a
date, excluding specified holidays.
HOUR function =HOUR(serial_number)
A date and time that returns the hour between 0 (12AM) and 23 (11PM)
MINUTE function =MINUTE(serial_number)
A date and time that returns a minute between 0 ad 59.
SWITCH function =SWITCH(expression, value1, result1, [defaultorvalue2])
Evaluates an expression, compares it to a list of values, and returns the first
corresponding result.
IFS(logical_test1,value_if_true1,logical_test2,value_if_true2,...)
Evaluates multiple conditions and returns a value corresponding to the first true
condition.
Nested Function =IF(C7<C$2,D7D$2,IF(C7<=C$3,D7D$3,D7*D$4))
A function that is in another function
AND function and what does it do
Evaluates to true if ALL conditions are TRUE.
OR function and what does it do
Evaluates to true if ANY of the conditions are true.
NOT function
GRADED
DAY function
=DAY(serial_number)
MONTH function
=MONTH(serial_number)
YEAR function
=YEAR(serial_number)
DAYS function
=DAYS(end_date, start_date)
NETWORKDAYS function
=NETWORKDAYS(start_date, end_date, [holidays])
YEARFRAC function
=YEARFRAC(start_date, end_date)
WEEKDAY function
=WEEKDAY(serial_number, [return_type])
DAYS360 function =DAYS360(start_date, end_date, [method])
Calculates the number of days between two dates based on a 360-day year, using 30
days per month.
DATE function =DATE(year,month,day)
Displays the date when provided with the numeric year, month, and date arguments.
WORKDAY function =WORKDAY(start_day, days, [holidays])
calculates a serial number of a date, given a specific number of days before or after a
date, excluding specified holidays.
HOUR function =HOUR(serial_number)
A date and time that returns the hour between 0 (12AM) and 23 (11PM)
MINUTE function =MINUTE(serial_number)
A date and time that returns a minute between 0 ad 59.
SWITCH function =SWITCH(expression, value1, result1, [defaultorvalue2])
Evaluates an expression, compares it to a list of values, and returns the first
corresponding result.
IFS(logical_test1,value_if_true1,logical_test2,value_if_true2,...)
Evaluates multiple conditions and returns a value corresponding to the first true
condition.
Nested Function =IF(C7<C$2,D7D$2,IF(C7<=C$3,D7D$3,D7*D$4))
A function that is in another function
AND function and what does it do
Evaluates to true if ALL conditions are TRUE.
OR function and what does it do
Evaluates to true if ANY of the conditions are true.
NOT function
