Copyright Goodheart-Willcox Co., Inc. For individual use only—reproduction or duplication of this copyrighted material is prohibited. ___________________________________________________________________________ Lesson 3 Getting Acquainted EXL19 16. Examine the pattern of data automatically fi lled in for the new range. What is the pattern that was created? ___________________________________________________________________________________ ___________________________________________________________________________________ ___________________________________________________________________________________ 17. Select the range B4:B5. 18. Double-click the auto fi ll block. The cells down to cell B26 are automatically fi lled in with the pattern of data. This is possible because the column next to the selected range has cells containing data. If the column were empty, the auto fi ll block would need to be manually dragged down to complete the pattern of data. This function works vertically, but not horizontally. 19. What value is in cell B23? ___________________________________________________________________________________ 20. Select the range C4:C5. 21. Applying what you have learned, complete the pattern down to cell C26. 22. What is the value in cell C14? ___________________________________________________________________________________ 23. In which cell does the number 100 appear? ___________________________________________________________________________________ 24. What is the pattern of data in column C? ___________________________________________________________________________________ ___________________________________________________________________________________ 25. Select the range D4:D5. 26. Applying what you have learned, complete the pattern down to cell D26. 27. What is the last value shown in column D? ___________________________________________________________________________________ 28. Select the range B4:D4. 29. Applying what you have learned, complete the pattern in the row to cell H4. 30. What is the value in cell H4? ___________________________________________________________________________________ 31. Select the range B5:D5. 32. Applying what you have learned, complete the pattern in the row to cell H5. 33. What is the value in cell H5? ___________________________________________________________________________________ Setting the Data Type 34. Select the range B4:B26. 35. Click the drop-down arrow next to the Accounting Number Format button on the ribbon (Home tabNumber group), and click $ English (United States) in the drop-down menu. The data type is set to currency, and the values are displayed as dollars and cents. MOS Certification Skill Excel 2.2.5 Accounting Number Format