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

if log 55 = 1.74 , what is the value of log1000 55 ?
what northern cities saw the largest influx of african americans in the early 20th century
What is we wake up in spanish
Find an equation for the line with the given properties. Perpendicular to the line y = -3x - 2; containing the point (-2, 3)
What is the value of x? Enter your answer in the box.
Who was the first president to speak at a national ffa convention
Simplify using the order of operations. (2 + 1)3 = 32
Write the slope-intercept form of the equation of the line passing through the point (-2,6) and parallel to the line y=4x+5.
How many Children attended the classroom if there were 11 girls who made up 44% of the children?
What made The Declaration of Independence such a radical document?