寻宝游戏设定_Excel寻宝游戏

寻宝游戏设定

If you have the day off, you can spend some time playing this Excel Treasure Hunt game. Or, if you celebrate Easter, give this to your kids -- it's cheaper and easier than hiding chocolate eggs!

如果您有休息日，则可以花一些时间玩这个Excel Treasure Hunt游戏。 或者，如果您庆祝复活节，请把它送给您的孩子-比隐藏巧克力蛋更便宜，更容易！

如何玩游戏 (How to Play the Game)

The main worksheet has 25 dark green cells, invisibly numbered 1 to 25. Some of the cells have a flower (good) and some have a raindrop (bad).

主工作表上有25个深绿色单元格，无形地编号为1到25。一些单元格上有花(好)，有些上有雨滴(坏)。

• Type a number, between 1 and 25, in each of the blue cells, to reveal the hidden items in those numbered cells.
  在每个蓝色单元格中键入一个介于1到25之间的数字，以显示这些已编号单元格中的隐藏项目。
• Your score -- the number of "good" items that you found -- appears below the green grid.
  您的分数-找到的“好”项目的数量-出现在绿色网格下方。
• To clear the blue cells, and scramble the hidden items, click the New Game button.
  要清除蓝色单元格并扰乱隐藏的项目，请单击“新建游戏”按钮。

改变游戏 (Change the Game)

If flowers and raindrops aren't manly enough for you, or if you get bored easily, you can select a different game.

如果花和雨滴不足以吸引您，或者您容易感到无聊，则可以选择其他游戏。

Click the data validation drop down arrow at the top left of the worksheet, and click on a game name to select it.

单击工作表左上方的数据验证下拉箭头，然后单击游戏名称以将其选中。

On the workbook's Lists worksheet, there's a lookup table with the different games and their symbols.

在工作簿的“列表”工作表上，有一个包含不同游戏及其符号的查找表。

The words in the Find and Avoid columns are used in the game's instructions.

在游戏说明中使用了“查找和避免”列中的文字。

修改游戏 (Modify the Game)

For younger children, or if you enjoy the thrill of victory, you can make the game easier, by increasing the number of "good" items that are hidden.

对于年幼的孩子，或者如果您喜欢胜利的快感，可以通过增加隐藏的“好”物品的数量来使游戏变得更容易。

On the Lists worksheet, in cell B2, type any number between 5 and 25.

在“列表”工作表上，在单元格B2中，键入5到25之间的任意数字。

You can also change the message associated with each score, by typing in the blue cells (C12:C17) on the Lists worksheet. I'll leave that to your imagination, but remember, our goal is not to make small children cry.

您还可以通过输入“列表”工作表上的蓝色单元格(C12：C17)来更改与每个乐谱相关的消息。 我会让你想像一下，但是请记住，我们的目标不是让小孩子哭泣。

Excel寻宝游戏的工作原理 (How the Excel Treasure Hunt Game Works)

Here's the formula in cell D4 of the dark green grid

这是深绿色网格的单元格D4中的公式

• =IF(COUNTIF($B$4:$B$8,(5*(ROW()-4))+(COLUMN()-3))=0,"", IF(COUNTIF(Wins,(5*(ROW()-4))+(COLUMN()-3)), CHAR(Lists!$B$7),CHAR(Lists!$C$7)))

  = IF(COUNTIF($ B $ 4：$ B $ 8， (5 *(ROW()-4))+(COLUMN()-3) )= 0，“”，IF(COUNTIF(Wins， (5 *(ROW ()-4))+(COLUMN()-3) )，CHAR(清单！$ B $ 7)，CHAR(清单！$ C $ 7)))

The part that's coloured blue just calculates the cell's number in the grid. The first COUNTIF checks to see if the grid number has been entered in the blue cells.

蓝色部分仅计算网格中的单元格编号。 第一个COUNTIF检查是否在蓝色单元格中输入了网格编号。

• COUNTIF($B$4:$B$8,(5*(ROW()-4))+(COLUMN()-3))

  COUNTIF($ B $ 4：$ B $ 8， (5 *(ROW()-4))+(COLUMN()-3) )

If not, the result is an empty string: "" If the grid number has been entered, the second COUNTIF checks for that number in a dynamic range named Wins, which is based on the number of winning items that you set.

如果不是，则结果为空字符串： “”如果已输入网格号，则第二个COUNTIF将根据您设置的中奖项目数，在名为Wins的动态范围内检查该数字。

• IF(COUNTIF(Wins,(5*(ROW()-4))+(COLUMN()-3))

  IF(COUNTIF(胜利， (5 *(ROW()-4))+(COLUMN()-3) )

If the grid number is in the Wins range, the WinPic symbol is shown, otherwise the LosePic symbol appears.

如果网格编号在Wins范围内，则显示WinPic符号，否则显示LosePic符号。

• CHAR(Lists!$B$7),CHAR(Lists!$C$7)

  CHAR(清单！$ B $ 7)，CHAR(清单！$ C $ 7)

为获奖物品上色 (Colour the Winning Items)

The dark green cells on the Hunt worksheet are formatted with 28 pt Wingdings black font. A conditional formatting formula colours the font if a winning item is found.

Hunt工作表上的深绿色单元格格式为28 pt Wingdings黑色字体。 如果找到获奖项目，则条件格式公式会将字体着色。

下载Excel寻宝游戏 (Download the Excel Treasure Hunt Game)

To enjoy some Excel treasure hunting, you can download the sample file: Excel Treasure Hunt Game. It's a zipped file, in Excel 2007 format. For the New Game button to work, you'll have to enable macros. The Hunt sheet is protected, with no password.

要享受一些Excel寻宝的乐趣，可以下载示例文件： Excel Treasure Hunt Game 。 这是一个压缩文件，格式为Excel 2007。 为了使“新游戏”按钮起作用，您必须启用宏。 查找表受保护，没有密码。

Or, you can download the Excel 2003 version of the game: Excel Treasure Hunt Game 2003. For the New Game button to work, you'll have to enable macros. The Hunt sheet is protected, with no password. _________

或者，您可以下载游戏的Excel 2003版本： Excel Treasure Hunt Game 2003 。 为了使“新游戏”按钮起作用，您必须启用宏。 查找表受保护，没有密码。 _________

翻译自: https://contexturesblog.com/archives/2010/04/02/excel-treasure-hunt-game/

寻宝游戏设定