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

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

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

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.

Read more

3 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What issue arises when dragging the formula down initially?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

How can you adjust the cell referencing to make it more flexible?

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

What final adjustment is needed to ensure the scroll bar works perfectly?

Evaluate responses using AI:

OFF