PassEveryTest
English

Excel Formulas and Data Analysis Course: Text and date functions

Untimed topic quiz: 17 questions on Text and date functions, with an explanation after each answer. Questions and answers are shuffled every time.

  • Course
  • Canada
  • 96 questions
  • Checked October 13, 2026
  • Fact-checked October 13, 2026
Start with the lessonsExcel Formulas and Data Analysis Course: Lessons: about 240 minutes of reading. Every test question is covered in the lessons.

Topic quiz 4: Text and date functions

  1. Question 1 of 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
    Show answer

    Answer: B. CGY

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

  2. Question 2 of 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
    Show answer

    Answer: B. 0087

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

  3. Question 3 of 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
    Show answer

    Answer: 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 of 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
    Show answer

    Answer: C. 7

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

  5. Question 5 of 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
    Show answer

    Answer: A. Leo Martin

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

  6. Question 6 of 17

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

    Answer: 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 of 17

    What does =CONCAT("Priya","Nair") return?
    Show answer

    Answer: 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 of 17

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

    Answer: 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 of 17

    What does =SEARCH("lock","Smart Lock") return?
    Show answer

    Answer: 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 of 17

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

    Answer: D. FIND

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

  11. Question 11 of 17

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

    Answer: 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 of 17

    How does Excel store a date such as January 1, 1900?
    Show answer

    Answer: 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 of 17

    What date does =DATE(2026,14,1) return?
    Show answer

    Answer: A. 2027-02-01

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

  14. Question 14 of 17

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

    Answer: 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 of 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?
    Show answer

    Answer: 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 of 17

    What does =EOMONTH(DATE(2026,2,10),0) return?
    Show answer

    Answer: 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 of 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
    Show answer

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

Related tests