It's Shark Week on the Discovery Channel, so here are a couple of handy Excel functions you can use in case of a shark attack. Of course, if you stay home and watch television, you should be safe. The infamous land shark rarely attacks.

That Shark is Large

Sharks are pretty big, with the shark types in this list ranging from 2 to 5 metres.

You're being attacked by the second longest shark. How long is it? To find out, you can use the LARGE function. It takes two arguments -- the array or range of numbers, and the position in that range.

In this example, the range is B2:B12, and the position is 2.

=LARGE(B2:B12,2)

If you type the position number in cell D1, you can refer to that cell in the LARGE function.

=LARGE(B2:B12,D1)

Sharks Eat Off the Floor

Yes, some sharks eat fish, and other

Continue reading Excel Functions for Shark Week