Microsoft Excel 2021365 - Beginner to Advanced - Absolute Versus Relative Referencing

This video tutorial covers the differences between absolute and relative referencing in Excel. It begins with an introduction to these concepts, followed by a demonstration of relative referencing using a sum formula. The tutorial then explains absolute referencing, showing how to use the F4 key to lock cell references. Mixed referencing is briefly introduced, and the video concludes with final calculations using relative referencing.

What is the default type of referencing used by Excel?

• Absolute referencing

• Relative referencing

• Mixed referencing

• Circular referencing

How does Excel adjust cell references when using relative referencing?

• It deletes the references

• It changes the references to absolute

• It adjusts the references based on the position of the formula

• It keeps the references constant

Why might relative referencing not be suitable in all situations?

• It is too complex to use

• It does not adjust cell references

• It may not work correctly when copying formulas that need to refer to a fixed cell

• It requires manual adjustment of all cell references

What key is used to make a cell reference absolute in Excel?

• F4

• F2

• F3

• F1

What is the purpose of the dollar signs in an absolute reference?

• To convert the reference to a relative one

• To indicate a currency format

• To highlight the cell

• To lock the cell reference to a specific cell

What is mixed referencing in Excel?

• Referencing multiple sheets at once

• Using both absolute and relative references in the same formula

• Locking only the column or only the row

• Locking both the column and row

When is it appropriate to use relative referencing in Excel?

• When copying formulas that need to adjust cell references

• When using complex formulas

• When referencing multiple sheets

• When referencing a fixed cell