You developed a sales quotation workbook that you will share with your sales staff to help them quote prices. It shows #DIV/0 in some cells where there are empty quantities in a column. Which function would handle the error and replace it with another value

A) ERRORHANDLER
B) IFERROR
C) ERRORTRACK
D) ERRRORRETURN


B

Computer Science & Information Technology

You might also like to view...

Using _____, an analyst starts with an overall view, which is a context diagram with a single process symbol, and then creates diagram 0, which shows more detail.

A. balancing B. indexing C. exploding D. leveling

Computer Science & Information Technology

In Slide Show view, pressing the [E] key erases the annotation drawing.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

Which of the following does not complete the sentence correctly? An interface .

a. forces classes that implement it to declare all the abstract interface methods. b. can be used in place of an abstract class when there is no default implementation to inherit. c. is declared in a file by itself and is saved in a file with the same name as the interface followed by the .java extension. d. can be instantiated.

Computer Science & Information Technology

Rows in a Word table are numbered 1, 2, 3, and so on

Indicate whether the statement is true or false

Computer Science & Information Technology