EXL20 CORE Microsoft Excel 2019 ______________________________________________________________________________ For individual use only—reproduction or duplication of this copyrighted material is prohibited. Copyright Goodheart-Willcox Co., Inc. TIP The drop-down list at the top of the Number group on the Home tab of the ribbon can also be used to set the data type. 36. What is the value displayed in cell B15? ___________________________________________________________________________________ 37. Select the range C4:C26. 38. Click the Percent Style button on the ribbon (Home tabNumber group). The data type is set to percentage, and the values are displayed as percentages by multiplying by 100. 39. What is the value in cell C24? ___________________________________________________________________________________ 40. Select the range D4:D26. 41. Click the Increase Decimal button on the ribbon (Home tabNumber group). The values have fi ve decimal places added. Click the button once more to increase the number of decimal places to six. 42. What are the values displayed in cells D21 and D26? ___________________________________________________________________________________ ___________________________________________________________________________________ Setting Column Width 43. Right-click on the column heading for column D, and click Column Width… in the shortcut menu, as shown in Figure EXL3-2. 44. In the Column Width dialog box that is displayed, click in the Column width: text box, enter 8, and click the OK button to change the width of all cells in the column. Percent Style Increase Decimal MOS Certification Skill Excel 1.3.2 Select to change the column width Right-click Figure EXL3-2. Setting the column width.