FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Question: Assuming cell A1 is displaying the number “12000.7789". What formula should be used to round this number to the closest integer? =MROUND(A1, 100) =ROUND(A1, 0) =MROUND(A1, 10) =ROUND(A1, 1)

Detailed explanation-2: -Round a number up by using the ROUNDUP function. It works just the same as ROUND, except that it always rounds a number up. For example, if you want to round 3.2 up to zero decimal places: =ROUNDUP(3.2, 0) which equals 4.

Detailed explanation-3: -To round a number down to nearest 0.5, use the FLOOR function, for example =FLOOR(A2, 0.5) . To round a number up to nearest 0.5, use the CEILING function, for example =CEILING(A2, 0.5) . To round a number up or down to nearest 0.5, use the MROUND function, e.g. =MROUND(A2, 0.5) .

Detailed explanation-4: -To do this, you’ll simply need to begin the cell reference with the worksheet name followed by an exclamation point (!). For example, if you wanted to reference cell A1 on Sheet1, its cell reference would be Sheet1!A1.

Detailed explanation-5: -In Excel, there’s a function called ROUND that you can use to round a number to the nearest 1000. Here I have the number “123456789”, and I want to round this number.