Excel: Using the new Take and Drop functions

16 Learners | 16 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

California Pacific Charter Schools Tuolumne County Superintendent of Schools Hatch Valley Public Schools Morongo Unified School District Val Verde Unified School District