| (1) | 1.假設儲存格A1輸入2019/5/28，在儲存格B1輸入=year(a1)會顯示? (1) |
| * | (1) | 2019 |
| (2) | 5 |
| (3) | 28 |
| (4) | 0 |
| | |
| (2) | 2.假設儲存格A1輸入2019/5/28，在儲存格B1輸入=month(a1)會顯示? (2) |
| (1) | 2019 |
| * | (2) | 5 |
| (3) | 28 |
| (4) | 0 |
| | |
| (3) | 3.假設儲存格A1輸入2019/5/28，在儲存格B1輸入=day(a1)會顯示? (3) |
| (1) | 2019 |
| (2) | 5 |
| * | (3) | 28 |
| (4) | 0 |
| | |
| (4) | 4.假設儲存格A1輸入2019/5/28，在儲存格B1輸入=left(a1,4)會顯示? (4) |
| (1) | 2019 |
| (2) | 5 |
| (3) | 28 |
| * | (4) | 4361 |
| | |
| (1) | 5.假設儲存格A1輸入'2019/5/28，在儲存格B1輸入=left(A1,4)會顯示 (5) |
| * | (1) | 2019 |
| (2) | 5 |
| (3) | 28 |
| (4) | 4361 |
| | |
| (4) | 6.假設儲存格A1輸入5/28/2019，在儲存格B1輸入=year(a1)會顯示? (6) |
| (1) | 2019 |
| (2) | 5 |
| (3) | 28 |
| * | (4) | #Value! |
| | |
| (1) | 7.在英文輸入狀態按下什麼熱鍵可以自動輸入今天日期 (7) |
| * | (1) | ctrl+; |
| (2) | shift+enter |
| (3) | ctrl+shift+; |
| (4) | alt+Enter |
| | |
| (3) | 8.在英文輸入狀態按下什麼熱鍵可以自動目前時間 (8) |
| (1) | ctrl+; |
| (2) | shift+enter |
| * | (3) | ctrl+shift+; |
| (4) | alt+Enter |
| | |
| (2) | 9.假設儲存格A1輸入2018/2/28，在儲存格B1輸入=A1+1會顯示? (9) |
| (1) | 2019/2/29 |
| * | (2) | 2018/3/1 |
| (3) | #VALUE |
| (4) | 1 |
| | |
| (1) | 10.假設儲存格A1無任何輸入，在儲存格B1輸入=year(A1)會顯示? (10) |
| * | (1) | 1900 |
| (2) | 1901 |
| (3) | 1902 |
| (4) | 1903 |
| | |
| (1) | 11.那一個函數可以顯示目前日期 (11) |
| * | (1) | today |
| (2) | now |
| (3) | year |
| (4) | month |
| | |
| (2) | 12.那一個函數可以顯示目前日期加上時間 (12) |
| (1) | today |
| * | (2) | now |
| (3) | year |
| (4) | month |
| | |
| (3) | 13.假設儲存格A1輸入2019/5/28是星期二，在儲存格B1輸入=weekday(a1)會顯示? (13) |
| (1) | 1 |
| (2) | 2 |
| * | (3) | 3 |
| (4) | 4 |
| | |
| (2) | 14.下列那一個函數可以將文字日期變成日期格式 (14) |
| (1) | date |
| * | (2) | datevalue |
| (3) | now |
| (4) | today |
| | |
| (2) | 15.假設儲存格A1輸入1:00 PM，在儲存格B1輸入=hour(a1)會顯示? (15) |
| (1) | 1 |
| * | (2) | 13 |
| (3) | 2 |
| (4) | 3 |
| | |
| (2) | 16.假設儲存格A1輸入13:00，在儲存格B1輸入=hour(a1)會顯示? (16) |
| (1) | 1 |
| * | (2) | 13 |
| (3) | 2 |
| (4) | 3 |
| | |
| (3) | 17.假設儲存格A1輸入1:00PM，在儲存格B1輸入=hour(a1)會顯示? (17) |
| (1) | 13 |
| (2) | 1 |
| * | (3) | #Value! |
| (4) | 0 |
| | |
| (1) | 18.假設儲存格A1輸入61/5/28按Enter，然後在儲存格B1輸入=year(a1)會顯示? (18) |
| * | (1) | 1961 |
| (2) | 61 |
| (3) | 5 |
| (4) | 28 |
| | |
| (2) | 19.假設儲存格A1輸入108/5/28按Enter，然後在儲存格B1輸入=year(a1)會顯示? (19) |
| (1) | 18 |
| * | (2) | #Value! |
| (3) | 5 |
| (4) | 28 |
| | |
| (2) | 20.假設儲存格A1輸入13:05，在儲存格B1輸入=minute(a1)會顯示? (20) |
| (1) | 13 |
| * | (2) | 5 |
| (3) | 05 |
| (4) | 1 |
| | |
