4. What happens if the formula or a function is typed incorrectly? Give some common error messages displayed in Ms excel 2010 and their possible reasons.
5. Write the steps to find the GCD of any three numbers.
Please answer these questions
No wrong answer!!!
Answers
Answer:
The #NAME? error indicates that Excel does not recognize something. This could be a function name misspelled, a named range that doesn't exist, or a cell reference entered incorrectly. For example, in the screen below, the VLOOKUP function in F3 is misspelled "VLOKUP".
Answer:
4. One of the most typical mistakes you'll notice in Excel formulas is error. When a reference expires, it happens. This frequently occurs as a result of the removal of sheets, rows, or columns, or the copying of a formula containing relative reference to a different location where the references are no longer valid.
5. Find the numbers' greatest common digits (GCDs), then write down each number's prime factorization. Find the factors that each integer has in common, and then combine those factors together.
Explanation:
4. If Excel cannot interpret the name of the equation you are attempting to run or if it is unable to compute one or even more values provided in the formula itself, an error notice will show. Check the spelling of the formula to fix the issue, or use the Equation Creator to have Excel create the procedure for you.
In this instance, Excel is not looking for your name. When Excel can't read specific components of an equation you're going to run, the error #NAME? manifests itself in a cell.
It's rather simple to fix this problem. If your cell was blank, just add a value or alter the value of the cell to something other than 0.
5. The GCD of three or more numbers can be determined by continually taking the GCDs of pairs of numbers, but it also represents the products of the prime factors that are shared by all the numbers.
In order to determine the greatest common divisor for a pair of positive integers (a, b), follow the steps listed below:
- Step 1: List the factors of the positive number "a."
- Step 2: List the factors of the positive number "b"
- Step 3: enumerate the divisors of "a" and "b" that they share.
- Step 4: Now identify the divisor that is greater than both "a" and "b."
#SPJ3