In your client's company, the Telephone Allowance is paid as per the grade of an employee. This information is stored in a User Defined Table. The Row is set as the Grade name and the Column Value…

Question

Options

• AIn the Table Structure window, set the Match Type of the table as Range.
• BIn the Table Structure window, set the Match Type of the table as Match.
• CCreate a Formula Validation to return an error if the Entry Value is greater than 300.
• DIn the Table Structure window, select the Range Validation check box.
• ECreate an Independent Value set to have values from 0 to 300.

• A
  71% (25)
• B
  3% (1)
• C
  6% (2)
• D
  3% (1)
• E
  17% (6)

Explanation

You set up user tables in the Table Structure window. To set up the structure of a table: 1.Set your effective date to the date from which you want the table's row labels to take effect. 2.Enter the table name. 3.For the table's match type, select Match or Range. Select Match if each row is for one item, such as one job or one code. Select Range if each row is for a range of numeric values, such as an age range or a pay range. (A) 4.If the match type is Match, select Date, Number or Text as the Key Units of Measure, depending on whether entries in the rows are dates (DD-MON-YYYY), numbers, or alphanumeric If the table's match type is Range, the Key Units of Measure automatically becomes Number. 5.Enter the row label as the Row Title. For example, if the table rows refer to rate codes, an appropriate row title would be Rate Code. If the rows refer to age ranges, you might use the title Age Range. 6.Save your work, and choose the Columns button to go to the Columns window.

No community discussion yet for this question.