Excel Errors

Question 1

VALUE!

Answer 1

The formula/function mentions cells with data types that can’t be used for calculation.

Make sure all values and cell references used in the calculation can be used together in a calculation.

Question 2

DIV/0!

Answer 2

Division by zero. This occurs when division by zero or by any empty cell is attempted

Change the divisor to another number, or key in a number if the cell is empty

Question 3

NAME?

Answer 3

An invalid name Function is used.

Verify the function name’s spelling, use double quotation marks for necessary text, and include a colon when referencing a range.

Question 4

REF!

Answer 4

A cell reference in a formula/function is no longer valid

Use undo command if the message appears

Question 5

NUM!

Answer 5

The formula/function uses an invalid number.

Make sure numbers are valid and that the calculation result is not too big or too small.

Question 6

What is as spreadsheet

Answer 6

A spreadsheet is an application designed for the manipulation of numbers

Question 7

What is a word processor

Answer 7

A computer program designed to create documents that contain mainly text