EXL24 CORE Microsoft Excel 2019 ______________________________________________________________________________ For individual use only—reproduction or duplication of this copyrighted material is prohibited. Copyright Goodheart-Willcox Co., Inc. 79. What value is displayed in cell A4? ___________________________________________________________________________________ ___________________________________________________________________________________ 80. Applying what you have learned, sort the days of the week from Z to A. This is called descending order. 81. What value is displayed in cell A4? ___________________________________________________________________________________ ___________________________________________________________________________________ Working with Various Views 82. Click the Freeze Panes button on the ribbon (View tabWindow group), and click Freeze First Column in the drop-down menu. 83. Use the scroll bar at the bottom of the screen to scroll to the right. Notice that the fi rst column is frozen in place and remains visible. Every column from B on can be scrolled out of view. 84. Select cell C14. 85. Click the Split button on the ribbon (View tabWindow group). The view is split into four panes at that location, as shown in Figure EXL3-6. Each pane can be zoomed and scrolled independent of the others. Note: if this does not work correctly the fi rst time, click the button two more times. 86. Click the Split button to return to a single pane. TIP Removing the split screen also unfreezes any rows or columns. 87. Click the Zoom button on the ribbon (View tabZoom group). 88. In the Zoom dialog box, click the 25% radio button, and click the OK button to change the zoom level. 89. Click the Custom Views button on the ribbon (View tabWorkbook Views group). The Custom Views dialog box is displayed, as shown in Figure EXL3-7. 90. Click the Add… button in the dialog box. The Add View dialog box is displayed. 91. In the Add View dialog box, click in the Name: text box, enter Tiny, and click the OK button. 92. Applying what you have learned, change the zoom level to 100%. 93. Applying what you have learned, display the Custom Views dialog box. 94. Select the custom view in the dialog box, and click the Show button. The view is immediately restored. 95. Set the zoom level to 100%. Inserting and Deleting Columns and Rows 96. Applying what you have learned, select column C. MOS Certification Skill Excel 1.4.3 Freeze Panes MOS Certification Skill Excel 1.4.4 Split Zoom Custom Views MOS Certification Skill Excel 1.4.4