An analyst cleansing invoice data wants to view rows where amount paid is greater than $100. Which spreadsheet feature should be used?

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

An analyst cleansing invoice data wants to view rows where amount paid is greater than $100. Which spreadsheet feature should be used?

Filtering rows based on a condition lets you see only the records that meet that condition, such as the amount paid being greater than 100. Apply a filter to the data range, select the amount paid column, and set a numeric filter for greater than 100. The sheet will hide rows that don’t meet the condition, letting you focus on just the invoices that exceed 100 as you cleanse the data. Sorting would simply reorder rows and not exclude any, so it doesn’t isolate the subset. A pivot table is for summarizing data, not for viewing each individual row that matches a rule. Conditional formatting highlights cells that meet a rule but doesn’t hide non-matching rows, so it doesn’t help you view only those rows.

Filtering rows based on a condition lets you see only the records that meet that condition, such as the amount paid being greater than 100. Apply a filter to the data range, select the amount paid column, and set a numeric filter for greater than 100. The sheet will hide rows that don’t meet the condition, letting you focus on just the invoices that exceed 100 as you cleanse the data. Sorting would simply reorder rows and not exclude any, so it doesn’t isolate the subset. A pivot table is for summarizing data, not for viewing each individual row that matches a rule. Conditional formatting highlights cells that meet a rule but doesn’t hide non-matching rows, so it doesn’t help you view only those rows.

More practice questions