Excel: Using the new Take and Drop functions
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.
More Excel Activities
Quickly deploy Excel lessons to your entire district.
Top districts trust Alludo to train teachers and staff