slimguera1
slimguera1 slimguera1
  • 25-03-2019
  • Computers and Technology
contestada

What mistake do you think you might make related to changing the data in a cell that's used in a formula?

Respuesta :

lucic
lucic lucic
  • 26-03-2019

Answer

Hi,

The mistake could be the #DIV/0! error , or a #REF! error

Explanation

When changing the data in a cell that’s used in a formula, a #DIV/0! Error can occur when the formula attempts to divide a number by 0 or an empty cell. To rectify this, you will need to change the value of that cell to a value not equal to 0. In some cases, the #REF! error could be displayed. This means that the formula refers to a cell that is not valid.

Hope this Helps!

Answer Link

Otras preguntas

Consider the following scenario below and recommend a solution. Situation: Tuan uploaded a photograph onto his website that he saved as “profilepic.doc”, but it
What is your estimate for the total number of hairs on your head?
Voter turnout in the most recent presidential elections has
A 0.50-kg toy is attached to the end of a 1.0-m very light string. The toy is whirled in a horizontal circular path on a frictionless tabletop. If the maximum t
how long will it take a car to go from a complete stop to 44km/h if they are accelerating at 5km/h
Find P(Red King | Card with a letter) a) 1/16 b) 1/8 c) 1/6 d) 1/3
What part of cellular respiration is affected by shikonin
How to solve 4x-13=2x+9
At which stage would centromeres of sister chromatids Disjoin and chromatids separate?
According to a Gallup poll in October 2015, having young children at home greatly influences whether women in the U.S. prefer to stay at home or work outside of