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

Study for the Google Certification Level 2. Master core tools and features with questions, hints, and detailed explanations. Boost your confidence for the exam and enhance your skill set!

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.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy