24. Consider the following excel formula: = C5 + $D$5. a O the reference for cell C5 is an absolute reference O the reference for cell D5 is a relative reference o the reference for cell C5 is an absolute reference and the reference for cell Ds is a relative reference both cell references are relative references this statement is invalid because you cannot have absolute and relative references in the same formula O none of the above