AIN2601 - MS Excel

AIN2601 - MS Excel


\

Explain the following Excel error:
#DIV/0! - question and answerdivision by cell = 0, or
division by empty cell

Explain the following Excel error:
#NAME? - question and answertext in a formula not recognised

Explain the following Excel error:
#NULL! - question and answera space instead of a comma was used to separate cell
references used as arguments for functions

Explain the following Excel error:
#NUM! - question and answera problem with a number in the formula, or
wrong type of argument

Explain the following Excel error:
#REF! - question and answerinvalid cell reference in formula

Explain the following Excel error:
#VALUE! - question and answerwrong type of argument in function;
wrong type of operator;
mathematical operations with cells that contact text

Explain the following Excel error:
#N/A! - question and answervalue not available to function or formula

What are the risks that must be considered when using spreadsheets? - question and
answercomplexity: the more complex, the higher the risk
frequency of use and updating: higher frequence = higher risk
number of users using a spreadsheet: more users = higher risk
time in use: the longer in use, the higher the risk

List the typical spreadsheet errors. - question and answeraccidental copy-paste
omission of a negative sign
erroneous range selection
incorrect data input
unintentional deletion of a character, cell, range, column or row