Laura Has Been Entering Dates in Worksheets Using the Long

question 2

Multiple Choice

Laura has been entering dates in worksheets using the Long Date format. Her manager sends her an email asking her to change all the dates from the Long Date format to the Short Date format. Laura can make the changes by:

• A)holding the Alt key while clicking the cells with dates in them and clicking the Consolidate option in the Data tab.
• B)making a new worksheet, changing the format, and copying the cells to the original worksheet.
• C)using the Number Format box arrow in the Number group on the Home tab.
• D)re-entering all the dates manually using slashes to divide the numbers.

---

Definitions:

Orion Constellation

A prominent constellation located on the celestial equator, easily identifiable by its belt of three stars and often associated with mythology across various cultures.

Tigris And Euphrates

Twin rivers that flow through modern Iraq, forming a major river system that was the cradle of ancient Mesopotamian civilization.

Nebuchadnezzar II

An ancient Babylonian king who ruled c. 605–562 BC, famous for his conquests and the construction projects in Babylon, including the Hanging Gardens.

Ishtar Gate

The eighth gate of the inner city of Babylon, constructed in about 575 BC by order of King Nebuchadnezzar II, famed for its blue glazed tiles and representations of animals.