What is the purpose of the Freeze Panes feature in Excel?a.To hide rows or columns in a worksheetb.To lock specific cells so they cannot be editedc.To create a duplicate of a worksheetd.To keep certain rows or columns visible while scrolling through a large dataset

Which of the following options correctly describe the features of Freeze and Split view in Microsoft Excel?A. Freeze PanesB. Split PanesAnswer areaAllows you to divide the worksheet into multiple panes that can be scrolled independently.Can be applied to both rows and columns simultaneously.Requires you to select the row or column you want to freeze or split before applying the feature.Divides the worksheet into sections that remain stationary while the rest of the worksheet scrolls.Can only be applied to rows or columns individually, not both simultaneously.Helps keep specific rows or columns visible while scrolling through large datasets.

You freeze panes (ALT + WFF) from cell C2. Which statement below is correct?Column A, B, and Row 1 will be frozen.Column A, B, C, and Row 1 will be frozenColumn A, B, C, and Row 1, 2 will be frozenColumn A, B, and Row 1, 2 will be frozen

Match the FollowingProtect SheetsGroup WorksheetHide WorkbookFreeze PanesSave asSaves the current workbook with a new name or in a different file format.Keeps selected rows and/or columns visible while scrolling through a worksheet.Allows for multiple worksheets to be selected and managed as a group.Prevents users from making changes to specific elements of a worksheet, such as cells or formulas.Conceals a worksheet from view within the workbook.SubmitReset AnswerPreviousNext

What is the key benefit of freezing the top row?

You have frozen the top row (Row A) of the screen to make your spreadsheet easier to read. What cell will your cursor move to when you move to the top of the worksheet using the Control + Home shortcut?1 pointA2A3A16.