You want to set up a range name left$3$ that always refers to the $3$ cells directly to the left of the active cell. The active cell is currently J$6$ of worksheet Exam$4$ of the file range name questions.xlsx$.$ In the New Name dialog box, we fill in the name Left$3$ and then in the Refers to portion of the dialog box we should enter

a$.$

$=$Exam$4!$G$$6$:I$$6.$

b$.$

$=$Exam$4!$G$6$:I$6.$

c$.$

$=$Exam$4!$G$5$:I$5.$

d$.$

$=$Exam$4!$J$3$:J$5.$