NEW
Font size
WorksheetsExcel Functions and Filtering Basics
Total questions: 10
Worksheet time: 5mins
What does the MAX function do in Excel?
The MAX function calculates the average of a set of numbers.
The MAX function counts the number of entries in a dataset.
The MAX function finds the smallest value in a range of cells.
The MAX function returns the largest value in a set of numbers.
How do you use the MIN function to find the smallest number in a range?
Enter =AVERAGE(range) to determine the mean value of the range.
Apply the formula =SUM(range) to calculate the total of the numbers.
Use the formula =MAX(range) to find the largest number in a set.
Use the formula =MIN(range) where 'range' is the set of cells you want to evaluate.
Which formula would you use to find the highest score in a list of test scores?
MAX(test_scores)
COUNT(test_scores)
AVERAGE(test_scores)
SUM(test_scores)
If you have a list of numbers, how can you quickly find the lowest value using Excel?
Use the AVERAGE function, e.g., =AVERAGE(A1:A10) to find the average value.
Sort the list in descending order to see the lowest value at the bottom.
Use the MIN function, e.g., =MIN(A1:A10) to find the lowest value in cells A1 to A10.
Apply the MAX function, e.g., =MAX(A1:A10) to get the highest value.
What is the purpose of applying filters in Excel?
To format cells with different colors and fonts.
To create charts and graphs from the data.
To permanently delete unwanted data from the sheet.
The purpose of applying filters in Excel is to display only the relevant data that meets specific criteria.
How can you filter a list to show only values greater than 50?
Sort the list in ascending order to find values.
Select values less than 50 using a filter.
Use a list comprehension or filter function to select values greater than 50.
Use a loop to print all values in the list.
What steps do you take to sort data in ascending order in Excel?
Select the data range, go to the Data tab, and click 'Sort A to Z'.
Select the data range, go to the Home tab, and click 'Sort Z to A'.
Highlight the data, right-click, and choose 'Sort by Color'.
Select the data range, go to the View tab, and click 'Sort Ascending'.
How can you sort a list of names alphabetically in Excel?
Highlight the names, click 'Home' tab, and choose 'Sort Descending'.
Select the names, go to 'View' tab, and hit 'Sort A to Z'.
Select the names, go to 'Data' tab, and click 'Sort A to Z'.
Highlight the names, right-click, and select 'Sort by Color' option.
What happens to the data when you apply a filter in Excel?
The data is sorted in ascending order based on the selected column.
The data is copied to a new sheet without any filters.
The data is deleted permanently from the worksheet.
The data is filtered to show only the rows that meet the specified criteria, while hiding others.
Can you use both sorting and filtering at the same time in Excel?
You can only sort data without filtering in Excel.
Filtering is not possible when sorting in Excel.
No, sorting and filtering cannot be used together in Excel.
Yes, you can use both sorting and filtering at the same time in Excel.
