1 / 10

Working with the Data Table

Working with the Data Table. USINGQTP65-STUDENT-01A. Objectives. In this lesson, you will learn: How to use the spreadsheet capabilities of the data table to create checkpoints with simple calculations. How Can I Meet This Test Requirement? . TEST REQUIREMENT

domani
Download Presentation

Working with the Data Table

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Working with the Data Table USINGQTP65-STUDENT-01A

  2. Objectives In this lesson, you will learn: • How to use the spreadsheet capabilities of the data table to create checkpoints with simple calculations

  3. How Can I Meet This Test Requirement? TEST REQUIREMENT 1.2.2 Compute Price TotalsVerify that the List Price equals the Price value plus the discount (under You Save).

  4. Components of a Checkpoint using Spreadsheet Formulas Create a text checkpoint on the value to verify Capture other values necessary for the verification into the Data table Create a formula to compute the total of the output values (13.00 = 10.40 + 2.60) Modify the text checkpoint arguments to use the computations in the Data table.

  5. 1. Capture the Relevant Values Important: Make sure the values captured have the same format.

  6. Double-click on the column header to change the header label. 2. Create Values That Will be Compared to the Checkpoint • Add a new column that computes for the total of the output values • Format the data in the new column as required

  7. 3. Modify the Checkpoint Arguments Turn the constant value of the checkpoint into a parameter. The actual value will be placed into an output parameter named “ListPrice_out". The value in “ListPrice_out" will be compared with the value in "Total" using the specified formula.

  8. Data Table Formula Added to Checkpoint Currently, the Data Table formula is evaluating-- Is the value in ListPrice_out equal to the string “$13.00?” The formula should be edited so that the value in ListPrice_out is equated to the computed value under Total.

  9. Check Excel documentation for more information on formulas to use. Data Table Formulas (Examples) • First word in a sentence: =LEFT(A1, SEARCH(" ", A1, 1) • A part of the sentence starting with the word "word": =MID(A1, SEARCH("word", A1, 1), LEN(A1)) • Check whether two strings are equal: =EXACT(A1, "Flight") • Concatenation of two strings: ="Hello" & "There" • Check whether string1 appears in string2 =FIND(string1, string2, 1) • Today’s date: =TODAY()

  10. Other Technique – Link Values using Parameters Evaluate checkpoints by linking to computed values.

More Related