Copyright Goodheart-Willcox Co., Inc. For individual use only—reproduction or duplication of this copyrighted material is prohibited. ___________________________________________________________________________ Lesson 3 Getting Acquainted EXL21 45. What is the value displayed in cell D26? Speculate what this means. ___________________________________________________________________________________ ___________________________________________________________________________________ ___________________________________________________________________________________ 46. Select the range E4:H5. 47. Click the Decrease Decimal button on the ribbon (Home tabNumber group). The values have one decimal place removed. Continue clicking the button until all decimal places are removed. 48. What value is displayed in cell G5? ___________________________________________________________________________________ 49. Applying what you have learned, select column A. 50. Click the Font Size drop-down arrow on the ribbon (Home tabFont group), and click 14 in the drop-down menu. All cells in column A are formatted with a font size of 14 points. 51. Move the cursor between the column A and column B headings. The cursor changes to a vertical bar with opposing arrows, as shown in Figure EXL3-3. This indicates the column width of the left-hand column can be changed. 52. Click, hold, and drag to the right until column A is as wide as the word Wednesday. Adding Borders to Cells and Merging Cells 53. Select columns A through D by clicking the column A header, holding, and dragging to the column D header. 54. Click the drop-down arrow next to the Bottom Border button on the ribbon (Home tabFont group), and click All Borders in the drop-down menu. A thin black border is placed around each cell. Note that the button changes from Bottom Border to All Borders. 55. Select the range A1:H1. Decrease Decimal Bottom Border Click and drag to change the column width Figure EXL3-3. The column width can be changed by dragging the column border.