A data team at a trade school needs to display only students with fewer than 10 credits in a spreadsheet. Which feature would enable this?

Prepare for the WGU BUS2770 D467 Exploring Data Exam. Dive into interactive quizzes and insightful flashcards, each featuring detailed explanations to optimize your learning experience, and get exam-ready!

Multiple Choice

A data team at a trade school needs to display only students with fewer than 10 credits in a spreadsheet. Which feature would enable this?

Filtering data to show only records that meet a condition is the tool for displaying a specific subset of rows. To display students with fewer than 10 credits, you would apply a filter on the credits column and set the condition to restrict the view to values below 10. The option described as filtering out students with more than 10 credits aligns with this idea: it hides rows that exceed the threshold, leaving a view of the students who meet the credit limit. The other features don’t change which rows are shown—data validation restricts what you can enter, conditional formatting only highlights rows, and a pivot table summarizes data rather than filtering the visible list.

Filtering data to show only records that meet a condition is the tool for displaying a specific subset of rows. To display students with fewer than 10 credits, you would apply a filter on the credits column and set the condition to restrict the view to values below 10. The option described as filtering out students with more than 10 credits aligns with this idea: it hides rows that exceed the threshold, leaving a view of the students who meet the credit limit. The other features don’t change which rows are shown—data validation restricts what you can enter, conditional formatting only highlights rows, and a pivot table summarizes data rather than filtering the visible list.

More practice questions