PassEveryTest
العربية

Excel Formulas and Data Analysis Course: Text and date functions

اختبار موضوعي بلا وقت محدد: 17 سؤالًا عن Text and date functions، مع شرح بعد كل إجابة. تُخلط الأسئلة والإجابات في كل مرة.

  • دورة
  • كندا
  • عدد الأسئلة: 96
  • تمت المراجعة في 13 أكتوبر 2026
  • تم التحقق من الحقائق في 13 أكتوبر 2026
ابدأ بالدروسExcel Formulas and Data Analysis Course: Lessons: نحو 240 دقيقة من القراءة. كل أسئلة الاختبار مشروحة في الدروس.

اختبار الموضوع 4: Text and date functions

  1. السؤال 1 من 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
    أظهر الإجابة

    الإجابة: B. CGY

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

  2. السؤال 2 من 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
    أظهر الإجابة

    الإجابة: B. 0087

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

  3. السؤال 3 من 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
    أظهر الإجابة

    الإجابة: A. 11

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

  4. السؤال 4 من 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
    أظهر الإجابة

    الإجابة: C. 7

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

  5. السؤال 5 من 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
    أظهر الإجابة

    الإجابة: A. Leo Martin

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

  6. السؤال 6 من 17

    Which letters are capitals in the result of =PROPER("jean-luc ROY")?
    أظهر الإجابة

    الإجابة: 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. السؤال 7 من 17

    What does =CONCAT("Priya","Nair") return?
    أظهر الإجابة

    الإجابة: 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. السؤال 8 من 17

    In the sheet below, A3 is empty. What does =TEXTJOIN(", ",TRUE,A2:A5) return?
    A
    1Site
    2Calgary
    3
    4Red Deer
    5Lethbridge
    أظهر الإجابة

    الإجابة: B. Calgary, Red Deer, Lethbridge

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

  9. السؤال 9 من 17

    What does =SEARCH("lock","Smart Lock") return?
    أظهر الإجابة

    الإجابة: A. 7

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

  10. السؤال 10 من 17

    You need to find text in a cell, and uppercase and lowercase must match exactly. Which function should you use?
    أظهر الإجابة

    الإجابة: D. FIND

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

  11. السؤال 11 من 17

    You join a label and a date with =A2&" "&B2, and the date shows as a number such as 46083. What fixes this?
    أظهر الإجابة

    الإجابة: 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. السؤال 12 من 17

    How does Excel store a date such as January 1, 1900?
    أظهر الإجابة

    الإجابة: 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. السؤال 13 من 17

    What date does =DATE(2026,14,1) return?
    أظهر الإجابة

    الإجابة: A. 2027-02-01

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

  14. السؤال 14 من 17

    March 2, 2026 is a Monday. What does =WEEKDAY(DATE(2026,3,2)) return?
    أظهر الإجابة

    الإجابة: 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. السؤال 15 من 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?
    أظهر الإجابة

    الإجابة: 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. السؤال 16 من 17

    What does =EOMONTH(DATE(2026,2,10),0) return?
    أظهر الإجابة

    الإجابة: 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. السؤال 17 من 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
    أظهر الإجابة

    الإجابة: 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.

اختبارات ذات صلة