61.5k views
4 votes
When you enter a two-digit year that is less than 30, Excel changes the year to _____. Question 7 options:

a. 20xx
b. 30xx
c. 18xx
d. 19xx

1 Answer

7 votes
The answer is a. 20xx

when you enter a 2 digit year that is less than 30, excel will assume that it's a 20th century and changes the year to 20xx. To change how excel interpret this, you should select 'assume the 21st century for 2 digit years before' check box
User Manu Varghese
by
7.9k points

Related questions

asked Sep 8, 2021 115k views
Aerik asked Sep 8, 2021
by Aerik
8.6k points
1 answer
5 votes
115k views
asked May 12, 2021 16.0k views
Grafix asked May 12, 2021
by Grafix
8.4k points
1 answer
2 votes
16.0k views