What is the purpose of the Freeze Panes feature in Excel?
a.
To lock specific cells so they cannot be edited
O b. To keep certain rows or columns visible while scrolling through a large dataset
O c.
To create a duplicate of a worksheet
Od. To hide rows or columns in a worksheet



Answer :

The purpose of the Freeze Panes feature in Excel is: - To keep certain rows or columns visible while scrolling through a large dataset. This feature allows you to lock specific rows or columns in place so that when you scroll through a large spreadsheet, those frozen rows or columns remain visible. It helps in keeping important information, such as headers, always visible while navigating through extensive data sets. By utilizing Freeze Panes, you can enhance the usability of your Excel spreadsheet by maintaining key information in view, making it easier to analyze and work with your data effectively.