Paste special options in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to paste only the values from the copied cells.

Google Sheets

Select the destination cells, then use Edit > Paste special > Paste [1] only.

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

Avalues

Bnotes

Cformat

Dformulas

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting 'formulas' pastes formulas, not just values.

Choosing 'format' pastes only formatting.

Choosing values pastes only the cell values without formulas or formatting.

2fill in blank

medium

Complete the code to paste only the formatting from the copied cells.

Google Sheets

After copying, use Edit > Paste special > Paste [1] only to copy colors and fonts.

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

Adata validation

Bformulas

Cvalues

Dformat

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'values' pastes content, not formatting.

Selecting 'formulas' pastes formulas.

The format option pastes only the cell colors, fonts, and borders.

3fill in blank

hard

Fix the error in the instruction to paste only the formulas from copied cells.

Google Sheets

Use Edit > Paste special > Paste [1] only to paste formulas without values.

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

Aformulas

Bvalues

Cformat

Dconditional formatting

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'values' pastes results, not formulas.

Selecting 'format' pastes appearance only.

The formulas option pastes only the formulas, not the values or formatting.

4fill in blank

hard

Fill the blank to paste only the data validation rules without values or formatting.

Google Sheets

After copying, use Edit > Paste special > Paste [1] only.

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

Aformulas

Bdata validation

Cvalues

Dformat

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'values' pastes content, not rules.

Selecting 'format' pastes appearance, not validation.

To paste only data validation rules, select data validation in Paste special. It applies the rules without changing values or format.

5fill in blank

hard

Fill both blanks to paste only the conditional formatting rules and notes without values.

Google Sheets

Use Edit > Paste special > Paste [1] and [2] only.

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

Aconditional formatting

Bnotes

Cvalues

Dformat

Attempts:

3 left

💡 Hint

Common Mistakes

Including 'values' pastes data, not just formatting and notes.

Missing 'notes' means comments won't be copied.

To paste conditional formatting and notes but not values, select conditional formatting and notes.