$1.$ What function does Excel provide if you cannot remember the name of the specific formula you wish to use or the order it needs to complete?

A$.$The Insert drop$-$down list.

B$.$The Check for Issues function.

C$.$The Geomean function.

D$.$The Insert Function dialog box button.

$2.$ In which one of the following circumstances will the Choose function be the most appropriate to make use of in Excel?

A$.$You want a cell to return a result based on the first matched value on a provided sheet or the default value.

B$.$You want the text in a cell to change based on a range of provided index numbers you can select a number from.

C$.$You want a cell to return the value of another cell in a table or cell range by searching for specified information in the relevant table or cell range.

D$.$You want a cell to display the number of cells used in a specific range of cells.

$3.$ ABC $($Pty$)$ Ltd$.$ has decided to sell ordinary debentures to the public at an expected interest rate of $12\%$ per annum and is repayable within $15$ years. Identify the type of financial market under which such debentures will trade.

A$.$Money market.

B$.$Primary market.

C$.$Equity market.

D$.$Debt market.