PassEveryTest
Nederlands

Excel Formulas and Data Analysis Course: Text and date functions

Themaquiz zonder tijdslimiet: 17 vragen over Text and date functions, met een uitleg na elk antwoord. Vragen en antwoorden worden elke keer gehusseld.

  • Cursus
  • Canada
  • 96 vragen
  • Gecontroleerd op 13 oktober 2026
  • Feiten gecontroleerd op 13 oktober 2026
Begin met de lessenExcel Formulas and Data Analysis Course: Lessons: ongeveer 240 minuten leestijd. Elke testvraag wordt in de lessen behandeld.

Themaquiz 4: Text and date functions

  1. Vraag 1 van 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
    Toon antwoord

    Antwoord: B. CGY

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

  2. Vraag 2 van 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
    Toon antwoord

    Antwoord: B. 0087

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

  3. Vraag 3 van 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
    Toon antwoord

    Antwoord: A. 11

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

  4. Vraag 4 van 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
    Toon antwoord

    Antwoord: C. 7

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

  5. Vraag 5 van 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
    Toon antwoord

    Antwoord: A. Leo Martin

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

  6. Vraag 6 van 17

    Which letters are capitals in the result of =PROPER("jean-luc ROY")?
    Toon antwoord

    Antwoord: 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. Vraag 7 van 17

    What does =CONCAT("Priya","Nair") return?
    Toon antwoord

    Antwoord: 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. Vraag 8 van 17

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

    Antwoord: B. Calgary, Red Deer, Lethbridge

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

  9. Vraag 9 van 17

    What does =SEARCH("lock","Smart Lock") return?
    Toon antwoord

    Antwoord: A. 7

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

  10. Vraag 10 van 17

    You need to find text in a cell, and uppercase and lowercase must match exactly. Which function should you use?
    Toon antwoord

    Antwoord: D. FIND

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

  11. Vraag 11 van 17

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

    Antwoord: 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. Vraag 12 van 17

    How does Excel store a date such as January 1, 1900?
    Toon antwoord

    Antwoord: 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. Vraag 13 van 17

    What date does =DATE(2026,14,1) return?
    Toon antwoord

    Antwoord: A. 2027-02-01

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

  14. Vraag 14 van 17

    March 2, 2026 is a Monday. What does =WEEKDAY(DATE(2026,3,2)) return?
    Toon antwoord

    Antwoord: 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. Vraag 15 van 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?
    Toon antwoord

    Antwoord: 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. Vraag 16 van 17

    What does =EOMONTH(DATE(2026,2,10),0) return?
    Toon antwoord

    Antwoord: 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. Vraag 17 van 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
    Toon antwoord

    Antwoord: 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.

Gerelateerde examens