Microsoft Excel Tutorial: Working with Cell References

The video tutorial covers the concept of cell references in spreadsheets, including cell numbers, relative cell references, absolute cell references, and mixed cell references. It explains how relative references change when formulas are copied, while absolute references remain fixed. Mixed references combine both relative and absolute elements. Examples are provided to illustrate each type of reference, and viewers are encouraged to practice these concepts.

What is a cell number in a spreadsheet?

• A unique identifier for each worksheet

• The combination of a column name and a row number

• A formula used to calculate values

• The total number of cells in a worksheet

How does a relative cell reference behave when a formula is copied?

• It changes based on the new location

• It remains unchanged

• It becomes an absolute reference

• It deletes the original formula

What symbol is used to denote an absolute cell reference?

• Asterisk (*)

• Hash (#)

• Dollar sign ($)

• Ampersand (&)

In a mixed cell reference, which part is absolute?

• Both column and row

• Neither column nor row

• Either column or row

• Only the row

When calculating bonuses, which type of cell reference should be used for fixed rates?

• No cell reference

• Relative cell reference

• Absolute cell reference

• Mixed cell reference