TECHNOLOGY PLUG-IN T3. Problem Solving Using Excel. LEARNING OUTCOMES. Describe how to create and sort a list using Excel Explain why you would use conditional formatting using Excel Describe the use of AutoFilter using Excel Explain how to use the Subtotal command using Excel
Problem Solving Using Excel
To keep an area of a worksheet visible while you scroll to another area of the worksheet, you can lock specific rows or columns in one area by freezing or splitting panes (pane: A portion of the document window bounded by and separated from other portions by vertical or horizontal bars.).