Will you be put to sleep during elective surgery?

Yes, you will be awake . In fact the American Society of Anesthesiology definition of Conscious Sedation states:

Moderate Sedation/Analgesia (Conscious Sedation) a drug-induced depression of consciousness during which patients respond purposefully* to verbal commands, either alone or accompanied by light tactile stimulation. No interventions are required to maintain a patent airway, and spontaneous ventilation is adequate. Cardiovascular function is usually maintained.

The goal is to maintain that level of consciousness throughout the procedure, to reduce anxiety and noxious stimulation.

Hope this was helpful.

Randy