Google Sheets vs Excel comparison - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to sum the values in cells A1 to A5.

Google Sheets

=SUM([1])

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

AA1,A5

BA1-A5

CA1;A5

DA1:A5

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash '-' instead of a colon ':' for ranges.

Separating cells with commas or semicolons inside SUM.

The correct range syntax in Google Sheets and Excel is A1:A5 to sum all cells from A1 to A5.

2fill in blank

medium

Complete the formula to get the current date in Google Sheets.

Google Sheets

= [1] ()

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

ATODAY

BNOW

CDATE

DCURRENTDATE

Attempts:

3 left

💡 Hint

Common Mistakes

Using NOW() which returns date and time instead of just date.

Using non-existent functions like CURRENTDATE.

The TODAY() function returns the current date without the time.

3fill in blank

hard

Fix the error in the formula to count cells with values greater than 10 in range B1:B10.

Google Sheets

=COUNTIF(B1:B10, [1])

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

A>10

B10>

C>=10

D10>=

Attempts:

3 left

💡 Hint

Common Mistakes

Placing the number before the operator.

Not using quotes around the criteria.

The criteria in COUNTIF must be a string with the comparison operator before the number, like ">10".

4fill in blank

hard

Fill both blanks to create a formula that returns the average of values in C1:C10, ignoring empty cells.

Google Sheets

= [1] ([2])

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

AAVERAGE

BSUM

CC1:C10

DCOUNT

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM without dividing by count.

Using COUNT which counts numbers but does not average.

The AVERAGE(C1:C10) function calculates the average of the range, ignoring empty cells automatically.

5fill in blank

hard

Fill all three blanks to create a formula that returns a dictionary (named range) of words and their lengths for words longer than 3 characters in A1:A5.

Google Sheets

=[1]: [2] for word in [3] if len(word) > 3}

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

Aword

Blen(word)

CA1:A5

Dwords

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect variable names.

Not specifying the correct range.

This formula is a conceptual example of creating a dictionary mapping words to their lengths for words longer than 3 characters in the range A1:A5.