Question: 1. Identify the inaccurate statement regarding date serial numbers. A. The serial number for January 1, 1900, is 1 and increases by one for
1. Identify the inaccurate statement regarding date serial numbers. A. The serial number for January 1, 1900, is 1 and increases by one for each date after. B. Versions of Excel created after 2000 restart the numbering with 1 on January 1 to make calculations easier. C. To find the difference between two dates, subtract the lower date from the higher date. D. Using serial numbers for dates is useful for calculations, such as determining the number of days between two dates. 2. What date takes serial number 1? A. January 1, 1950 B. January 1, 1985 C. January 1, 2000 D. January 1, 1900 3. Match each date to its serial number. (Hint: April 1, 2019, takes serial number 43556.) DATES A. April 11, 2019 B. April 6, 2019 SERIAL NUMBERS 1. 43565 2. 43566 C. April 10, 2019 3. 43555 D. March 31, 2019 4. 43561
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
