Which of the following commands should you use to lock rows or columns in view so you can position data for easy review? 1. Status bar view buttons 2. Merge & Center command 3. Zoom options 4. Freeze Panes command

Which of the following allows you to enter, modify, delete, or view data records? 1. Design view 2. Ctrl+N 3. Datasheet view 4. External data

Which of the following options correctly describe the features of different views in Microsoft Excel?A. Normal ViewB. Page Break PreviewC. Page Layout ViewAnswer areaAllows you to adjust margins, headers, and footers directly on the worksheet.Allows you to rearrange and resize page elements such as charts, images, and text boxes.Shows a continuous layout of the worksheet, similar to how it would appear in a printed document.Provides a simplified view of the worksheet without page margins, headers, or footers.Enables you to insert, delete, or adjust page breaks to control the layout of printed pages.Displays the worksheet as it will appear when printed, with the addition of dashed lines indicating page breaks.

After creating a view, you realize that several columns were left out. Which of the following statements would you issue in order to add some columns to your view?

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.

n Workbook views, which of the following is used to switch workbook views? 1. Status bar 2. Menu bar 3. Ribbon 4. Shortcut menu