Available Answers

1. 1.

   Fill in the blanks.

   1. When a loop is enclosed within another loop, then it is said to be _______________ loops.
   2. _______________ statement returns to the original call code line.
   3. The _______________ function returns a string consisting of a number of space characters.
   4. A _______________ key consists of one or more fields that uniquely identify each record.
   5. To create a chart in Excel, you start by entering the numeric data for the chart on a _______________.
2. 2.

   Write True or False.

   1. If a loop has no exit condition, it will never stop.
   2. Each case can handle single line of code.
   3. DIM NAME AS STRING is another way of declaring string variable.
   4. One can set some filed properties in Datasheet view or Design View.
   5. Charts can be made using 2D and 3D graphics.
3. 3.

   Multiple Choice Questions (MCQs).

   1. A _________________ variable stores partial results of repeated additions of it.
      1. counter
      2. accumulator
      3. integers
   2. GOSUB procedures use _________________ numbers.
      1. serial
      2. random
      3. line
   3. The _________________ function returns ASCII code number of a certain string or text character.
      1. ASCII
      2. ASC
      3. ASCIICODE
   4. Fields that are the part of a table relationship are called _________________.
      1. keys
      2. area
      3. table
   5. Trends in a large collection or table of data is shown by creating a _________________ which summarises data visually.
      1. chart
      2. field
      3. worksheet
4. 4.

   What is a loop? What is the need of it?
5. 5.

   What is infinite loop? Explain.
6. 6.

   When should you use the SELECT CASE statement?