Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
được xác định là tác giả của tác phẩm này đã được khẳng định phù hợp với Bản quyền, kiểu dáng và Bằng sáng chế của Đạo luậtMicrosoft Excel cung cấp hơn 300 chức năng bảng tính được chia thành 10 nhóm: toán học và lượng giác, kỹ thuật, hợp lý | 22 A Guide to Microsoft Excel 2002for Scientists and Engineers Exercise 3 Formatting the Results Our project is almost complete. All that remains is to change the way the results are displayed. For this project it is inappropriate to display so many digits after the decimal we need integer values. a Select range B4 B13 on the worksheet of the previous exercise. From the Format command on the menu select Cells. In the resulting dialog box select the Number tab - see Figure 2.5. The General format will be highlighted in the Category box. This is the default number format. In most cases an entry in a cell having the General format is displayed the same way as it was typed. When the cell is not wide enough to show the entire number the General format rounds numbers with decimals and uses scientific notation for very large and small numbers. b In the Category box click the Number tab. Change the value in the Decimal places box to 0. You may use the spinner or type the value in the box. Click the OK button to close the dialog box. Your worksheet now displays integer values. Figure 2.5 3. The Undo tool c There is another way to do this. Click the Undo button on the Standard toolbar to display the original values. d Select B4 B 15 and click once on the Increase Decimals button Basic Operations 23 .0 2221 The Increase Decimals tool if you try to use the Decrease Decimals tool Excel will make a ping sound to warn you this is impossible - B4 has an integer .00 -QI The Decrease Decimals tool value so it cannot be made to display any fewer decimal places. All the numbers now display one decimal place. Click the Decrease Decimals button once to display them all as integers. It is important to know that formatting changes only the way a value is displayed. It does not change the actual value stored in a cell. We look at this in Exercise 4. e Save the workbook CHAP2.XLS. Notes on Precision and Formatting Numbers are stored with 15-digit precision by Microsoft Excel. The number of
