Question

Explain 'ROUND' function of Excel.

Hint:

Data Formatting controls *appearance*, not value (mostly). Use Number formats (Rs, ), Alignment, Font, Colors, Borders accessed via Home tab / Format Cells. Excel's ROUND function changes the *value* to a specified number of digits (decimal places if positive, integer if 0, tens/hundreds if negative). Use `ROUNDUP` to always round up, `ROUNDDOWN` to always round down.

Answer 1

The 'ROUND' function in Excel rounds a number to a specified number of decimal places, making it easier to handle numerical data. The syntax for the ROUND function is: \[ \texttt{=ROUND(number, num\_digits)} \] \noindent where: - \texttt{number} is the number you want to round. - \texttt{num\_digits} is the number of digits to which you want to round the number. If \texttt{num\_digits} is greater than 0, the number is rounded to that many decimal places. If \texttt{num\_digits} is 0, the number is rounded to the nearest integer. If \texttt{num\_digits} is less than 0, the number is rounded to the left of the decimal point. \noindent \textbf{Example:} \texttt{=ROUND(12.567, 2)} will return 12.57. \texttt{=ROUND(12.567, 0)} will return 13.