D388 Excel Western Governors University
A cell reference that stays fixed when a formula is copied from one cell to another is an
___________
Formatting Changing the appearance of the data ana cells in a worksheet
Choose an answer
1
A cell reference that changes when a
formula is copied is a relative reference.
2
A cell reference that stays fixed when a
formula is copied from one cell to another
is an absolute reference.
3
A cell reference that adjusts based on
column is a mixed reference.
4
A cell reference that varies with the
spreadsheet is a dynamic reference.