Simple Budget 简单预算
“Budgets” are an important part of accounting. Various departments in an organization will be given money to spend for supplies and materials that are needed. This is called a “Budget”. It is very important not to spend more money than what is available in your “Budget” though. Money that is not spent is called a “Surplus”. A “Deficit” is when more money is spent than is available.
“预算”是会计学中非常重要的。组织中的许多部门的所需的供给和原材料都需要一定的金额，这就叫做“预算”。不要花费超过“预算”中的金额数是非常重要的。预算在没有花完的钱叫“剩余”，而过多消费的部分叫“赤字”。
In this project you will create a spreadsheet for supplies needed for an office. All the Items, Quantities and Cost have already been determined. You will use the correct formulas to calculate all the necessary information to see if the proposed budget will result in a “Surplus” or “Deficit”.
在本项目中你将为办公室创建一个供给表。所有的条目、数量和花费都已给出。你将使用正确的公式计算出所有必要信息来检测预算提案会不会出现“剩余”和“赤字”。
In this project you will be required to use the values of several simple formulas to create more complicated totals. This can be done two different ways:
在本项目中你将运用几个简单公式的计算值来计算出复杂一点的计算值，可采用以下两种方法：
- Creating complex formulas
创建复杂公式
- Referencing the total of another formula in your new formula
在新的公式里套用另一个公式的值
Simple Formulas 简单公式
| Addition | 加法 | =SUM(CELL + CELL) |
| Subtraction | 减法 | =SUM(CELL – CELL) |
| Addition (List of Numbers) | 加法（数列) | =SUM(First CELL : Last CELL) |
| Multiplication | 乘法 | =(CELL * Cell) |
| Division | 除法 | =(CELL / CELL) |
| Average | 平均数 | =AVERAGE(First CELL : Last CELL) |
New in this Project 此项目新的公式
| Count | 计数 | =COUNT (First CELL : Last CELL) |
When finished your project will have 1 Spreadsheet with 3 separate Tables in it.
当项目完成时，将有1个电子表其中包括3个表格。
Table 1 Instructions
表1 说明
Row 1: Merge Cells B-E and type the Title
第1行：合并单元格B-E并输入标题
Row 2: Column B, C, D, and E type the headings provided in the example
第2行：在B、C、D栏中输入例证中提供的小标题
Row 3-9: Column A, B, and C, enter the provided Supplies, Quantities and Costs
第3-9行：在A、B、C栏中输入 Supplies, Quantities和Costs
Row 1-10Column A-F: Format like the example
第1-10行,A-F栏：照例设计
Row 3-9, Column E: Use a multiplication formula to find the total expense for each item
第3-9行，E栏：运用乘法公式计算每一栏的总值
Row 11: Leave blank
第11行：空白
Table 2 Instructions
表2 说明
Row 12: Merge Cells C and D and type the provided Title for the second Table
第12行：合并单元格C和D，并输入已给定的标题
Row 12-18, Column B-E: Format like the example, enter any provided information
第12-18行，B-E栏：照例设计并输入所给定的信息
Cell D14: Use an Addition formula to total the cost of all items being purchased
单元格D14：运用加法公式计算已经购买的物品的花费
Cell D15: Use a Subtraction formula to subtract the Total cost from the Budget
单元格D15：运用减法公式，用总花费中减去预算
Cell D17: Use a formula to find the Average Cost of the items being purchased
单元格D17：运用公式计算购买物品的平均值
Table 3 Instructions
表3 说明
Row 20-23, Column B-F: format like the example and enter all provided information
第20-23行，B-F栏：照例设计表格并输入所给定的信息
Cell D21: Use the Addition formula for multiple items to calculate how many items are being purchased.
单元格D21：运用加法公式计算总共订购了多少物品
Cell D22: Determine how many different types of items are being purchased. Try using the formula for counting the different types of items are in the list. This is different than the addition formula that counts the total of all items in a list. Count Formula =COUNT(‘C3’:’C9’)
单元格D22：显示所购买物品的种类数量。试着运用计数公式来计算总共订购了多少类物品。这跟运用加法公式计算订购多少物品时不一样的。计数公式: =COUNT(‘C3’:’C9’)
- How much money will be spent?
将要花费多少钱？ - Does this Budget have a Surplus or Deficit, and how much is it?
该预算中有剩余和赤字出现吗？是多少？ - What is the average cost of the items purchased?
所购买物品的平均值是多少？ - Once everything is ordered, how many items will be in the delivery?
当完成所有订购时，计算最终会有多少物品被派送？