AIN2601 - MS Excel Revision
questions \test review with
correct answers a+ rated
Explain the following Excel error:
#DIV/0! - Answer division by cell = 0, or
division by empty cell
Explain the following Excel error:
#NAME? - Answer text in a formula not recognized
Explain the following Excel error:
#NULL! - Answer a space instead of a comma was used to
separate cell references used as arguments for functions
Explain the following Excel error:
#NUM! - Answer a problem with a number in the formula, or
wrong type of argument
Explain the following Excel error:
#REF! - Answer invalid cell reference in formula
Explain the following Excel error:
#VALUE! - Answer wrong type of argument in function;
wrong type of operator;
, mathematical operations with cells that contact text
Explain the following Excel error:
#N/A! - Answer value not available to function or formula
What are the risks that must be considered when using
spreadsheets? - Answer complexity: 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. - Answer accidental copy-
paste
omission of a negative sign
erroneous range selection
incorrect data input
unintentional deletion of a character, cell, range, column or row
sorting of only a portion of the data range
List the potential consequences of spreadsheet errors: - Answer
financial loss / bankruptcy
incorrect costing / budgeting
public embarrassment / adverse news coverage / loss of
reputation
loss of investor confidence
loss of share value
loss of financial control
questions \test review with
correct answers a+ rated
Explain the following Excel error:
#DIV/0! - Answer division by cell = 0, or
division by empty cell
Explain the following Excel error:
#NAME? - Answer text in a formula not recognized
Explain the following Excel error:
#NULL! - Answer a space instead of a comma was used to
separate cell references used as arguments for functions
Explain the following Excel error:
#NUM! - Answer a problem with a number in the formula, or
wrong type of argument
Explain the following Excel error:
#REF! - Answer invalid cell reference in formula
Explain the following Excel error:
#VALUE! - Answer wrong type of argument in function;
wrong type of operator;
, mathematical operations with cells that contact text
Explain the following Excel error:
#N/A! - Answer value not available to function or formula
What are the risks that must be considered when using
spreadsheets? - Answer complexity: 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. - Answer accidental copy-
paste
omission of a negative sign
erroneous range selection
incorrect data input
unintentional deletion of a character, cell, range, column or row
sorting of only a portion of the data range
List the potential consequences of spreadsheet errors: - Answer
financial loss / bankruptcy
incorrect costing / budgeting
public embarrassment / adverse news coverage / loss of
reputation
loss of investor confidence
loss of share value
loss of financial control
