Excel: Using the new Take and Drop functions

14 Learners | 14 Completed Lessons | 5 Hours of Learning Time

Learning Activity

The DROP function is one of 14 functions added to Excel in the spring of 2022. It displays the contents of specified range but excludes the first or last X number of rows or columns. 

The TAKE function is a another new function added to Excel in the spring of 2022. It displays the contents of the first or last X number of rows or columns from a range. 

Watch the videos below and then create a spreadsheet in Excel demonstrating both the Take function and the Drop function. Upload your Excel file as evidence.

Resources

How to Use the Drop Function

How to Use the Take Function



Transform Data into Opportunity with Excel on Alludo   Uncover game-changing insights from your school's data with Excel skills training on Alludo.  

More Excel Activities

Quickly deploy Excel lessons to your entire district.

Excel: Create a Workbook

Points 25 | Time 00:10

Excel: Using Templates to create Spreadsheets

Points 25 | Time 00:10

Excel: Add, Sort and Delete Cells, Rows and Columns

Points 25 | Time 00:10

Excel: Conditional Formatting

Points 25 | Time 00:15

Excel: Using Formulas and Functions

Points 50 | Time 00:20

Excel: Charts and Graphs

Points 25 | Time 00:15

Excel: Create a Nested IF function

Points 50 | Time 00:30

Excel: Using Pivot Tables

Points 50 | Time 00:20

Excel: Create a basic gradebook

Points 25 | Time 00:15

Excel: Spreadsheet Vocabulary

Points 50 | Time 00:25

Excel: Create an Excel Assignment

Points 75 | Time 00:45

Excel: Tips and Tricks

Points 25 | Time 00:20

Top districts trust Alludo to train teachers and staff

Palm Springs Unified Antelope Valley Union High School District Cambrian School District Santa Ynez Valley Union HS El Segundo Unified School District
Transform Data into Opportunity with Excel on Alludo   Uncover game-changing insights from your school's data with Excel skills training on Alludo.