kirieldecisions
kirieldecisions kirieldecisions
  • 01-03-2017
  • Computers and Technology
contestada

Which of the following options correctly represent a formula with Absolute References?
A.)=(A$1$-B$1$)
B.)=(A$1-B$1)
C.)=($A1-$B1)
D.)=($A$1-$B$1)

Respuesta :

nerdsrocks
nerdsrocks nerdsrocks
  • 07-03-2017
The answer is D =($A$1-$B$1) 

sources:just took the test
Answer Link
omotayoadekoya1 omotayoadekoya1
  • 09-03-2020

Answer:

D.)=($A$1-$B$1)

Explanation:

The $ sign placed in between the characters of a cell makes the cell an absolute reference in any formula that involves the cell.

For example, the function "=A1 - $B$2" would give a result equivalent to "=A1 - B2" however, a drag down of the formula would result in a change of the function A1 to A2, A3, A4, A5...

Hence from the options, =($A$1-$B$1) is the only formula with absolute references.

Answer Link

Otras preguntas

what balance does winthrop propose for the relationship between the individuals and the community?
How many tens are in 30 ones?
What are 2 numbers that have 2, 3, and 5 as factors
1. What facts about the Japanese American internment camps do you need to have in order to understand the event's importance to new citizens? 2. Why is this eve
2) metal bar has a length of 3.0cm a width of 3.0cm and a height of 2.0 cm what is the volume of the water in liters would the bar displace.
withdrawal symptoms from depressants can include ___________a. death.b. convulsionsc. both a and b
I have a DBA for keyboarding coming up and I am nervous. Any tips or pointers?
what is the number in scientific notation? ​0.000000000093
can you help review my essay
the cell membrane helos to control what enters and leaves a cell