Microsoft Excel 2021365 - Beginner to Advanced - Recording a Macro with Relative Referencing

Microsoft Excel 2021365 - Beginner to Advanced - Recording a Macro with Relative Referencing

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

The video tutorial explains how to save Excel workbooks containing macros, emphasizing the need to save them as macro-enabled files to avoid losing functionality. It highlights the importance of understanding absolute and relative referencing in macros, demonstrating how relative referencing allows for more flexible macro execution. A practical example is provided, showing how to record and run a macro using relative referencing, enabling it to be applied in different parts of a workbook.

Read more

3 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the file extension for a macro-enabled workbook?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What happens if you try to run a macro recorded with absolute referencing in a different cell?

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

Describe the process of running a macro that has been recorded with relative references.

Evaluate responses using AI:

OFF