The "Earthwork mode" determines how the new terrain will be changed. New terrain can be created by filling by new soil, excavation of existing soil, or by the combination of both modes.
The principle is clear from the following example - all three earthworks have the same plan view.
Earthwork mode "Excavate only"
Earthwork mode "Fill only"
Earthwork mode "Fill and excavate"