Template gallery usage in Google Sheets - Practice Problems & Coding Challenges

Challenge - 5 Problems

🎯 Scenario

intermediate

Choosing the right template for a monthly budget

You want to track your monthly expenses and income using Google Sheets. Which template from the Template Gallery should you select to get started quickly?

A Annual financial report template

B Monthly budget template

C Event guest list template

D Project timeline template

💡 Hint

Think about which template is designed specifically for tracking money each month.

The Monthly budget template is designed to help you track income and expenses each month, making it the best choice for managing your monthly budget.

📊 Formula Result

intermediate

Output of a formula in a template sheet

You open a Google Sheets template for a sales report. Cell B5 contains the formula =SUM(B2:B4). If cells B2, B3, and B4 contain 100, 200, and 150 respectively, what is the value shown in B5?

A 150

B 350

C 100

D 450

💡 Hint

SUM adds all numbers in the range.

The formula adds 100 + 200 + 150, which equals 450.

❓ Function Choice

advanced

Best function to calculate average in a template

You are using a Google Sheets template for student grades. You want to calculate the average score of students listed in cells C2 to C10. Which function should you use?

A =AVERAGE(C2:C10)

B =SUM(C2:C10)

C =COUNT(C2:C10)

D =MAX(C2:C10)

💡 Hint

Think about which function finds the middle value of a group of numbers.

=AVERAGE calculates the mean value of the numbers in the range, which is the average score.

❓ data_analysis

advanced

Identifying template features for project tracking

You open a project management template in Google Sheets. It includes columns for task name, start date, end date, and status. Which feature helps you quickly see which tasks are overdue?

A Using the SUM function to add task durations

B Sorting tasks alphabetically by name

C Conditional formatting highlighting tasks past their end date

D Inserting a pie chart of task statuses

💡 Hint

Think about how colors can help you spot important information fast.

Conditional formatting can highlight tasks that are overdue by comparing the end date to today’s date and changing the cell color.

🧠 Conceptual

expert

Understanding template data protection features

When you use a Google Sheets template shared with you, which feature helps prevent accidental changes to important formulas or headers?

A Protected ranges that restrict editing to certain users

B Freezing rows to keep headers visible

C Using filters to sort data

D Conditional formatting to color cells

💡 Hint

Think about how to stop others from changing specific cells.

Protected ranges allow the sheet owner to lock cells so only authorized users can edit them, preventing accidental changes.