PassEveryTest
Français

Excel Formulas and Data Analysis Course: Text and date functions

Quiz thématique sans limite de temps : 17 questions sur Text and date functions, avec une explication après chaque réponse. Les questions et les réponses sont mélangées à chaque fois.

  • Formation
  • Canada
  • 96 questions
  • Vérifié le 13 octobre 2026
  • Vérifié (faits) le 13 octobre 2026
Commencez par les leçonsExcel Formulas and Data Analysis Course: Lessons : environ 240 minutes de lecture. Chaque question du test est traitée dans les leçons.

Quiz thématique 4 : Text and date functions

  1. Question 1 sur 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
    Voir la réponse

    Réponse: B. CGY

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

  2. Question 2 sur 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
    Voir la réponse

    Réponse: B. 0087

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

  3. Question 3 sur 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
    Voir la réponse

    Réponse: A. 11

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

  4. Question 4 sur 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
    Voir la réponse

    Réponse: C. 7

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

  5. Question 5 sur 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
    Voir la réponse

    Réponse: A. Leo Martin

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

  6. Question 6 sur 17

    Which letters are capitals in the result of =PROPER("jean-luc ROY")?
    Voir la réponse

    Réponse: 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. Question 7 sur 17

    What does =CONCAT("Priya","Nair") return?
    Voir la réponse

    Réponse: 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. Question 8 sur 17

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

    Réponse: B. Calgary, Red Deer, Lethbridge

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

  9. Question 9 sur 17

    What does =SEARCH("lock","Smart Lock") return?
    Voir la réponse

    Réponse: A. 7

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

  10. Question 10 sur 17

    You need to find text in a cell, and uppercase and lowercase must match exactly. Which function should you use?
    Voir la réponse

    Réponse: D. FIND

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

  11. Question 11 sur 17

    You join a label and a date with =A2&" "&B2, and the date shows as a number such as 46083. What fixes this?
    Voir la réponse

    Réponse: 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. Question 12 sur 17

    How does Excel store a date such as January 1, 1900?
    Voir la réponse

    Réponse: 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. Question 13 sur 17

    What date does =DATE(2026,14,1) return?
    Voir la réponse

    Réponse: A. 2027-02-01

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

  14. Question 14 sur 17

    March 2, 2026 is a Monday. What does =WEEKDAY(DATE(2026,3,2)) return?
    Voir la réponse

    Réponse: 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. Question 15 sur 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?
    Voir la réponse

    Réponse: 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. Question 16 sur 17

    What does =EOMONTH(DATE(2026,2,10),0) return?
    Voir la réponse

    Réponse: 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. Question 17 sur 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
    Voir la réponse

    Réponse: 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.

Tests associés