when cells or rows are inserted or deleted in an excel worksheet how are cell reference deletion?

Question

15-09-2019
Computers and Technology

contestada

when cells or rows are inserted or deleted in an excel worksheet how are cell reference deletion?

Respuesta :

Otras preguntas

A set of 125 golf scores are normally distributed with a mean of 76 and a standard deviation of 3. What is the probability that a score is no more than 79?

Will give brainliest to first right answer. Before a sale an items price was $28.00 then after being discounted the price was $14.60. What was the discount for

Which system of equations has infinitely many solutions? On a coordinate plane, 2 lines are parallel to each other. On a coordinate plane, 2 lines intersect at

8. The aim of French explorations in the Mississippi valley and the Hudson Bay region was to __________. a. wage war on the Amerindians b. locate new sources of

PLEASE HELP TIMED !! question 1- draw a lewis dot diagram of O on a piece of paper. how many total electrons did you draw? question 2- draw a lewis dot diagram

When the polynomial mx3 - 3x2 + nx + 2 is divided by x + 3, the remainder is -1. When it is divided by x - 2, the remainder is -4. What are the values of m and

Evaluate the expression for the given value. 3x(x−2), when x=7

indicate the pH value as pH < 7, pH = 7 or PH > 7 for each of the following substances.a. Lemon juice b. Water c. Aqueous solution of MgO d. Aqueous solut

the equation of line p is y= -7/8x + 3/2. line q is parallel to line p. what is the slope of line q?

If you were given the time to do that and what and where then where would you?

youaskianswer youaskianswer · Answer 1 · 2019-09-18T13:11:12+02:00

Answer:

Whenever a new row is inserted, based on the insertion point, the rest of the rows will move down and the reference will be changed accordingly.

Explanation:

Suppose there are 5 columns and ten rows in excel containing the value of student marks from column 2 to 4 in each subject and column 1 contains Student roll number.

There are totally 10 entries in the sheet (number of student = 10) and the column 6 is utilized to calculate total and there is a formula associated to each row to add marks.

When we want to enter another student data below the 5th student, we can insert and the whole row including the formula gets changed thus the reference of formula gets changed. Same is the case for deletion.