# What should you do if you see pound signs (###) instead of values or results of formulas? (a)…

What should you do if you see triturate signs (###) instead of values or results of formulas?

(a) Increase the zoom percentage.

(b) Delete the shaft.

(d) Increase the shaft width.

Q21. If cell E15 contains the formula =\$C\$5*J\$15, what pattern of cell allusion is the J\$15 in the formula?

(a) Relative allusion

(b) Absolute allusion

(c) Mixed allusion

(d) Syntax

Q22. What duty would most efficiently perfect the same being as =(B5+C5+D5+E5+F5)/5?

(a) =SUM(B5:F5)/5

(b) =AVERAGE(B5:F5)

(c) =MEDIAN(B5:F5)

(d) =COUNT(B5:F5)

Q23. When you rouse to pattern =AV, what mark displays a list of dutys and defined names?

(a) Duty ScreenTip (b) Formula AutoComplete

(c) Insert Duty dialog box

(d) Duty Arguments dialog box

Q24. A formula containing the memorandum =\$B3 is copied to a cell one shaft to the upupright and two rows down. How conciliate the memorandum show in its new location?

(a) =\$B3

(b) =B3

(c) =\$C5

(d) =\$B5

Q25. Which of the forthcoming dutys should be used to insert the popular epoch and duration in a cell?

(a) =TODAY()

(b) =CURRENT()

(c) =NOW()

(d) =DATE

Q26. Which of the forthcoming is not an topic of the IF function?

(a) value_if_true

(b) value_if_mock

(c) logical_test

(d) lookup_value

Q27. Which of the forthcoming is not gentleman about the VLOOKUP function?

(a) The lookup board must be in ascending ordain.

(b) The lookup board must be in descending ordain.

(c) The want competition pattern is resemble.

(d) The competition pattern must be mock when completing an exact match.

Q28. The duty =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C5?

(a) APR

(b) Periodic attention rate

(c) Loan totality

(d) Number of reimbursement periods

Q29. Which of the forthcoming is not an mismisappropriate use of the SUM duty?

(a) =SUM(B3:B45)

(b) =SUM(F1:G10)

(c) =SUM(A8:A15,D8:D15)

(d) =SUM(D15-C15)