Chapter 4: Functions in Excel & Chapter 5: Sorting and Filters in Excel - Fill in the Blanks Interactive Worksheet

Interactive Worksheet

Chapter 4: Functions in Excel

Fill in the blanks.

1. The SUM function is used to calculate the ________ of a range of numbers. Select an answer Total Mean Largest

2. The AVERAGE function returns the ________ of selected numbers. Select an answer Mean Total Smallest

3. The MAX function returns the ________ value in a range. Select an answer Largest Smallest Mean

4. The MIN function returns the ________ value in a range. Select an answer Smallest Largest Mean

5. The ________ function is used to find the square root of a number. Select an answer SQRT SUM IF

6. The IF function is used for ________ comparisons. Select an answer Logical Mathematical Text

7. Text can be converted to uppercase using the ________ function. Select an answer UPPER LOWER CONCAT

8. The ________ function joins two or more text strings into one. Select an answer CONCAT UPPER SUM

Chapter 5: Sorting and Filters in Excel

1. ________ allows you to arrange data in ascending or descending order. Select an answer Sorting Filtering Summing

2. A ________ is used to display only the rows that meet specific criteria. Select an answer Filter Sort Sum

3. The shortcut key for opening the filter menu is ________. Select an answer Alt + Down Arrow Ctrl + Shift + F Ctrl + F

4. You can apply filters to multiple ________ at the same time. Select an answer Columns Rows Sheets

5. Sorting options can be accessed under the ________ tab in Excel. Select an answer Data Insert Home

6. ________ sorting arranges values from smallest to largest. Select an answer Ascending Descending Random

7. Excel allows you to filter data by ________ color. Select an answer Cell Text Font

8. The ________ tool is used to remove all filters at once. Select an answer Clear Filter Reset Remove

9. ________ sorting uses more than one column to organize data. Select an answer Multi-level Simple Advanced