Skip to content
GK24
Prime
Computer AwarenessEasy

The error value #DIV/0! appears in an MS Excel cell when which of the following happens?

  1. A.A function name has been spelt wrongly
  2. B.A number is divided by zero or by an empty cell
  3. C.The column is too narrow for the result
  4. D.A referenced cell has been deleted

Correct answer

B. A number is divided by zero or by an empty cell

Explanation

The correct answer is B, a number is divided by zero or by an empty cell. Division by zero has no answer in arithmetic, so Excel refuses to invent one and writes #DIV/0! instead. An empty cell used as the divisor counts as zero, which is why the error often appears in a template before any data has been typed; wrapping the formula in IFERROR or in an IF test hides it neatly.

Option A describes #NAME?, the error Excel writes when it cannot recognise a function name or a defined range name, for example if SUM is typed as SUMM. Option C describes the row of hash marks that fills a cell whose column is too narrow; that is only a display problem and not an error value, and widening the column restores the number. Option D describes #REF!, which appears when the row, column or sheet a formula pointed at has been deleted, so the reference no longer exists. Each error value names its own cause, and learning the four together is the whole of this topic.

Read the full article: MS Excel: Formulas, Functions and Shortcuts

Practice Questions

View all
Q4.Computer AwarenessAsked in: Haryana · HSSC Staff Nurse 2019 Official PaperEasy

Which out of the following is used as an electronic spread sheet?

  1. A.Microsoft Word
  2. B.Microsoft Power point
  3. C.Microsoft Excel
  4. D.Microsoft Access
Show answer
Correct answer: C. Microsoft Excel

An electronic spreadsheet stores data in a grid of rows and columns and recalculates its formulas whenever a value changes, and Excel is the spreadsheet program of the Microsoft Office suite.