Microsoft Excel 2021365 - Beginner to Advanced - Scroll Bar - Scroll Through a List

The video tutorial demonstrates how to scroll through a list of employee data using a scroll bar in Excel. It covers inserting and formatting the scroll bar, using the INDEX formula to return employee names and salaries, and troubleshooting common errors in cell referencing. The tutorial emphasizes the importance of correct cell referencing to ensure accurate data retrieval.

What is the primary purpose of using a scroll bar in the context of the video?

• To navigate through a list of employees and their salaries.

• To change the color of the cells.

• To sort the employee data alphabetically.

• To calculate the total salary of all employees.

Which tab in the ribbon is used to insert a scroll bar?

• View

• Insert

• Home

• Developer

What is the maximum value set for the scroll bar in the video?

• 5

• 10

• 15

• 20

What formula is used to return the employee names?

• INDEX

• MATCH

• VLOOKUP

• SUM

Why was the INDEX formula initially returning the same employee name repeatedly?

• The employee data was missing.

• The formula was not entered correctly.

• The cell references were not locked properly.

• The scroll bar was not functioning.

What adjustment is made to the cell reference to ensure flexibility in the INDEX formula?

• Changing the formula to VLOOKUP.

• Removing the lock from the first cell reference.

• Locking all cell references.

• Adding more rows to the data.

What issue is indicated by the green triangles in the cells?

• Data type mismatch.

• Scroll bar not linked properly.

• Incorrect formula syntax.

• Missing top value in the formula update.