Chapter 4: Functions in Excel & Chapter 5: Sorting and Filters in Excel - Fill in the Blanks Interactive Worksheet Get link Facebook X Pinterest Email Other Apps - February 11, 2025 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 Submit Reset Get link Facebook X Pinterest Email Other Apps Comments
Comments
Post a Comment