Conditional Formatting Which of the following is NOT a conditional formatting option in…
- 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
- Assistant
The option "LAMBDA() Function" is NOT a conditional formatting option in Excel.
- 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()
- Assistant
The two Excel functions that can replace nested IF() statements are:
- SWITCH()
- IFS()
- 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
- 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.
- 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)
- Assistant
The function that would return the Product Name is:
RIGHT(TextValues, LEN(TextValues) - 5)