excel中輸入公式

用 Excel 的功能：

(1) 在 A column輸入所有數據

(2) 在 B1 column 輸入公式 : = 7.74 * A1 ，然後按頂部在 C column之上綠色 tick

(3) 然後按 cursor 在 B1 的右下角的黑色小型十字架向下拖曳，所有數據即時計算完成

Without using formulas, you can quickly multiply a set of numbers, by using the Paste Special command. In your case, numbers are multiplied by 7.74, and the result is a permanent change to the numbers.
1. In a blank cell (say F1), enter the amount by which you want to multiply, i.e. 7.74.
2. Copy the cell which contains the multiplication amount.
3. Select the cells which contain the amounts that you want to multiply (say A1:A10).
4. On the Ribbon's Home tab, click the arrow on the Paste button, then click Paste Special
In the Options section, click Multiply, then click OK.

Each of the selected numbers (in A1:A10) is automatically multiplied by 7.74.
After completing the change, delete the amount typed in cell F1.

Excel 就是計算機，用excel 不是每個數計，你可以輸入數後再列方程式計算，例如A 行輸入數字，B1 打入=A1*7.74，再將B1 抄滿整行。