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...

What is an identifier?

What will be an ideal response?

Computer Science & Information Technology

Built-in arrays, bitsets and valarrays are all ____________ containers.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

What is the difference between using a break in a for loop and using a continue in a for loop?

What will be an ideal response?

Computer Science & Information Technology

Using ________ enables the user to select a group of individual slides

A) [Ctrl] B) [Alt] C) [Ctrl]+[Shift] D) [Shift]

Computer Science & Information Technology