Harry, a bank employee, is using Excel to carry out loan payment calculations. He wishes to change the column containing interest rates to an absolute reference. Which of the following keys should Harry use to change the reference to an absolute reference for a selected cell or range??

A. ?Alt+R
B. ?F4
C. ?Shift+PgDn
D. ?F1

Answer: B

Computer Science & Information Technology

You might also like to view...

When you violate a validation rule, Access allows you to continue entering the record

Indicate whether the statement is true or false

Computer Science & Information Technology

Write the statement to create a layout manager named myLayout that centers components in each row.

What will be an ideal response?

Computer Science & Information Technology