What two regular expression characters can be used to match the characters at the beginning or end of a line, respectively?
A. ?.
B. ?^
C. ?$
D. ?+
Ans:
B. ?^
C. ?$
You might also like to view...
You are creating an IIF function. If the input in the Net Sales field is greater than or equal to 60, then the custom field will read "Pass." If Net Sales are less than 40, the custom field will read "Fail." What is the function that will be entered into the field name?
A) If([Net Sales]>=.60, "Pass", "Fail") B) If([Net Sales] >=60, Pass, Fail) C) IIf(Net Sales >=60, Pass, Fail) D) IIf([Net Sales] >=60, "Pass", "Fail")
Lines must be active prior to any formatting
Indicate whether the statement is true or false
A(n) ____________________ is a searchable word that is contained in the Help database.
Fill in the blank(s) with the appropriate word(s).
In B1:B12 input the MONTHs: 1 to 12. In C1:C12, we want to input a formula to show the QUARTERs of each month accordingly. The SHORTER method here is: Select one:
A. =IF() B. =ROUNDUP()