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

More Excel Activities

Quickly deploy Excel lessons to your entire district.

Points 25 | Time 00:10

Points 25 | Time 00:15

Points 50 | Time 00:20

Points 25 | Time 00:15

Points 50 | Time 00:30

Points 50 | Time 00:20

Points 25 | Time 00:15

Points 50 | Time 00:25

Points 75 | Time 00:45

Points 25 | Time 00:20

Top districts trust Alludo to train teachers and staff

Santa Ynez Valley Union HS Westmoreland IU7 El Segundo Unified School District Cambrian School District Alludo Learning