Cgs 2518 Fsu Exam Questions And Correct Detailed Answers (Verified Answers) Already Graded A+

CGS 2518 FSU EXAM QUESTIONS AND CORRECT DETAILED
ANSWERS (VERIFIED ANSWERS) ALREADY GRADED A+
What is the meaning of this error message ###### Ans✓✓✓Insufficient
cell width


What is the meaning of this error message #NAME?
Ans✓✓✓Unrecognized text in formula


What is the meaning of this error message #N/A Ans✓✓✓No answer


What is the meaning of this error message #REF! Ans✓✓✓Invalid cell
reference


What is the meaning of this error message #VALUE! Ans✓✓✓Wrong
argument type


What is the meaning of this error message #NUM! Ans✓✓✓Invalid
numeric values in a formula or function


What is the meaning of this error message #DIV/0! Ans✓✓✓Division
by zero


The formula =1,100/25 is entered into a cell exactly as shown. Will
excel be able to calculate a result based on this formula? Ans✓✓✓No,

, the commas will cause excel to throw out the formula and it will be
shown in the cell as 1,100/25


If you enter =12-1*10 in a cell exactly as shown, what value would
result? Ans✓✓✓2 because of the order of operations


List the order of operations Ans✓✓✓PEMDAS
Parentheses
Exponential
Multiplication
Division
Addition
Subtraction


When you write a formula, why should you use cell references rather
than typing in values directly into the formula? Ans✓✓✓It allows the
user to easily update the worksheet without having to know exactly
which formula contains the changed value


In the worksheet below, cell A3 contains the formula =A1+A2. Explain
the most likely reason the value calculated appears to be incorrect.
Ans✓✓✓The values are rounded so we don't see the correct value