Why Google Sheets is essential for collaboration - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to sum 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 '+' instead of ':' to specify a range.

Trying to subtract or multiply cell references inside SUM.

The correct way to sum a range in Google Sheets is using the colon to specify the range, like A1:A5.

2fill in blank

medium

Complete the formula to count how many cells in B1:B10 contain numbers.

Google Sheets

=COUNT([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 '+' instead of ':' to specify a range.

Using COUNT on a single cell or incorrect range.

The COUNT function counts numeric values in a range, so you need to specify the range with a colon, like B1:B10.

3fill in blank

hard

Fix the error in this formula to get the average of cells C1 to C5.

Google Sheets

=AVERAGE([1])

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

AC1-C5

BC1:C5

CC1+C5

DC1*C5

Attempts:

3 left

💡 Hint

Common Mistakes

Using '+' or '-' instead of ':' to specify a range.

Multiplying or subtracting cell references inside AVERAGE.

The correct way to specify a range in Google Sheets is with a colon, so C1:C5 selects all cells from C1 to C5.

4fill in blank

hard

Fill both blanks to create a formula that sums values in D1 to D10 only if they are greater than 5.

Google Sheets

=SUMIF([1], [2])

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

AD1:D10

B>5

C<5

DD1+D10

Attempts:

3 left

💡 Hint

Common Mistakes

Using '+' instead of ':' for the range.

Using the wrong comparison operator like '<5'.

The SUMIF function sums cells in the range D1:D10 that meet the condition '>5'.

5fill in blank

hard

Fill all three blanks to create a formula that counts cells in E1 to E20 that contain the text 'Done'.

Google Sheets

=COUNTIF([1], [2], [3])

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

AE1:E20

B"Done"

C"done"

Attempts:

3 left

💡 Hint

Common Mistakes

Not using quotes around the text 'Done'.

Using the wrong range or misspelling the text.

The COUNTIF function counts cells in the range E1:E20 that exactly match the text "Done". The text must be in quotes.

Practice

1. Why is Google Sheets especially useful for teamwork?

easy

A. It only works offline without internet.

B. It automatically creates charts without any input.

C. It allows multiple people to work on the same sheet at the same time.

D. It requires special software to open files.

Solution

1. Step 1: Understand collaboration features

   Google Sheets lets many users edit one spreadsheet simultaneously, making teamwork easy.

2. Step 2: Compare options

   Options B, C, and D are incorrect because they describe features not related to collaboration or are false.

3. Final Answer:

   It allows multiple people to work on the same sheet at the same time. -> Option C

4. Quick Check:

   Real-time editing = teamwork [OK]

Hint: Think about what helps many people work together live [OK]

Common Mistakes:

• Confusing offline use with collaboration
• Thinking charts are the main collaboration feature
• Believing special software is needed

2. Which of these is the correct way to share a Google Sheet with editing rights?

easy

A. Click 'Share', enter email, and select 'Viewer' permission.

B. Copy the sheet and send it via chat.

C. Download the file and email it as an attachment.

D. Click 'Share', enter email, and select 'Editor' permission.

Solution

1. Step 1: Understand sharing permissions

   To allow others to edit, you must select 'Editor' permission when sharing.

2. Step 2: Evaluate options

   Click 'Share', enter email, and select 'Viewer' permission only allows viewing, B and C do not use Google Sheets sharing features properly.

3. Final Answer:

   Click 'Share', enter email, and select 'Editor' permission. -> Option D

4. Quick Check:

   Editor permission = edit access [OK]

Hint: Choose 'Editor' permission to let others change the sheet [OK]

Common Mistakes:

• Selecting 'Viewer' instead of 'Editor'
• Sharing by sending files instead of using Share button
• Not setting any permission

3. If two users edit the same cell at the same time in Google Sheets, what happens?

medium

A. The last change made is saved and shown.

B. Both changes are saved in separate cells automatically.

C. The sheet crashes and loses data.

D. Google Sheets blocks editing until one user finishes.

Solution

1. Step 1: Understand real-time editing conflict

   When two users edit the same cell, Google Sheets saves the last change made.

2. Step 2: Analyze options

   The sheet crashes and loses data is false; Google Sheets does not crash. Both changes are saved in separate cells automatically is incorrect because changes do not split into separate cells. Google Sheets blocks editing until one user finishes is false; editing is not blocked.

3. Final Answer:

   The last change made is saved and shown. -> Option A

4. Quick Check:

   Last edit wins in conflicts [OK]

Hint: Remember: last person to edit a cell wins [OK]

Common Mistakes:

• Thinking changes merge automatically
• Believing the sheet crashes
• Assuming editing is blocked

4. A user shared a Google Sheet but others cannot edit it. What is the likely problem?

medium

A. The sheet is shared with 'Viewer' permission instead of 'Editor'.

B. The sheet is not saved.

C. Google Sheets does not support sharing.

D. The users do not have Google accounts.

Solution

1. Step 1: Check sharing permissions

   If others cannot edit, the sheet was likely shared with 'Viewer' permission only.

2. Step 2: Evaluate other options

   The sheet is not saved is incorrect because Google Sheets auto-saves. Google Sheets does not support sharing is false; sharing is a core feature. The users do not have Google accounts is incorrect because users can edit with Google accounts or as guests if allowed.

3. Final Answer:

   The sheet is shared with 'Viewer' permission instead of 'Editor'. -> Option A

4. Quick Check:

   Viewer permission blocks editing [OK]

Hint: Check if permission is set to 'Editor' for editing [OK]

Common Mistakes:

• Assuming saving is manual
• Not knowing sharing is supported
• Ignoring permission levels

5. You want to track changes made by collaborators and revert to an earlier version if needed. Which Google Sheets feature helps with this?

hard

A. Conditional formatting

B. Version history and comments

C. Pivot tables

D. Data validation

Solution

1. Step 1: Identify features for tracking and reverting changes

   Version history records all changes and lets you restore earlier versions. Comments help communicate about changes.

2. Step 2: Rule out unrelated features

   Conditional formatting changes cell colors, pivot tables summarize data, and data validation restricts inputs; none track changes.

3. Final Answer:

   Version history and comments -> Option B

4. Quick Check:

   Version history = track and revert changes [OK]

Hint: Use version history to undo changes safely [OK]

Common Mistakes:

• Confusing formatting or validation with change tracking
• Ignoring comments as communication tools
• Not knowing version history exists