Unit 44
Help with excel
職場攻略/辦公日常
English for the workplace/Communication in workplace
BRAIN STORM
Share your ideas with your teacher and try to make sentences.
Have you ever tried using an excel spreadsheet?
How was your experience?
What can excel spreadsheets do?
VOCABULARY
Repeat these sentences after your teacher.
1. paste (n.) 粘貼
It is easy to copy and paste the document.
複製和粘貼文檔很容易。
2. spreadsheet (n.) 表單、工作表
The spreadsheets are so confusing.
電子表格太混亂了。
3. formulas (n.) 公式
I don’t know all the formulas!
我不知道所有的公式！
4. undo (v.) 撤銷
How can we undo the changes we have made?
我們如何撤消我們所做的更改？
5. saved over (phr.) 覆盖保存
It saved over unnecessary files.
它保存了不必要的文件。
6. column (n.) 列
How many columns do you need?
你需要多少列？
7. data (n.) 數據
The data storage space of your computer is too small.
你的電腦的資料存放空間太小了
8. formatted (n.) 設置格式
It needs to be formatted to work properly.
它需要格式化才能正常工作。
Dialogue
Read the dialogue aloud with your teacher.
Ahh!
啊！
What’s wrong?
怎麼了？
I tried to paste some numbers into the spreadsheet. Now the formulas are all messed up!
我想往數據表裡粘貼幾個數位。 現在整個公式都亂套了！
So, can’t you undo it?
啊，你不能撤銷嗎？
I accidentally saved over everything!
我不小心覆蓋保存了！
Okay well let me take a look. So what did you paste?
好吧，讓我看看。 你粘貼了什麼？
For the “Q2 Revenue” column I used data from a different spreadsheet, but it must have been formatted differently because now all of the formula cells show “Error”.
在「第二季度收益」那欄我用了另一張數據表的數位，不過格式好像不一樣，因為現在所有的公式格都顯示的是”錯誤”。
Oh, I see what the problem is. Try highlighting this row here. Right. Now right-click “Format Cells”. Good, now click on “general”. That should do it.
哦我知道怎麼回事兒了。 你試試勾選這一行。 對。 現在右擊”設置單元格格式” 好，現在點”通用”。 這樣應該就可以了。
You fixed it! I really owe you!
哇，你修好了！ 太謝謝你啦！
No sweat. Oh, by the way, just my personal opinion, but these three cells at the top: I think you should merge them together. It makes the spreadsheet a bit more presentable.
沒事。 噢，還有我個人覺得，最上面的三個單元格，如果你把他們合併在一起，這樣整張表看起來效果會更好。
Let's Practice
Make it right.
__ to paste some numbers into the spreadsheet.
1.try
2.tried
I really _____ you!
1.owe
2.pay
1.“It must have been formatted” means: ___________
A.The data is deleted.
B.The data is not arranged properly.
C.The data arrangement was changed.
D.The data is changed and deleted.
2. I __________ saved over everything!
A.incidental
B.accidently
C.incidentally
D.accidentally
I tried to __(1.)__ some numbers into the __(2.)__. Now the formulas are all __(3.)__ up!
put / messing / sheets / spread sheets / messed / paste
DISCUSSION
Make a conversation with your teacher.
1.Why do you think is it important to learn how to use excel? What are the most important Excel skills?
2. Is Excel difficult to learn? Why? Or why not?
