Which of the following function is a text function? *
A. Len
B. Concatenate
C. Trim
D. All of them
The row will not change when copied. *
A. $A$2
B. A$2
C. $A2
D. A$2$
This block holds two sets of code. This means you can ask the computer to do different things depending on if your condition is true or false. *
A. If/Else
B. If then Else
C. Wait until
D. Repeat until
To protect sheet, you need to click the ……………... Tab. *
A. File
B. Home
C. Design
D. Review
The syntax of the Sumifs function is ……………… *
A. =Sumifs(range, criteria, [sumrange])
B. =Sumifs(sumrange, criteria_range1, criteria1, …)
C. =Sumifs(criteria_range1, criteria1, [sumrange])
D. =Sumifs([sumrange], criteria_range1, criteria1, …)
No links please