Question

What action should be taken to configure the Vehicles worksheet so that rows 1 through 3 remain visible while scrolling vertically?

a) Use the "Freeze Panes" option
b) Apply a filter to show only rows 1 to 3
c) Insert blank rows below row 3
d) Lock rows 1 to 3

Answer 1

The action that should be taken is to use the "Freeze Panes" option.

Step-by-step explanation:

The action that should be taken to configure the Vehicles worksheet so that rows 1 through 3 remain visible while scrolling vertically is to use the "Freeze Panes" option.

By selecting rows 1 to 3 and choosing the "Freeze Panes" option, these rows will remain fixed at the top of the worksheet while the rest of the rows scroll vertically. This is useful when you have a large dataset and you want to keep certain header rows visible at all times.

Other options like applying a filter, inserting blank rows, or locking rows do not specifically address the requirement of keeping rows 1 to 3 visible while scrolling.