Excel vs Google Sheets comparison - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

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

Excel

=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 ':'

Using a semicolon ';' which is not valid for ranges

Adding cells with '+' instead of using a range

The correct way to sum a range in Excel is using a colon between the start and end cells, like A1:A5.

2fill in blank

medium

Complete the formula to find the average of cells B1 to B10 in Google Sheets.

Excel

=AVERAGE([1])

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

AB1:B10

BB1+B10

CB1;B10

DB1-B10

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash '-' instead of a colon ':'

Using a semicolon ';' which is invalid for ranges

Adding cells with '+' instead of using a range

In Google Sheets, like Excel, ranges use a colon ':' to specify the start and end cells.

3fill in blank

hard

Fix the error in this Excel formula to count cells in C1 to C20 that are greater than 5.

Excel

=COUNTIF(C1:C20, [1])

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

A>5

B5

C">5"

D"5"

Attempts:

3 left

💡 Hint

Common Mistakes

Leaving out quotes around the criteria

Using just the number without operator

Using quotes incorrectly

The criteria in COUNTIF must be a text string with the comparison operator inside quotes, like ">5".

4fill in blank

hard

Fill both blanks to create a dictionary in Google Sheets using ARRAYFORMULA that maps words to their lengths.

Excel

=ARRAYFORMULA([1], LEN([2])})

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

AA1:A5

BB1:B5

CA1:A10

DB1:B10

Attempts:

3 left

💡 Hint

Common Mistakes

Using different ranges for words and LEN

Using ranges that don't match the data

Not using ARRAYFORMULA for array operations

To map words to their lengths, use the same range for both the words and LEN function. Here, A1:A5 is used for both.

5fill in blank

hard

Fill all three blanks to create a filtered list in Excel showing values from D1:D10 greater than 50.

Excel

=FILTER([1], [2] [3] 50)

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

AD1:D10

C>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using different ranges in blanks

Using < instead of >

Not repeating the range in the condition

The FILTER function takes the range and a condition. Here, we filter D1:D10 for values greater than 50 using >.