4 is an example of a __________ reference.
- AFixed
- BMixed
- CRelative
- DAbsolute
Solution & Step-by-step Explanation
In spreadsheet software (like MS Excel or Google Sheets):Relative reference (C4): Changes both column and row when copied.Absolute reference ( 4): Keeps both column and row locked.Mixed reference ( 4): Locks either the column or the row while leaving the other free to change.Since only one coordinate uses the absolute dollar sign symbol (\ $
), it is a Mixed Reference.
), it is a Mixed Reference.