BIS SEMI-FINALS

What is the formula for retrieving the current date and time?

=NOW()

Create a formula that would transform the word "SENTIMENTALISATION" into a proper case.

=PROPER(I5)

Create a formula that would count the empty cells in column D.

=COUNTBLANK(D1:D20)

Create a formula that would automatically mark failed or pass based on the grades in A1 to A3

=IF(A1<74,”FAILED”,”PASSED”)

=IF(A1>-75,”PASSED”,”FAILED”)

Create a formula that would determine the number of years, months of year, and days over month based on the dates in F6 and F7.

=DATEDIF(F6,F7,”Y”)

=DATEDIF(F6,F7,”YM”)

=DATEDIF(F6,F7”MD”)

Create a formula that returns the remainder of 10,2.

=MOD(10,2)

What is the formula for counting the number of characters in cell I9

=LEN(I9)

Create a formula that would transform the word “fictionalization” into upper case.

=UPPER(I4)

Create a formula that would count the cells that contain numbers >8.

=COUNTIF(D1:D20>8)

Create a formula that would result in either TRUE OR FALSE based on the value in A1 to A3. "TRUE" if the value is >=75, "FALSE" if the value is not >=75.

=IF(A1>=75,”TRUE”,”FALSE”)

Create a formula that would determine the number of days, number of months, and number of years based on the dates in 16 and F7.

=DATEDIF(F6,F7,”Y”)

=DATEDIF(F6,F7,”M”)

=DATEDIF(F6,F7,”D”)

Create a formula that returns the current date.

=TODAY()

Excel

is a computer program used to create electronic spreadsheets.

Fill handle

WHEN YOU HOLD YOUR MOUSE OVER THE TOP OF IT, YOUR CURSOR WILL TURN TO A CROSSHAIR.