intermediateSSCWhich option correctly describes Absolute reference?AIt rearranges rows according to values in one or more columns.BIt remains fixed when copied and is written with dollar signs, such as $A$1.CIt is an Excel file that can contain one or more worksheets.DIt is an expression, normally beginning with an equals sign, that calculates a result.Submit AnswerReport Question
