Which of the following would change the function =AVERAGE(C4:C18) to use absolute cell references:


  • =AVERAGE($C$4:$C$18)
  • =ABSOLUTE(AVERAGE(C4:C18))
  • =AVERAGE($C4:$C18)
Select the correct answer(s) and then click Submit.