PassEveryTest
中文

Excel Formulas and Data Analysis Course：Text and date functions

不限时专题测验：关于Text and date functions的17道题，每道题作答后都有解释。每次题目和选项都会重新打乱。

  • 课程
  • 加拿大
  • 96道题
  • 核对于2026年10月13日
  • 事实核查：2026年10月13日
从课文开始Excel Formulas and Data Analysis Course: Lessons：阅读时间约240分钟。测试中的每道题在课文中都有讲解。

专题测验4：Text and date functions

  1. 第1题，共17题

    In the staff list below, what does =LEFT(B2,3) return?
    ABCD
    1NameIDStart dateEmail
    2Priya NairCGY-04122019-06-15priya.nair@example.com
    3Jo TranEDM-00872023-11-06jo.tran@example.com
    4 Leo Martin RED-11502025-02-03leo.martin@example.com
    显示答案

    答案: B. CGY

    LEFT returns characters from the start of the text. The first 3 characters of CGY-0412 are CGY.

  2. 第2题，共17题

    In the staff list below, what does =RIGHT(B3,4) return?
    ABCD
    1NameIDStart dateEmail
    2Priya NairCGY-04122019-06-15priya.nair@example.com
    3Jo TranEDM-00872023-11-06jo.tran@example.com
    4 Leo Martin RED-11502025-02-03leo.martin@example.com
    显示答案

    答案: B. 0087

    RIGHT returns the last 4 characters as text, so the leading zeros stay: 0087.

  3. 第3题，共17题

    In the staff list below, what does =MID(B4,5,2) return?
    ABCD
    1NameIDStart dateEmail
    2Priya NairCGY-04122019-06-15priya.nair@example.com
    3Jo TranEDM-00872023-11-06jo.tran@example.com
    4 Leo Martin RED-11502025-02-03leo.martin@example.com
    显示答案

    答案: A. 11

    MID starts at character 5 and takes 2 characters. In RED-1150, characters 5 and 6 are 1 and 1.

  4. 第4题，共17题

    In the staff list below, what does =LEN(A3) return?
    ABCD
    1NameIDStart dateEmail
    2Priya NairCGY-04122019-06-15priya.nair@example.com
    3Jo TranEDM-00872023-11-06jo.tran@example.com
    4 Leo Martin RED-11502025-02-03leo.martin@example.com
    显示答案

    答案: C. 7

    LEN counts every character, and spaces count. "Jo Tran" has 6 letters and 1 space.

  5. 第5题，共17题

    Cell A4 in the staff list below has extra spaces. What does =TRIM(A4) return?
    ABCD
    1NameIDStart dateEmail
    2Priya NairCGY-04122019-06-15priya.nair@example.com
    3Jo TranEDM-00872023-11-06jo.tran@example.com
    4 Leo Martin RED-11502025-02-03leo.martin@example.com
    显示答案

    答案: A. Leo Martin

    TRIM removes spaces at the start and end and leaves single spaces between words.

  6. 第6题，共17题

    Which letters are capitals in the result of =PROPER("jean-luc ROY")?
    显示答案

    答案: C. J, L and R

    PROPER capitalizes the first letter and any letter after a non-letter (such as a hyphen or space), and makes all other letters lowercase, so the result is Jean-Luc Roy.

  7. 第7题，共17题

    What does =CONCAT("Priya","Nair") return?
    显示答案

    答案: C. PriyaNair

    CONCAT joins the text exactly as given and does not add a delimiter. Add " " between the parts, or use TEXTJOIN, to get a space.

  8. 第8题，共17题

    In the sheet below, A3 is empty. What does =TEXTJOIN(", ",TRUE,A2:A5) return?
    A
    1Site
    2Calgary
    3
    4Red Deer
    5Lethbridge
    显示答案

    答案: B. Calgary, Red Deer, Lethbridge

    TEXTJOIN puts the delimiter ", " between items. With ignore_empty set to TRUE, the empty cell is skipped.

  9. 第9题，共17题

    What does =SEARCH("lock","Smart Lock") return?
    显示答案

    答案: A. 7

    SEARCH is not case sensitive, so "lock" matches "Lock", which starts at the 7th character (the space is character 6).

  10. 第10题，共17题

    You need to find text in a cell, and uppercase and lowercase must match exactly. Which function should you use?
    显示答案

    答案: D. FIND

    SEARCH ignores case. Microsoft says to use FIND when you need a case-sensitive search.

  11. 第11题，共17题

    You join a label and a date with =A2&" "&B2, and the date shows as a number such as 46083. What fixes this?
    显示答案

    答案: C. Use TEXT(B2,"yyyy-mm-dd") in the formula

    When numbers are joined to text, Excel drops their number format. TEXT turns the date into text in the format you choose.

  12. 第12题，共17题

    How does Excel store a date such as January 1, 1900?
    显示答案

    答案: C. As a serial number

    Excel stores dates as serial numbers so it can calculate with them. January 1, 1900 is serial number 1.

  13. 第13题，共17题

    What date does =DATE(2026,14,1) return?
    显示答案

    答案: A. 2027-02-01

    A month over 12 rolls into the next year. Month 14 of 2026 is February 2027.

  14. 第14题，共17题

    March 2, 2026 is a Monday. What does =WEEKDAY(DATE(2026,3,2)) return?
    显示答案

    答案: B. 2

    With no return_type, WEEKDAY numbers the days 1 (Sunday) to 7 (Saturday), so Monday is 2. Use return_type 2 to make Monday 1.

  15. 第15题，共17题

    A2 holds 2026-03-02, B2 holds 2026-03-13 and C2 holds a holiday, 2026-03-09. What does =NETWORKDAYS(A2,B2,C2) return?
    显示答案

    答案: B. 9

    March 2 to 13 has 10 weekdays, counting both the start and end dates. The holiday on Monday, March 9 is removed, leaving 9.

  16. 第16题，共17题

    What does =EOMONTH(DATE(2026,2,10),0) return?
    显示答案

    答案: B. 2026-02-28

    EOMONTH returns the last day of the month, 0 months away. 2026 is not a leap year, so February ends on the 28th.

  17. 第17题，共17题

    In the staff list below, what does =DATEDIF(C2,DATE(2026,3,2),"Y") return?
    ABCD
    1NameIDStart dateEmail
    2Priya NairCGY-04122019-06-15priya.nair@example.com
    3Jo TranEDM-00872023-11-06jo.tran@example.com
    4 Leo Martin RED-11502025-02-03leo.martin@example.com
    显示答案

    答案: D. 6

    The "Y" unit counts complete years. From June 15, 2019 to March 2, 2026 is 6 full years; the 7th year is not complete until June 15, 2026.

相关测试