UniPASS Week 2 ECOM1000 - Data sorting and Filtering

What is a data set?

• A collection of related files containing records on people, places, or things

• A collection of data

• A two-dimensional table, where the columns correspond to each individual element of data

What is a database?

• A collection of data

• A two-dimensional table, where the columns correspond to each individual element of data

• A collection of related files containing records on people, places, or things

What is an Excel table?

• A table created in Excel that allows you to use table references to perform basic calculations

• A collection of related files containing records on people, places, or things

• A collection of data

What is an example of a data set

• Table of historical stock prices

• Two-dimensional table, where the columns correspond to individual elements of data

• Grocery list

Filtering is...

• Finding a subset of records that meet certain characteristics

• Organising data into alphabetical order

• sorting data and calculating cumulative proportions

_______ _______ involves sorting data and calculating cumulative proportions

• Data queries

• Pareto analysis

• Advanced filter

Which one of the following statements is true?

• Both vertical sorting and horizontal sorting will sort data stored in columns.

• Vertical sorting will sort the data in columns, whereas horizontal sorting sorts data stored in rows.

• Both vertical sorting and horizontal sorting will sort data stored in rows

Which one of the following statements on Filtering and Sorting is true?

• Two rows in the cell range can be filtered independently.

• Two rows in a cell range can be sorted independently

• Two columns in a cell range can be filtered independently

Which one of the following statements is more accurate when data is sorted vertically in descending order?

• The lowest value in the sorted row will be at the left-most column.

• The highest value in the sorted column will be at the top.

• The highest value in the sorted row will be at the left-most column.

• The lowest value in the sorted column will be at the top.

Which one of the following statements is more accurate when data is sorted horizontally in ascending order?

• The highest value in the sorted column will be at the top.

• The highest value in the sorted column will be at the bottom.

• The highest value in the sorted row will be in the rightmost column.

• The highest value in the sorted row will be in the leftmost column.