Entering and editing data in Google Sheets - Practice Problems & Coding Challenges

Challenge - 5 Problems

📊 Formula Result

intermediate

What is the result of this formula after editing cell A1?

You have a Google Sheet where cell A1 contains the number 10. Cell B1 contains the formula =A1 * 2. If you change the value in A1 to 15, what will be the value in B1?

A 10

B 15

C 30

D 20

💡 Hint

Remember that formulas update automatically when referenced cells change.

The formula in B1 multiplies the value in A1 by 2. Changing A1 to 15 makes B1 equal to 15 * 2 = 30.

❓ Function Choice

intermediate

Which function helps you quickly fill a series of numbers?

You want to enter numbers 1 to 10 in cells A1 to A10 without typing each number manually. Which Google Sheets feature or function should you use?

A Use the Fill Handle by dragging the corner of the first cell

B Use the IF() function

C Use the CONCATENATE() function

D Use the SUM() function

💡 Hint

Look for a way to drag and fill cells automatically.

The Fill Handle lets you drag the corner of a cell to fill a series like numbers or dates automatically.

🎯 Scenario

advanced

How to prevent accidental changes to important data?

You have a sheet with important data in cells A1 to D10. You want to allow users to view but not change these cells. What is the best way to protect this data in Google Sheets?

A Protect the range A1:D10 with a password and restrict editing

B Use Data Validation to restrict input

C Delete the cells so no one can edit them

D Hide the rows containing the data

💡 Hint

Think about sheet protection features.

Protecting a range lets you restrict who can edit those cells, preventing accidental changes.

📊 Formula Result

advanced

What happens when you paste data with different formatting?

You copy cells with red text and bold font from one sheet and paste them into another sheet that has default formatting. What will be the formatting of the pasted cells if you use 'Paste values only'?

A The pasted cells keep red text and bold font

B The pasted cells keep only the bold font

C The pasted cells keep only the red text color

D The pasted cells have default formatting with no color or bold

💡 Hint

Paste values only copies just the data, not formatting.

Using 'Paste values only' inserts only the raw data, so formatting like color and bold is lost.

❓ data_analysis

expert

How many cells contain text after editing?

You have a range A1:A5 with these values: 100, "Hello", 200, "World", 300. You replace the value in A3 with "Test". How many cells in A1:A5 now contain text?

A 2

B 3

C 4

D 5

💡 Hint

Count cells with words, not numbers.

Initially, cells A2 and A4 contain text. After changing A3 to "Test", cells A2, A3, and A4 contain text, totaling 3.