Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0613· OpenAIAi2 WildChat-4.8M (AI2)

Conditional Formatting Which of the following is NOT a conditional formatting option in…

  1. User

    Conditional Formatting Which of the following is NOT a conditional formatting option in Excel?

    choose from the following:

    Highlight Cell Rules Data Bars LAMBDA() Function Color Scales

  2. Assistant

    The option "LAMBDA() Function" is NOT a conditional formatting option in Excel.

  3. User

    Conditional Logic Which of the following Excel functions can replace nested IF() statements? (Select TWO that apply)

    choose from the following:

    ​​​​​​​​​​​​SUMPRODUCT() SWITCH() LET() ​​​​​​​​​​​​​​​​​IFS()

  4. Assistant

    The two Excel functions that can replace nested IF() statements are:

    1. SWITCH()
    2. IFS()
  5. User

    ambda Functions To calculate profit, we created the following LAMBDA() function:

    LAMBDA(Volume, Price, Cost, Volume * Price - Volume * Cost)(D2, E2, F2)

    What does the (D2, E2, F2) syntax, in the second pair of brackets, do in our function?

    choose from the following:

    Saves the function in the Name Manager Defines the variables for the function ​​​​​​​​​​​​Tests the function to check if it is working correctly Defines the calculation for the function

  6. Assistant

    The (D2, E2, F2) syntax in the second pair of brackets in the LAMBDA() function is used to define the variables for the function.

  7. User

    String Functions

    Consider the following scenario: we have a column of data containing text values. Here is a preview of the data:

    TextValues

    Prod.Hammers

    Prod.Nails

    Prod.Screwdrivers

    Prod.Drills

    We want to create a new column of data, retrieving the Product Name from the string in the Text Values column. The Product name is everything to the right of the “.” delimiter.

    Which of the following functions would return the Product Name?

    choose from the following:

    RIGHT(TextValues, -5) LEFT(TextValues, 5) RIGHT(TextValues, 5) RIGHT(TextValues, LEN(TextValues) - 5)

  8. Assistant

    The function that would return the Product Name is:

    RIGHT(TextValues, LEN(TextValues) - 5)