Google Certification Level 2 Practice Test 2026 – Complete Exam Prep

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards

From $12.50Unlock all

Session length

1 / 20

Which formula could be used to show only the peer feedback from columns D, E, and F for Jimmy Wong?

=filter(D:F,C:C="Jimmy Wong")

The formula that correctly filters peer feedback specifically for Jimmy Wong from columns D, E, and F is highlighted in the selected answer. The FILTER function is designed to create a new range based on specified criteria, allowing users to pull specific data from a dataset.

In this context, using FILTER with the range D:F allows the function to access all the feedback data from columns D to F. The additional criterion, C:C="Jimmy Wong," ensures that only those rows where the name "Jimmy Wong" appears in column C will be displayed. This makes it possible to isolate and view only the feedback related to Jimmy Wong while excluding any data from other individuals.

The other options do not provide the intended results for extracting feedback. For instance, summation formulas fail to filter data based on the specific name and will not yield a list of feedback but rather numerical results instead. Thus, using the FILTER function with the correct criteria is the most effective way to achieve the desired outcome of showing only the relevant feedback for Jimmy Wong.

=sum(D:E,F:D)

=sum(D:F,C:C="Jimmy Wong")

=filter(D:E,F:D)