Business Data Management Quiz

What is the main purpose of sorting business data?

• To delete unnecessary records

• To arrange data in a specific order for easy analysis

• To hide unwanted data

• To change data types

Which of the following sorts data from smallest to largest or A to Z?

• Descending order

• Random order

• Ascending order

• Custom order

In multi-level sorting, what happens if two records have the same value in the first sort column?

• They are deleted

• They are sorted based on the next column

• They remain unsorted

• They are hidden

Which type of sorting allows you to manually define a specific order?

• Custom sort

• Ascending sort

• Descending sort

• Basic sort

What does filtering data help to do?

• Remove duplicates

• Display only data that meets specific conditions

• Change data format

• Encrypt data

Which Excel tool is used for basic filtering by selecting values from dropdown lists?

• AutoFilter

• Pivot Table

• Data Validation

• Conditional Formatting

Which filtering method in Excel allows complex criteria and copying results to a new location?

• AutoFilter

• Custom Filter

• Advanced Filter

• Data Table

In Excel, what visual filtering tool is commonly used with PivotTables?

• Grouping

• Slicer

• Subtotal

• Chart

What is organizing data mainly concerned with?

• Rearranging data randomly

• Structuring and arranging data logically

• Deleting invalid data

• Encrypting records

Which of the following Excel features converts a data range into a structured, manageable form?

• Data Table

• Custom Sort

• Filter

• Slicer