Excel Formulas and Data Analysis Course: Text and date functions

Quiz sa paksa na walang limitasyon sa oras: 17 tanong tungkol sa Text and date functions, may paliwanag pagkatapos ng bawat sagot. Binabago ang ayos ng mga tanong at sagot sa bawat pagkakataon.

Kurso
Canada
96 tanong
Sinuri noong Oktubre 13, 2026
Na-fact-check noong Oktubre 13, 2026

Magsimula sa mga aralinExcel Formulas and Data Analysis Course: Lessons: mga 240 minutong pagbasa. Saklaw ng mga aralin ang bawat tanong sa pagsusulit.

Quiz sa paksa 4: Text and date functions

Tanong 1 ng 17
In the staff list below, what does =LEFT(B2,3) return?
A B C D
1 Name ID Start date Email
2 Priya Nair CGY-0412 2019-06-15 priya.nair@example.com
3 Jo Tran EDM-0087 2023-11-06 jo.tran@example.com
4 Leo Martin RED-1150 2025-02-03 leo.martin@example.com
- CGY-
- CGY
- C
- 412
Ipakita ang sagot
Sagot: B. CGY
LEFT returns characters from the start of the text. The first 3 characters of CGY-0412 are CGY.
Tanong 2 ng 17
In the staff list below, what does =RIGHT(B3,4) return?
A B C D
1 Name ID Start date Email
2 Priya Nair CGY-0412 2019-06-15 priya.nair@example.com
3 Jo Tran EDM-0087 2023-11-06 jo.tran@example.com
4 Leo Martin RED-1150 2025-02-03 leo.martin@example.com
- EDM-
- 0087
- -0087
- 87
Ipakita ang sagot
Sagot: B. 0087
RIGHT returns the last 4 characters as text, so the leading zeros stay: 0087.
Tanong 3 ng 17
In the staff list below, what does =MID(B4,5,2) return?
A B C D
1 Name ID Start date Email
2 Priya Nair CGY-0412 2019-06-15 priya.nair@example.com
3 Jo Tran EDM-0087 2023-11-06 jo.tran@example.com
4 Leo Martin RED-1150 2025-02-03 leo.martin@example.com
- 11
- -1
- RE
- 15
Ipakita ang sagot
Sagot: A. 11
MID starts at character 5 and takes 2 characters. In RED-1150, characters 5 and 6 are 1 and 1.
Tanong 4 ng 17
In the staff list below, what does =LEN(A3) return?
A B C D
1 Name ID Start date Email
2 Priya Nair CGY-0412 2019-06-15 priya.nair@example.com
3 Jo Tran EDM-0087 2023-11-06 jo.tran@example.com
4 Leo Martin RED-1150 2025-02-03 leo.martin@example.com
- 5
- 6
- 7
- 2
Ipakita ang sagot
Sagot: C. 7
LEN counts every character, and spaces count. "Jo Tran" has 6 letters and 1 space.
Tanong 5 ng 17
Cell A4 in the staff list below has extra spaces. What does =TRIM(A4) return?
A B C D
1 Name ID Start date Email
2 Priya Nair CGY-0412 2019-06-15 priya.nair@example.com
3 Jo Tran EDM-0087 2023-11-06 jo.tran@example.com
4 Leo Martin RED-1150 2025-02-03 leo.martin@example.com
- Leo Martin
- LeoMartin
- Leo Martin
- Leo
Ipakita ang sagot
Sagot: A. Leo Martin
TRIM removes spaces at the start and end and leaves single spaces between words.
Tanong 6 ng 17
Which letters are capitals in the result of =PROPER("jean-luc ROY")?
- J and R only
- J, R, O and Y
- J, L and R
- None; PROPER only removes spaces
Ipakita ang sagot
Sagot: 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.
Tanong 7 ng 17
What does =CONCAT("Priya","Nair") return?
- Priya&Nair
- Priya Nair
- PriyaNair
- Priya,Nair
Ipakita ang sagot
Sagot: 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.
Tanong 8 ng 17
In the sheet below, A3 is empty. What does =TEXTJOIN(", ",TRUE,A2:A5) return?
A
1 Site
2 Calgary
3
4 Red Deer
5 Lethbridge
- Calgary, , Red Deer, Lethbridge
- Calgary, Red Deer, Lethbridge
- CalgaryRed DeerLethbridge
- Calgary, Red Deer
Ipakita ang sagot
Sagot: B. Calgary, Red Deer, Lethbridge
TEXTJOIN puts the delimiter ", " between items. With ignore_empty set to TRUE, the empty cell is skipped.
Tanong 9 ng 17
What does =SEARCH("lock","Smart Lock") return?
- 7
- 6
- #VALUE!
- 1
Ipakita ang sagot
Sagot: A. 7
SEARCH is not case sensitive, so "lock" matches "Lock", which starts at the 7th character (the space is character 6).
Tanong 10 ng 17
You need to find text in a cell, and uppercase and lowercase must match exactly. Which function should you use?
- TRIM
- PROPER
- SEARCH
- FIND
Ipakita ang sagot
Sagot: D. FIND
SEARCH ignores case. Microsoft says to use FIND when you need a case-sensitive search.
Tanong 11 ng 17
You join a label and a date with =A2&" "&B2, and the date shows as a number such as 46083. What fixes this?
- Format the result cell as Short Date
- Use SUM(A2,B2) instead of the & operator
- Use TEXT(B2,"yyyy-mm-dd") in the formula
- Turn on Wrap Text for the result cell
Ipakita ang sagot
Sagot: 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.
Tanong 12 ng 17
How does Excel store a date such as January 1, 1900?
- As the number of seconds since 1970
- As plain text, like a label
- As a serial number
- As three numbers: year, month and day
Ipakita ang sagot
Sagot: C. As a serial number
Excel stores dates as serial numbers so it can calculate with them. January 1, 1900 is serial number 1.
Tanong 13 ng 17
What date does =DATE(2026,14,1) return?
- 2027-02-01
- 2026-12-01
- 2026-02-01
- #NUM!
Ipakita ang sagot
Sagot: A. 2027-02-01
A month over 12 rolls into the next year. Month 14 of 2026 is February 2027.
Tanong 14 ng 17
March 2, 2026 is a Monday. What does =WEEKDAY(DATE(2026,3,2)) return?
- 7
- 2
- 0
- 1
Ipakita ang sagot
Sagot: 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.
Tanong 15 ng 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?
- 10
- 9
- 8
- 11
Ipakita ang sagot
Sagot: 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.
Tanong 16 ng 17
What does =EOMONTH(DATE(2026,2,10),0) return?
- 2026-02-10
- 2026-02-28
- 2026-03-31
- 2026-02-29
Ipakita ang sagot
Sagot: 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.
Tanong 17 ng 17
In the staff list below, what does =DATEDIF(C2,DATE(2026,3,2),"Y") return?
A B C D
1 Name ID Start date Email
2 Priya Nair CGY-0412 2019-06-15 priya.nair@example.com
3 Jo Tran EDM-0087 2023-11-06 jo.tran@example.com
4 Leo Martin RED-1150 2025-02-03 leo.martin@example.com
- 2452
- 7
- 80
- 6
Ipakita ang sagot
Sagot: 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.

	A	B	C	D
1	Name	ID	Start date	Email
2	Priya Nair	CGY-0412	2019-06-15	priya.nair@example.com
3	Jo Tran	EDM-0087	2023-11-06	jo.tran@example.com
4	Leo Martin	RED-1150	2025-02-03	leo.martin@example.com

	A
1	Site
2	Calgary
3
4	Red Deer
5	Lethbridge

Quiz sa paksa 4: Text and date functions

Mga kaugnay na pagsusulit