Arithmetic operators (+, -, *, /, etc.) are specifically designed to perform mathematical calculations like addition, subtraction, multiplication, and division. Comparison operators compare values, concatenation operators join text, and reference operators work with cell ranges in spreadsheets.