USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=MROUND(A1, 100)
|
|
|
=MROUND(A1, 10)
|
|
|
=ROUND(A1, 0)
|
|
|
=ROUND(A1, 1)
|
Detailed explanation-1: -To always round up (away from zero), use the ROUNDUP function. To always round down (toward zero), use the ROUNDDOWN function. To round a number to a specific multiple (for example, to round to the nearest 0.5), use the MROUND function.
Detailed explanation-2: -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-3: -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-4: -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.