1. 定义名称：将储存格的范围转化成容易记忆的名称

    • 方法一：

      1.          ![image.png](https://cdn.nlark.com/yuque/0/2021/png/22105762/1627049458603-8350b0fb-9550-4ca9-b59b-e3d8734e48c7.png#align=left&display=inline&height=58&margin=%5Bobject%20Object%5D&name=image.png&originHeight=116&originWidth=422&size=66646&status=done&style=none&width=211)<br />                ![image.png](https://cdn.nlark.com/yuque/0/2021/png/22105762/1627049485601-cae73978-8853-4112-9705-75bc8c4b61ec.png#align=left&display=inline&height=138&margin=%5Bobject%20Object%5D&name=image.png&originHeight=276&originWidth=503&size=113224&status=done&style=none&width=251.5)

    • 方法二：第一步框选资料，然后在左上角的栏位定义名字

    image.png

    • 公式：求和：在括号中直接输入“金额”就可以得到全部总和

      image.png

    • 名称管理：

    image.png
    image.png

    1. INDIRECT函数：以线索中的文字作为跳板，然后取得目标储存格的内容。
    • 线索可以来自于不停的储存格

    image.png

    1. 下拉选单
    • 第一步，选择“资料验证”

    image.png

    • 第二步

      1.     ![image.png](https://cdn.nlark.com/yuque/0/2021/png/22105762/1627050535438-da624fb9-119a-4f57-853c-7e7d51a45f68.png#align=left&display=inline&height=185&margin=%5Bobject%20Object%5D&name=image.png&originHeight=370&originWidth=575&size=130728&status=done&style=none&width=287.5)

    • 呈现结果：

      1.     ![image.png](https://cdn.nlark.com/yuque/0/2021/png/22105762/1627050567896-cda6f663-f489-422e-86a6-5fab4b1e1f7a.png#align=left&display=inline&height=113&margin=%5Bobject%20Object%5D&name=image.png&originHeight=117&originWidth=140&size=13402&status=done&style=none&width=135)

    • 餐点名称选择内容取决于早餐类型

      1. ![image.png](https://cdn.nlark.com/yuque/0/2021/png/22105762/1627050811731-f4a955d8-58a0-4691-8ad9-a55717f56d2b.png#align=left&display=inline&height=353&margin=%5Bobject%20Object%5D&name=image.png&originHeight=707&originWidth=1217&size=565668&status=done&style=none&width=608.5)<br />![image.png](https://cdn.nlark.com/yuque/0/2021/png/22105762/1627050893360-c842306c-f882-4428-bbc7-3b5bb7b7e683.png#align=left&display=inline&height=424&margin=%5Bobject%20Object%5D&name=image.png&originHeight=848&originWidth=1693&size=741875&status=done&style=none&width=846.5)