PassEveryTest
Svenska

Excel Formulas and Data Analysis Course: Text and date functions

Temaquiz utan tidsgräns: 17 frågor om Text and date functions, med en förklaring efter varje svar. Frågor och svar blandas varje gång.

  • Kurs
  • Kanada
  • 96 frågor
  • Kontrollerad 13 oktober 2026
  • Faktagranskad 13 oktober 2026
Börja med lektionernaExcel Formulas and Data Analysis Course: Lessons: cirka 240 minuters läsning. Alla provfrågor tas upp i lektionerna.

Temaquiz 4: Text and date functions

  1. Fråga 1 av 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
    Visa svar

    Svar: B. CGY

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

  2. Fråga 2 av 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
    Visa svar

    Svar: B. 0087

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

  3. Fråga 3 av 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
    Visa svar

    Svar: A. 11

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

  4. Fråga 4 av 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
    Visa svar

    Svar: C. 7

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

  5. Fråga 5 av 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
    Visa svar

    Svar: A. Leo Martin

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

  6. Fråga 6 av 17

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

    Svar: 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. Fråga 7 av 17

    What does =CONCAT("Priya","Nair") return?
    Visa svar

    Svar: 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. Fråga 8 av 17

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

    Svar: B. Calgary, Red Deer, Lethbridge

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

  9. Fråga 9 av 17

    What does =SEARCH("lock","Smart Lock") return?
    Visa svar

    Svar: A. 7

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

  10. Fråga 10 av 17

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

    Svar: D. FIND

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

  11. Fråga 11 av 17

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

    Svar: 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. Fråga 12 av 17

    How does Excel store a date such as January 1, 1900?
    Visa svar

    Svar: 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. Fråga 13 av 17

    What date does =DATE(2026,14,1) return?
    Visa svar

    Svar: A. 2027-02-01

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

  14. Fråga 14 av 17

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

    Svar: 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. Fråga 15 av 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?
    Visa svar

    Svar: 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. Fråga 16 av 17

    What does =EOMONTH(DATE(2026,2,10),0) return?
    Visa svar

    Svar: 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. Fråga 17 av 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
    Visa svar

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

Relaterade prov