Case 13-1
Matt, a financial consultant, is auditing a friend's document.
Matt wants to calculate the amount of loan payments his friend needs to make on certain loans. He enters the data regarding interest and total principal in the worksheet. Which of the following functions should Matt use to calculate this?

A. ?SUM
B. ?PMT
C. ?CONVERT
D. ?AVERAGE


Answer: B

Computer Science & Information Technology

You might also like to view...

Analyze the following program.

``` public class Test { public static void main(String[] args) { try { String s = "5.6"; Integer.parseInt(s); // Cause a NumberFormatException int i = 0; int y = 2 / i; System.out.println("Welcome to Java"); } catch (Exception ex) { System.out.println(ex); } } }``` a. An exception is raised due to Integer.parseInt(s); b. An exception is raised due to 2 / i; c. The program has a compile error. d. The program compiles and runs without exceptions.

Computer Science & Information Technology

To help keep your table accessible, include only the ______ attribute in the start

tag.

A. auto B. name C. title D. caption

Computer Science & Information Technology

What is an authentication server, and how does Active Directory satisfy this role?

What will be an ideal response?

Computer Science & Information Technology

Match each view to its definition:

I. Report II. Layout III. Form IV. Design V. Print Preview A. Primarily used for data entry B. Allows advanced features to be applied C. Displays a report onscreen in a continuous page layout D. Used to view a report prior to printing E. Allows form or report design to be altered while still viewing the data

Computer Science & Information Technology