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 2 numbers that are the same multiply to be 36 and add up to be 15?
What were the names of the two major campaigns fought in Georgia during the Civil War?
0.2(x+50)-6=0.4(3x+20)
for ratios what would 45 out of 60 be as a fraction?
How do you do this solve 5/2y=10 for y explain
Fred completed 10 math problems this is 40% of the math problems he must do how many are left??
what is the value of the 8 in 3.872 and the value of the 4 in 0.194
What temperature is 23 degrees above freezing in fahrenheit
You create 15 centerpieces for a party in 5 hours. a) what is the unit rate? b) how long will it take you to make 42 centerpieces? Help Please :)
Take a look at the statement below: Fish meal is better than artificial fertilizers. How could this statement be revised to make it a hypothesis?