3 multiple choice 1 point what symbol must a person use to begin a formula? 4 multiple choice 1 point what…

3 multiple choice 1 point what symbol must a person use to begin a formula? 4 multiple choice 1 point what character is used to change a cell reference from relative to absolute? 5 multiple choice 1 point phil entered this cell reference $a5 into a formula. what part of the cell reference will remain unchanged? column a all cells in column a row 5 all cells in row 5

3 multiple choice 1 point what symbol must a person use to begin a formula? 4 multiple choice 1 point what character is used to change a cell reference from relative to absolute? 5 multiple choice 1 point phil entered this cell reference $a5 into a formula. what part of the cell reference will remain unchanged? column a all cells in column a row 5 all cells in row 5

Answer

Brief Explanations:

  1. In spreadsheet software like Excel, formulas must start with an equal sign (=) to be recognized as a calculation.
  2. The dollar - sign ($) is used to make a cell reference absolute in spreadsheet applications. For example, $A$1 is an absolute reference.
  3. In the cell reference $A5, the dollar - sign in front of the column letter (A) makes the column reference absolute. So the column A part of the reference will remain unchanged when the formula is copied or moved.

Answer:

  1. =
  2. $
  3. column A