PassEveryTest
Italiano

Excel Formulas and Data Analysis Course: Text and date functions

Quiz tematico senza limite di tempo: 17 domande su Text and date functions, con una spiegazione dopo ogni risposta. Domande e risposte vengono mescolate ogni volta.

  • Corso
  • Canada
  • 96 domande
  • Verificato: 13 ottobre 2026
  • Verificato il 13 ottobre 2026
Inizia dalle lezioniExcel Formulas and Data Analysis Course: Lessons: circa 240 minuti di lettura. Ogni domanda del test è trattata nelle lezioni.

Quiz tematico 4: Text and date functions

  1. Domanda 1 di 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
    Mostra la risposta

    Risposta: B. CGY

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

  2. Domanda 2 di 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
    Mostra la risposta

    Risposta: B. 0087

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

  3. Domanda 3 di 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
    Mostra la risposta

    Risposta: A. 11

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

  4. Domanda 4 di 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
    Mostra la risposta

    Risposta: C. 7

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

  5. Domanda 5 di 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
    Mostra la risposta

    Risposta: A. Leo Martin

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

  6. Domanda 6 di 17

    Which letters are capitals in the result of =PROPER("jean-luc ROY")?
    Mostra la risposta

    Risposta: 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. Domanda 7 di 17

    What does =CONCAT("Priya","Nair") return?
    Mostra la risposta

    Risposta: 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. Domanda 8 di 17

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

    Risposta: B. Calgary, Red Deer, Lethbridge

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

  9. Domanda 9 di 17

    What does =SEARCH("lock","Smart Lock") return?
    Mostra la risposta

    Risposta: A. 7

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

  10. Domanda 10 di 17

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

    Risposta: D. FIND

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

  11. Domanda 11 di 17

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

    Risposta: 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. Domanda 12 di 17

    How does Excel store a date such as January 1, 1900?
    Mostra la risposta

    Risposta: 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. Domanda 13 di 17

    What date does =DATE(2026,14,1) return?
    Mostra la risposta

    Risposta: A. 2027-02-01

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

  14. Domanda 14 di 17

    March 2, 2026 is a Monday. What does =WEEKDAY(DATE(2026,3,2)) return?
    Mostra la risposta

    Risposta: 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. Domanda 15 di 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?
    Mostra la risposta

    Risposta: 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. Domanda 16 di 17

    What does =EOMONTH(DATE(2026,2,10),0) return?
    Mostra la risposta

    Risposta: 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. Domanda 17 di 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
    Mostra la risposta

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

Test correlati