騷客。眼迷離。

Which is right?

□ 1. They hold a positive attitude to learning.

□ 2. They have a positive attitude to learning.

Excel函數：SUMIF

有時候需要在雜亂的資料庫中，過濾出某項值的總和，可運用函數SUMIF。

如下範例，計算出A君、B君、C君各要收多少錢。

游標點選F1欄位後，點選函數>其它函數

Which is right?

□ 1. I don't know how to do it.

□ 2. I don't know how to do.

Which is right?

□ 1. I blew out the candles after making my wishes.

□ 2. I blew the candles after making my wishes.

Which is right?

□ 1. Stress on the first syllable of the word.

□ 2. Stress the first syllable of the word.

Which is right?

□ 1. The body of this racing car is made of a new type of lightweight fiberglass.

□ 2. The body of this racing car is made by a new type of lightweight fiberglass.

Which is right?

□ 1. Baseball is my favorite sport because it's exciting and highly team-worked.

□ 2. Baseball is my favorite sport because it is exciting and involves teamwork.

如果要把資料中的字串做進一步的處理，例如將某個儲存格中的名字、中間名及姓氏分成三個不同的欄，文字函數是相當實用的方法。

公式說明

1. =LEFT(A3,1)

  =左邊開始(欄位,第1個字元)

Which is right?

□ 1. You will be working along side with very experienced people.

□ 2. You will be working along side very experienced people.

Which is right?

□ 1. Our library subscribes many business magazines.

□ 2. Our library subscribes to many business magazines.