Which of the following statements is true of a user defined function?
A)It can be written when the function needed is already in Excel.
B)It can increase the complexity of a worksheet.
C)It can increase productivity.
D)It can be recorded in a macro recorder.

Question

Quizplus · Accepted Answer

If the function you need is not already in Excel,you can write your own user defined function (or UDF)using VBA.UDFs can reduce the complexity of a worksheet.UDFs can increase productivity when many users have to repeatedly use the same calculation procedures.

Which of the Following Statements Is True of a User