DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
By placing a check mark in the Automatically insert a decimal point and number-2 options, it will ____
|
|
change 227 to 2.27
|
|
|
change 227 to 22700
|
|
|
change 227 to 0.00227
|
|
|
change 227 to 22.7
|
Explanation:
Detailed explanation-1: -Right click the selected cells, and select the Format Cells from the right-clicking menu. 3. In the coming Format Cells dialog box, go to the Number tab, click to highlight the Number in the Category box, and then type a number in the Decimal Places box.
Detailed explanation-2: -Rounding a decimal number to two decimal places is the same as rounding it to the hundredths place, which is the second place to the right of the decimal point. For example, 2.83620364 can be round to two decimal places as 2.84, and 0.7035 can be round to two decimal places as 0.70.
There is 1 question to complete.