Add table borders to specified cells only. On the Home tab, in the Paragraph group, click Show/Hide. Select the cells that you want, including their end-of-cell marks. Under Table Tools, click the Design tab. In the Table Styles group, click Borders, and then click the border that you want to add.
ROUND: â This function is used for rounding a number to a specified number of digits. For Example:Cell A1 is contains the number 456.25. To round the number, follow below given steps:-. Write the formula in cell B1.
Suppose we wanted to round off 838.274. Depending on which place value we're rounding to, the final result can vary. 1  Round to the nearest hundred (8 38.274) is 800. 2  Round to the nearest ten (8 3 8.274) is 840. 3  Round to the nearest one (83 8 .274) is 838. 4  Round to the nearest tenth (838. 5  Round to the nearest hundredth (838.2 7 4) is 838.27.