nerdexam
Microsoft

77-420 · Question #17

Modify the cell format to date. Cell range C2:S2

Type: 14-Mar Locale (location): English (United States) Answer: Step 1: Open the correct worksheet(Section 3 Worksheet). Step 2: Click in cell A2. Step 3: Press down the Shift key and click in cell S2. Step 4: On the Home tab, under Format, choose Format Cells. Step 5: In the…

Manage Data Cells and Ranges

Question

Modify the cell format to date. Cell range C2:S2

Explanation

Type: 14-Mar Locale (location): English (United States) Answer: Step 1: Open the correct worksheet(Section 3 Worksheet). Step 2: Click in cell A2. Step 3: Press down the Shift key and click in cell S2. Step 4: On the Home tab, under Format, choose Format Cells. Step 5: In the Format Cells dialog box, choose Date, 14-Mar, and Locale (location): English (United States). Click OK.

Topics

#cell format#date format#cell range

Community Discussion

No community discussion yet for this question.

Full 77-420 Practice