PassEveryTest
Polski

Excel Formulas and Data Analysis Course: Text and date functions

Quiz tematyczny bez limitu czasu: 17 pytań o Text and date functions, z wyjaśnieniem po każdej odpowiedzi. Pytania i odpowiedzi są za każdym razem mieszane.

  • Kurs
  • Kanada
  • Pytania: 96
  • Sprawdzono 13 października 2026
  • Fakty sprawdzone 13 października 2026
Zacznij od lekcjiExcel Formulas and Data Analysis Course: Lessons: ok. 240 min czytania. Każde pytanie testowe jest omówione w lekcjach.

Quiz tematyczny 4: Text and date functions

  1. Pytanie 1 z 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
    Pokaż odpowiedź

    Odpowiedź: B. CGY

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

  2. Pytanie 2 z 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
    Pokaż odpowiedź

    Odpowiedź: B. 0087

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

  3. Pytanie 3 z 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
    Pokaż odpowiedź

    Odpowiedź: A. 11

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

  4. Pytanie 4 z 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
    Pokaż odpowiedź

    Odpowiedź: C. 7

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

  5. Pytanie 5 z 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
    Pokaż odpowiedź

    Odpowiedź: A. Leo Martin

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

  6. Pytanie 6 z 17

    Which letters are capitals in the result of =PROPER("jean-luc ROY")?
    Pokaż odpowiedź

    Odpowiedź: 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. Pytanie 7 z 17

    What does =CONCAT("Priya","Nair") return?
    Pokaż odpowiedź

    Odpowiedź: 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. Pytanie 8 z 17

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

    Odpowiedź: B. Calgary, Red Deer, Lethbridge

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

  9. Pytanie 9 z 17

    What does =SEARCH("lock","Smart Lock") return?
    Pokaż odpowiedź

    Odpowiedź: A. 7

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

  10. Pytanie 10 z 17

    You need to find text in a cell, and uppercase and lowercase must match exactly. Which function should you use?
    Pokaż odpowiedź

    Odpowiedź: D. FIND

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

  11. Pytanie 11 z 17

    You join a label and a date with =A2&" "&B2, and the date shows as a number such as 46083. What fixes this?
    Pokaż odpowiedź

    Odpowiedź: 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. Pytanie 12 z 17

    How does Excel store a date such as January 1, 1900?
    Pokaż odpowiedź

    Odpowiedź: 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. Pytanie 13 z 17

    What date does =DATE(2026,14,1) return?
    Pokaż odpowiedź

    Odpowiedź: A. 2027-02-01

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

  14. Pytanie 14 z 17

    March 2, 2026 is a Monday. What does =WEEKDAY(DATE(2026,3,2)) return?
    Pokaż odpowiedź

    Odpowiedź: 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. Pytanie 15 z 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?
    Pokaż odpowiedź

    Odpowiedź: 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. Pytanie 16 z 17

    What does =EOMONTH(DATE(2026,2,10),0) return?
    Pokaż odpowiedź

    Odpowiedź: 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. Pytanie 17 z 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
    Pokaż odpowiedź

    Odpowiedź: 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.

Powiązane testy