Exam 77-428 Microsoft Excel 2013 EXPERT
2. Apply Custom Formats and Layouts
2.1 Apply Custom Data Format: Use Advanced Fill Series Options

AutoFill Options

AutoFill Options

What Else Do You See? Look by the AutoFill handle in Cell A24. There is a little option box that you can click. The AutoFill Options are:

Copy Cells

Fill Series

Fill Formatting Only

Fill Without Formatting

Fill Days

Fill Weekdays

Fill Months

Fill Years
Flash Fill

 

The Day, Month and Year formatting displays only that portion of the date that you entered in the Cells. You can choose to Fill the Cells with or without the Cell Formatting, too.

 

Fill Weekdays looks up the dates in your Series and enters only the days from Monday to Friday. No weekends-sweet.

6. Try This, Now: Fill the Weekdays
Click on the AutoFill Options.
Select: Fill Weekdays.
Keep going...

graphic2
graphic1
no