鲨鱼象棋_鲨鱼周的Excel函数

鲨鱼象棋

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.

这是发现频道上的“ 鲨鱼周 ”，因此这里有几个方便的Excel函数，可在发生鲨鱼攻击时使用。 当然，如果您待在家里看电视，那应该很安全。 臭名昭著的陆地鲨很少袭击。

鲨鱼很大 (That Shark is Large)

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

鲨鱼相当大，该列表中的11种鲨鱼类型的长度从2米到5米不等。

Suddenly, you're being attacked by the second longest type of shark. How long is it?

突然，您受到了第二长的鲨鱼的攻击。 多久了？

To find out, you can use the Excel LARGE function. The LARGE function takes two arguments:

要找出答案，您可以使用Excel LARGE函数。 LARGE函数采用两个参数：

• the array or range of numbers
  数字数组或范围
• the number's position in that range, with 1 as the Largest number
  该数字在该范围内的位置，其中1为最大数字

大功能示例 (LARGE Function Example)

In this example, the range of cells is B2:B12, and we want to find the 2nd-largest number, so the second argument is 2.

在此示例中，单元格的范围是B2：B12，我们要查找第二大数字，因此第二个参数是2。

=LARGE(B2:B12,2)

=大(B2：B12,2)

To make the formula more flexible, if you type the position number in cell D1, you can refer to that cell in the LARGE function, as the second argument.

为了使公式更灵活，如果在单元格D1中键入位置编号，则可以在LARGE函数中引用该单元格作为第二个参数。

=LARGE(B2:B12,D1)

=大(B2：B12，D1)

鲨鱼掉在地上 (Sharks Eat Off the Floor)

Yes, some sharks eat fish, and other snacks, that they find on the ocean floor. Unfortunately, a few sharks have also dined on people, including about 1000 in the USA, over the past 300 years.

是的，有些鲨鱼在海底吃鱼和其他零食。 不幸的是，在过去的300年中，也有一些鲨鱼在人们身上用餐，其中包括约1000只在美国。

From a list of shark attacks per state, you could use the FLOOR function to round down the average number of attacks, to a specific multiple.

从每个州的鲨鱼攻击列表中 ，您可以使用FLOOR函数将平均攻击次数四舍五入到特定倍数。

For example, you could round the average attacks (in cell E4) to a multiple of 10, with this formula:

例如，您可以使用以下公式将平均攻击(在单元格E4中)四舍五入为10的倍数：

=FLOOR(E4,10)

=地板(E4,10)

So, if you're going to be attacked by a shark, you should make sure it happens in Georgia, where your odds of survival look pretty good!

因此，如果您将要被鲨鱼袭击，则应确保它在佐治亚州发生，您的生存几率看起来相当不错！

你需要更大的船 (You're Gonna Need a Bigger Boat)

And what would Shark Week be without a clip from the ultimate shark movie, Jaws.

如果没有最终的鲨鱼电影《大白鲨》的剪辑，《鲨鱼周》将是什么。

If you saw Jaws in the 70s, you probably don't need me to warn you -- don't go in the water! If you do go, take a really big boat.

如果您在70年代看到过Jaws，那么您可能不需要我警告您-不要入水！ 如果愿意的话，乘大船。

演示地址

翻译自: https://contexturesblog.com/archives/2010/08/04/excel-functions-for-shark-week/

鲨鱼象棋