Excel电子表格能计算处理大量数据,并进行图形分析,是个强大的数据分析工具。你可以用它计算很多数据的总和。这篇文章将以简单的费用报表为例,讲述如何在微软Excel软件里制作一个简单的电子表格。
步骤
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/b\/ba\/Make-a-Spreadsheet-in-Excel-Step-1-Version-4.jpg\/v4-460px-Make-a-Spreadsheet-in-Excel-Step-1-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/b\/ba\/Make-a-Spreadsheet-in-Excel-Step-1-Version-4.jpg\/v4-728px-Make-a-Spreadsheet-in-Excel-Step-1-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
1
打开Excel。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/9\/92\/Make-a-Spreadsheet-in-Excel-Step-2-Version-4.jpg\/v4-460px-Make-a-Spreadsheet-in-Excel-Step-2-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/9\/92\/Make-a-Spreadsheet-in-Excel-Step-2-Version-4.jpg\/v4-728px-Make-a-Spreadsheet-in-Excel-Step-2-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
2
注意界面中有很多行和很多列。
- 每一列的最上面都有一个大写字母,来标记它是哪一列。
- 每一行最左列的单元格旁边就有一个数字,来标记它是哪一行。
- 把每一列的字母和每一行的数字结合起来,就能组成每个单元格独特的“位置”。例如,第一列第一行的单元格的位置是A1,第二列第三行的单元格则是B3。
- 如果你点击任意一个单元格,它的地址就会出现在A列上面的空格内。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/e\/eb\/Make-a-Spreadsheet-in-Excel-Step-3-Version-4.jpg\/v4-460px-Make-a-Spreadsheet-in-Excel-Step-3-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/e\/eb\/Make-a-Spreadsheet-in-Excel-Step-3-Version-4.jpg\/v4-728px-Make-a-Spreadsheet-in-Excel-Step-3-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
3
点击A1单元格,输入:事项。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/0\/0c\/Make-a-Spreadsheet-in-Excel-Step-4-Version-4.jpg\/v4-460px-Make-a-Spreadsheet-in-Excel-Step-4-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/0\/0c\/Make-a-Spreadsheet-in-Excel-Step-4-Version-4.jpg\/v4-728px-Make-a-Spreadsheet-in-Excel-Step-4-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
4
点击B1单元格,输入:花费。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/5\/54\/Make-a-Spreadsheet-in-Excel-Step-5-Version-4.jpg\/v4-460px-Make-a-Spreadsheet-in-Excel-Step-5-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/5\/54\/Make-a-Spreadsheet-in-Excel-Step-5-Version-4.jpg\/v4-728px-Make-a-Spreadsheet-in-Excel-Step-5-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
5
点击A2单元格,输入:打印。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/6\/6e\/Make-a-Spreadsheet-in-Excel-Step-6-Version-4.jpg\/v4-460px-Make-a-Spreadsheet-in-Excel-Step-6-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/6\/6e\/Make-a-Spreadsheet-in-Excel-Step-6-Version-4.jpg\/v4-728px-Make-a-Spreadsheet-in-Excel-Step-6-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
6
点击B2单元格,输入:80.00。
- 当你点击B2单元格外面的位置,数字80就会出现在B2单元格中。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/7\/7b\/Make-a-Spreadsheet-in-Excel-Step-7-Version-4.jpg\/v4-460px-Make-a-Spreadsheet-in-Excel-Step-7-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/7\/7b\/Make-a-Spreadsheet-in-Excel-Step-7-Version-4.jpg\/v4-728px-Make-a-Spreadsheet-in-Excel-Step-7-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
7
点击A3单元格,输入:邮费。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/8\/8c\/Make-a-Spreadsheet-in-Excel-Step-8-Version-4.jpg\/v4-460px-Make-a-Spreadsheet-in-Excel-Step-8-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/8\/8c\/Make-a-Spreadsheet-in-Excel-Step-8-Version-4.jpg\/v4-728px-Make-a-Spreadsheet-in-Excel-Step-8-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
8
点击B3单元格,输入:75.55。
- 当你点击B3单元格外面的位置,数字75.55就会出现在B3单元格中。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/0\/06\/Make-a-Spreadsheet-in-Excel-Step-9-Version-4.jpg\/v4-460px-Make-a-Spreadsheet-in-Excel-Step-9-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/0\/06\/Make-a-Spreadsheet-in-Excel-Step-9-Version-4.jpg\/v4-728px-Make-a-Spreadsheet-in-Excel-Step-9-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
9
点击A4单元格,输入:信封。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/f\/f8\/Make-a-Spreadsheet-in-Excel-Step-10-Version-4.jpg\/v4-460px-Make-a-Spreadsheet-in-Excel-Step-10-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/f\/f8\/Make-a-Spreadsheet-in-Excel-Step-10-Version-4.jpg\/v4-728px-Make-a-Spreadsheet-in-Excel-Step-10-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
10
点击B4单元格,输入:6.00。
- 点击B4单元格外面的位置后,数字6就会出现在B4单元格中。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/6\/61\/Make-a-Spreadsheet-in-Excel-Step-11-Version-4.jpg\/v4-460px-Make-a-Spreadsheet-in-Excel-Step-11-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/6\/61\/Make-a-Spreadsheet-in-Excel-Step-11-Version-4.jpg\/v4-728px-Make-a-Spreadsheet-in-Excel-Step-11-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
11
点击A5单元格,输入:总额。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/7\/7b\/Make-a-Spreadsheet-in-Excel-Step-12-Version-4.jpg\/v4-460px-Make-a-Spreadsheet-in-Excel-Step-12-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/7\/7b\/Make-a-Spreadsheet-in-Excel-Step-12-Version-4.jpg\/v4-728px-Make-a-Spreadsheet-in-Excel-Step-12-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
12
点击B5单元格,输入:=SUM(B2:B4)。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/f\/f8\/Make-a-Spreadsheet-in-Excel-Step-13-Version-4.jpg\/v4-460px-Make-a-Spreadsheet-in-Excel-Step-13-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/f\/f8\/Make-a-Spreadsheet-in-Excel-Step-13-Version-4.jpg\/v4-728px-Make-a-Spreadsheet-in-Excel-Step-13-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
13
点击另一个单元格,总额161.55就会出现在B5单元格中。
- SUM(B2:B4)是一个计算公式。在Excel中,你可以使用公式来实现多种数学计算。把等号(=)放在公式的前面是很重要的,这能让Excel程序知道后面的是计算公式。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/a\/af\/Make-a-Spreadsheet-in-Excel-Step-14-Version-4.jpg\/v4-460px-Make-a-Spreadsheet-in-Excel-Step-14-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/a\/af\/Make-a-Spreadsheet-in-Excel-Step-14-Version-4.jpg\/v4-728px-Make-a-Spreadsheet-in-Excel-Step-14-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
14
点击保存。
小提示
- 小提示适用于Excel 2003及更早版本的Excel程序。
- 选择B2单元格到B4单元格,然后向下拖动填充柄可以直接求出它们的和。
你需要准备
-
运载有Windows或Mac OSX OS系统的计算机
-
微软Excel程序