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

I NEED HELP!!!!!!!!!!! I NEED EXAMPLES OF ONE SOLUTION EQUATIONS ZERO SOLUTION EQUATIONS INFINITE SOLUTION EQUATIONS
I would like to know if I am solving correctly so far and what I do after this to continue solving.
what is the circumference of a bicycle tire of 28 inches
I don't understand the problem.
What part of the electromagnetic spectrum that is necessary for the sense of sight in humans?
A(n) __________ is money given to an individual or an organization for a specific purpose.
Find f(3) if f(x) = -4x^2+5x
HELP! Simon invests in a medical company. He buys the stock at $189.35 and sells it for $167.78. What is the percent of decrease? Round your answer to the ne
HELP!! What is the cost of 50 shares of stock priced at $15.87.
How would you write 1 - x^4 before you divide it by x - 1?