Excel Date Formatting

• Access the Date Format menu from the View tab
• Use the Replace function to change the date format
• Select the cell containing the date, click on the Format drop-down button, and choose Format Cells option (correct)
• Type the new format directly into the cell

• Change cell contents directly from the Formula Bar
• Replace cell contents or use Edit mode (correct)
• Copy and paste cell contents
• Delete and re-enter cell contents

• Category list on the Number tab in Format Cells dialog box (correct)
• In the Date Format submenu
• In the View menu on the Excel toolbar
• Under the Home tab in Excel settings

<p>The Cancel and Enter buttons become active on the left of the Formula Bar (C)</p> Signup and view all the answers

<p>Press either the Enter key or Enter button on the Formula Bar (D)</p> Signup and view all the answers