What Excel feature lets you lock rows and columns so they stay on screen while scrolling?
Show answer Hide answer
Answer: B. Freeze Panes
Explanation
The Freeze Panes feature in Excel locks specific rows and columns so they remain visible on screen while scrolling. This tool anchors header rows at the top of the worksheet so context is never lost during large data reviews. Selecting Freeze Panes correctly identifies the standard spreadsheet utility used for locking reference data in view. Spreadsheets frequently contain extensive data sets with hundreds of rows, making headers scroll out of sight easily. Excel allows users to freeze top rows, first columns, or custom selections based on active cell cursor placement. Frozen panes create a split screen effect where designated header areas remain static while the rest of the sheet scrolls.
Lock Cells is a spreadsheet protection setting that prevents unauthorized edits rather than freezing screen scroll positions. Hide Rows/Columns completely conceals specific data ranges from view, which differs from keeping headers visible during scrolling. Split Window divides the worksheet into separate independently scrolling panes rather than anchoring specific reference rows.
- Subject
- Computer Science
- Category
- Computer Science
- Topic
- —
- Difficulty
- medium
Related questions
Q1. Which corner of the Word application window houses the zoom controls?
Show answer Hide answer
Answer: D. lower-right
The zoom controls and magnification slider reside conveniently in the lower-right corner of the Word application window. Placing these interface controls near the bottom edge allows users to adjust document scaling witho...
Q2. What feature makes it possible to mail out identical letters to multiple recipients?
Show answer Hide answer
Answer: B. Tool bar
Toolbars provide quick access buttons to execute tasks such as generating identical letters for mailings. Customizable button bars streamline user workflows by placing frequently used document automation tools on screen....
Q3. Which tool pastes Clipboard contents as unformatted plain text in Ms Word?
Show answer Hide answer
Answer: A. Paste Special
The Paste Special command provides granular control to paste Clipboard contents as unformatted plain text into Word. This utility strips away all foreign font styles, colors, and embedded hyperlinks from the copied sourc...
Q4. Where can vertical alignment be adjusted in a Word document?
Show answer Hide answer
Answer: C. Page Setup dialog box
Vertical page alignment options are housed within the Page Setup dialog box in traditional Microsoft Word applications. This setting determines whether document text starts at the top margin or centers vertically down th...
Q5. What file formats can be successfully incorporated into a PowerPoint presentation?
Show answer Hide answer
Answer: D. All of the above
PowerPoint supports embedding various multimedia and image file formats, including JPEG, GIF, and WAV files. Integrating diverse media types enhances audience engagement during professional slide deck presentations. Pres...
Q6. Which executable file launches MS PowerPoint?
Show answer Hide answer
Answer: B. Powerpnt.exe
The executable file named Powerpnt.exe is responsible for launching Microsoft PowerPoint on Windows operating systems. System shells and shortcut links point directly to this binary file to initialize the presentation ap...