R-06 : Intermediate Reporting: Conditional Formatting

9 Questions | Total Attempts: 333

SettingsSettingsSettings
Please wait...
R-06 : Intermediate Reporting: Conditional Formatting

Questions and Answers
  • 1. 
    Conditional Formatting applies user-defined formatting to the report and is: (Select all the apply)
    • A. 

      Applied to field values

    • B. 

      Based on custom display settings

    • C. 

      Determined by pre-defined criteria

    • D. 

      Predetermined by system algorithms

  • 2. 
    The intent of Conditional Formatting is to identify trends, outliers and?
    • A. 

      Make your report look pretty

    • B. 

      Draw attention to specific records

    • C. 

      Provide desired report results

    • D. 

      Filter report results

  • 3. 
    What is the correct tab to select when establishing Conditional Formatting? 
    • A. 

      Sort/Group

    • B. 

      Layout

    • C. 

      Style/Format

    • D. 

      Advanced

  • 4. 
    Up to six different conditional formatting criteria can be defined. 
    • A. 

      True

    • B. 

      False

  • 5. 
    The Operator field for Conditional Formatting includes various expressions, such as? (Select all that apply)
    • A. 

      Greater Than

    • B. 

      Equal To

    • C. 

      Within

    • D. 

      Is Not

    • E. 

      Between

  • 6. 
    In order to set up Conditional Formatting, you would need to access the Report Criteria window. 
    • A. 

      True

    • B. 

      False

  • 7. 
    In order to adjust the border and background color of your Conditional Formatting, you would click the dropdown for which field?
    • A. 

      Value(s)

    • B. 

      Apply Criteria To

    • C. 

      Format/Type

    • D. 

      Format Style

    • E. 

      Criteria Type

  • 8. 
    By selecting “Display Format Criteria”, will you see your Conditional Formatting Criteria? 
    • A. 

      Yes

    • B. 

      No

    • C. 

      Maybe

    • D. 

      I have no idea

  • 9. 
    When editing your format, what is “padding”? 
    • A. 

      Another word for “bold”

    • B. 

      A way to create extra space around text

    • C. 

      The space added below the text

    • D. 

      Outlining around the text

Back to Top Back to top