WEEKDAY and WORKDAY in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to get the weekday number of the date in cell A1.

Google Sheets

=WEEKDAY([1])

Drag options to blanks, or click blank then click option'

AA1

B1

C"A1"

DDATE(2023,1,1)

Attempts:

3 left

💡 Hint

Common Mistakes

Using a number like 1 instead of a cell reference.

Putting the cell reference in quotes like "A1" which makes it text.

The WEEKDAY function needs a cell reference or date value. Using A1 correctly points to the date in that cell.

2fill in blank

medium

Complete the formula to find the date 5 workdays after the date in cell B2.

Google Sheets

=WORKDAY([1], 5)

Drag options to blanks, or click blank then click option'

A5

BTODAY()

C"B2"

DB2

Attempts:

3 left

💡 Hint

Common Mistakes

Using a number like 5 as the start date.

Putting the cell reference in quotes which makes it text.

The WORKDAY function needs a start date as the first argument. B2 correctly refers to the start date cell.

3fill in blank

hard

Fix the error in the formula to get the weekday number of the date in cell C3 with Monday as day 1.

Google Sheets

=WEEKDAY(C3, [1])

Drag options to blanks, or click blank then click option'

A1

B3

C2

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Using 1 which starts the week on Sunday.

Using 0 or 3 which are invalid or different numbering schemes.

Using 2 as the second argument makes WEEKDAY count Monday as 1, Tuesday as 2, and so on.

4fill in blank

hard

Fill both blanks to create a dictionary of words and their lengths, but only for words longer than 4 letters.

Google Sheets

{word: [1] for word in words if len(word) [2] 4}

Drag options to blanks, or click blank then click option'

Alen(word)

B>

C<

Dword

Attempts:

3 left

💡 Hint

Common Mistakes

Using word instead of len(word) for the value.

Using < instead of > in the condition.

The dictionary maps each word to its length using len(word). The condition len(word) > 4 filters words longer than 4 letters.

5fill in blank

hard

Fill all three blanks to create a dictionary with uppercase keys, values from data, and only include values greater than 0.

Google Sheets

result = [1]: [2] for k, v in data.items() if v [3] 0}

Drag options to blanks, or click blank then click option'

Ak.upper()

Bv

C>

Dk

Attempts:

3 left

💡 Hint

Common Mistakes

Using k instead of k.upper() for keys.

Using < instead of > in the condition.

Using k instead of v for values.

The keys are uppercase using k.upper(). The values are v. The condition v > 0 filters positive values.