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