Valid 77-427 Dumps shared by ExamDiscuss.com for Helping Passing 77-427 Exam! ExamDiscuss.com now offer the newest 77-427 exam dumps, the ExamDiscuss.com 77-427 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 77-427 dumps with Test Engine here:
You work as an Office Assistant for Dreams Unlimited Inc. You use Microsoft Excel 2013 for creating various types of reports. You have created a report in the format given below: In the A7 cell, you are required to put a formula so that it can fulfill the description provided in the B7 cell. Which of the following formulas will provide the required result?
Correct Answer: D
Explanation/Reference: Explanation: In order to get the required result, you will have to insert the following formula in the B7 cell: COUNTIFS (B2:B5,"=Yes",C2:C5,"=Yes") Only Sarah and David have exceeded their January and February quotas, therefore the formula will provide 2 as the result. Incorrect Answers: Answer options A, B: This formula will count all the cells that have the value "Yes" in the range B2:C5. As multiple criteria are not applied in the formula, it will provide 6 as the result. In the A7 cell, you are required to put a formula so that it can fulfill the description provided in the B7 cell. Which of the following formulas will provide the required result? C: The COUNTIF function of Excel does not support multiple criteria. References: https://support.office.com/en-us/article/countifs-function-dda3dc6e-f74e-4aee-88bc- aa8c2a866842
