When you move in same row but other columns?

A ) To add up a range of cell

B ) To find the average of range of cell

C ) To perform a vertical lookup and returns a value based on specified criteria

D ) To perform a horizontal lookup and returns a value based on a specific criteria ✅