jlgardner1028 jlgardner1028

05-01-2019
Computers and Technology

contestada

2. When you use the fill handle to copy a formula to adjacent cells, this creates what kind of cell reference?

Respuesta :

dthomasspates dthomasspates

05-01-2019

One can quickly copy a formula into adjacent cells by using fill handle option. When one fills the formula down, relative reference are used to ensure that the formula adjust for each row, unless one include the the absolute or mixed reference before one fills down the formula.

Answer Link

04-03-2020

Answer:

Relative Reference

Explanation:

Cell references are considered to be relative references when cells is copied across multiple cells, causing them to change based on the relative position of rows and columns.

For example, if you copy the formula =F1+G1 from row 1 to row 2, the formula will become =F2+G2.

Another example, if you copy the formula =F4*G4 from cell H4 to H5, the formula in H5 adjusts to the right by one column and becomes =F5*G5.

Relative references are often easier to adopt or use whenever you need to repeat the same calculation across multiple rows or columns.

Answer Link

Otras preguntas

You need to reformat your computer. After backing your data up and preparing the hard drive you need install the first software program call an operating system

Which of the following is NOT an element of nationalism? A. a common history and culture B. a strong sense of patriotism C. a common language D. an openness to

Which statement best summarizes how Reagan’s economic policies affected the US economy? There was a decline in unemployment, but people made less money and paid

Do bigger organisms have bigger cells? what kind of test would you do to answer this question?

The Black Death contributed to the growth of the arts by -decimating the population, leaving the survivors wealthier - giving artists a universal subject to dep

What is the Ring of Fire? A. an area of Indonesia where the land is extremely fertile B. the name of the tropical rainforests found on Borneo C. an ancient Mala

Beethoven cannot be truly considered a Romantic composer because he was unwilling to break the old rules of composition. A. True B. False

If da is a diameter of point z and m

Unlike conflicts in Egypt and Syria, the conflict in the Byzantine territory of Anatolia was quickly settled. resulted in many deaths. went on for centuries. re

i have answer need 2nd opinion Which phrase correctly describes John Locke's concept of natural rights, which inspired Thomas Jefferson when he wrote the Declar

Q&A Education