FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
below is the correct formula for Round
A
=Round(range)
B
=Round(cells)
C
=Round(cells;digit)
D
=Round(number1;number2; ____ )
E
=Round(sheets)
Explanation: 

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: -If you wanted to use the number from cell A2 and have it rounded to two decimal places, you could enter =ROUND(A2, 2). Or, if you want to divide cell B2 by cell C2, and round the result to 3 decimals, you would use =ROUND(B2/C2, 3).

There is 1 question to complete.