Question 4 (1 point) Which of the following regarding an absolute reference is NOT correct? It refers to the same cell, no matter where you copy it By default, a cell reference is an absolute reference To create an absolute reference, type dollar signs before the column letter and per (e.g., $B$6) row You can simply enter a cell address and press F4 once to get its absolute reference (e.g., $B$6). Alternatively, you can repeatedly press F4 to get the type of reference you need (e.g., $B$6, B$6, $B6, or B6).

uestion 4 ( 1 point) Which of the following regarding an absolute reference is NOT correct? It refers to the same cell, no matter where you copy it By default, a cell reference is an absolute reference To create an absolute reference, type dollar signs before the column letter and row number (e.g., \$B \$6) You can simply enter a cell address and press F4 once to get its absolute reference (e.g., \$B\$6). Alternatively, you can repeatedly press F4 to get the type of reference you need (e.g., \$B \$6, B \$6, \$B6, or B6)