A workbook contains sales information for the first quarter and you are interested in finding the totals sales generated in January by the sales rep Jim Anderson. What function is best suited to handle the task?
A) SUMIFS
B) AVERAGEIFS
C) DCOUNT
D) COUNTIFS
Answer: A) SUMIFS
You might also like to view...
In ActionScript 3.0, the ____ programming concept is described as the attributes of an object.
A. methods B. variables C. properties D. parameter
What value is assigned to decTaxes by the following program segment, assuming that the user enters 30000 into the textbox txtSalary.Text?
Dim decSalary, decTaxes As Decimal decSalary = CDec(txtSalary.Text) If (decSalary > 50000) Then decTaxes = .40 * decSalary ElseIf (sngSalary > 40000) Then decTaxes = .30 * decSalary ElseIf (sngSalary > 30000) Then decTaxes = .20 * decSalary Else decTaxes = .10 * decSalary End If a. 12000 b. 9000 c. 6000 d. 3000
Answer the following statements true (T) or false (F)
1. As with any block cipher, AES can be used to construct a message authentication code, and for this, only decryption is used. 2. The inverse add round key transformation is identical to the forward add round key transformation because the XOR operation is its own inverse. 3. The Rijndael developers designed the expansion key algorithm to be resistant to known cryptanalytic attacks. 4. The transformations AddRoundKey and InvMixColumn alter the sequence of bytes in State. 5. AES can be implemented very efficiently on an 8-bit processor.
Which of the following is an authentication mode supported by SQL Server 2012?
A. Server-instance authentication B. System level authentication C. Hybrid authentication mode D. Mixed authentication mode