Auto update another cell upon data enter

Hello Experts,

This is my first post in this forum. I am stuck with one of a problem in excel. I have a sheet where some data has been added frequently. I have a column E in which I have to add the "Received Date". I have another column F for "Status" & column G for "Total" which is a formula field.

What I want that whenever I fill the date in column E, It will update Column F & G with data "Completed" & "Total" value respectively without copying it and pasting manually.

As I am new to excel function & logic..even handle VBA little bit, please help me out here accordingly.


I have also attached an sample file ......


Thanks in advance.

Santosh