Excel: Using the new Take and Drop functions
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.
Top districts trust Alludo to train teachers and staff
![Tuolumne County Superintendent of Schools](https://cdn-alludo.alludolearning.com/district/logo/128/logo-1542829004.png)
![Palm Springs Unified](https://cdn-alludo.alludolearning.com/district/logo/1/logo-1540482125.png)
![Moreno Valley Unified School District](https://cdn-alludo.alludolearning.com/district/logo/171/logo-1659040062.png)
![Val Verde Unified School District](https://cdn-alludo.alludolearning.com/district/logo/218/logo-1596169088.png)
![Westmoreland IU7](https://cdn-alludo.alludolearning.com/district/logo/261/logo-1682436519.png)