michaelponderjr2515 michaelponderjr2515
  • 03-02-2019
  • Computers and Technology
contestada

An excel which cell contains =B2 is copied to row below, the same column. What will be the new cell's content

Respuesta :

DizzyBerco
DizzyBerco DizzyBerco
  • 12-02-2019

The cell will get the value of =B3.

In MS Excel when a value with a formula that can be in a range of cells, the program will automatically get the next cells value. This is solely because of the coding of MS Excel which has an auto fill function coded into the program.

If the cell contains a value and not a formula, then the cell will get whatever value you have placed into the cell you copied from.

Answer Link

Otras preguntas

To prevent accidental poisoning, you should NOT __________. a. mix chemicals in well ventilated areas b. follow the instructions on the label c. keep materials
What is the tone of sonnet 130?
Why does odysseus continue to taunt the cyclops as he pulls away from the shore?what traits does he demonstrait through this behavior and what are the consequen
What is syntax? A. the use of rambling, private thoughts B. the arrangement of words in a sentence C. the point of view from which a story is narrated D. langua
A psychologist would say that she enjoys the game because it acts as a __________.
what is the volume of 5.8g of H2?
Mammals are adapted to live in the following environments: a. land b. air c. water d. all of the above
uzupełnij schemat odpowiednimi
What happened in JROTC 100 years ago? And what might happen 100 years from today?
Which of the following is not a result of air pollution? A. Smog B. Breathing problems C. Global warming D. Soil erosion