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

Which one of the base sequences are accurately paired? G with C G with A T with C C with T
Why has World War I been described as a "total war"?
What is a “quote bomb”?
One of the best reasons to write is to _______ what we think. Planning is the _______ stage of the writing process. Explain how each of the five types of prewri
How to differentiate y=x^n using the first principle. In this question, I cannot use the rule of differentiation. I have to do the old fashioned way. How do I d
Which river is east of the Andes Mountains
Can anyone help me with this ?????
[tex]A=\frac{1}{2}\pi w^2+2lw[/tex]Solve for L
A deciduous forest biome ___. A. has the same climate wherever it is located B. is located only in one continent C. has not been changed by human actions D. is
What is the equation -9/2 + 9/2 in its simplest form