Excel Formulas and Data Analysis Course: Text and date functions

Prueba temática sin límite de tiempo: 17 preguntas sobre Text and date functions, con una explicación después de cada respuesta. Las preguntas y respuestas se mezclan cada vez.

Curso
Canadá
96 preguntas
Revisado el 13 de octubre de 2026
Verificado el 13 de octubre de 2026

Empieza por las leccionesExcel Formulas and Data Analysis Course: Lessons: unos 240 minutos de lectura. Todas las preguntas del test se tratan en las lecciones.

Prueba temática 4: Text and date functions

Pregunta 1 de 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
Ver respuesta
Respuesta: B. CGY
LEFT returns characters from the start of the text. The first 3 characters of CGY-0412 are CGY.
Pregunta 2 de 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
Ver respuesta
Respuesta: B. 0087
RIGHT returns the last 4 characters as text, so the leading zeros stay: 0087.
Pregunta 3 de 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
Ver respuesta
Respuesta: A. 11
MID starts at character 5 and takes 2 characters. In RED-1150, characters 5 and 6 are 1 and 1.
Pregunta 4 de 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
Ver respuesta
Respuesta: C. 7
LEN counts every character, and spaces count. "Jo Tran" has 6 letters and 1 space.
Pregunta 5 de 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
Ver respuesta
Respuesta: A. Leo Martin
TRIM removes spaces at the start and end and leaves single spaces between words.
Pregunta 6 de 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
Ver respuesta
Respuesta: 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.
Pregunta 7 de 17
What does =CONCAT("Priya","Nair") return?
- Priya&Nair
- Priya Nair
- PriyaNair
- Priya,Nair
Ver respuesta
Respuesta: 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.
Pregunta 8 de 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
Ver respuesta
Respuesta: B. Calgary, Red Deer, Lethbridge
TEXTJOIN puts the delimiter ", " between items. With ignore_empty set to TRUE, the empty cell is skipped.
Pregunta 9 de 17
What does =SEARCH("lock","Smart Lock") return?
- 7
- 6
- #VALUE!
- 1
Ver respuesta
Respuesta: A. 7
SEARCH is not case sensitive, so "lock" matches "Lock", which starts at the 7th character (the space is character 6).
Pregunta 10 de 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
Ver respuesta
Respuesta: D. FIND
SEARCH ignores case. Microsoft says to use FIND when you need a case-sensitive search.
Pregunta 11 de 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
Ver respuesta
Respuesta: 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.
Pregunta 12 de 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
Ver respuesta
Respuesta: C. As a serial number
Excel stores dates as serial numbers so it can calculate with them. January 1, 1900 is serial number 1.
Pregunta 13 de 17
What date does =DATE(2026,14,1) return?
- 2027-02-01
- 2026-12-01
- 2026-02-01
- #NUM!
Ver respuesta
Respuesta: A. 2027-02-01
A month over 12 rolls into the next year. Month 14 of 2026 is February 2027.
Pregunta 14 de 17
March 2, 2026 is a Monday. What does =WEEKDAY(DATE(2026,3,2)) return?
- 7
- 2
- 0
- 1
Ver respuesta
Respuesta: 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.
Pregunta 15 de 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
Ver respuesta
Respuesta: 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.
Pregunta 16 de 17
What does =EOMONTH(DATE(2026,2,10),0) return?
- 2026-02-10
- 2026-02-28
- 2026-03-31
- 2026-02-29
Ver respuesta
Respuesta: 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.
Pregunta 17 de 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
Ver respuesta
Respuesta: 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

Prueba temática 4: Text and date functions

Exámenes relacionados