2. Question 2 Once you have completed Exercise 3, what is the correct formula in cell K197? 1 point =SUMIFS(Head_Count,Office_Name,$B197,Role,”Finance”,AvgHourlyCost,”>=”&K$185,AvgHourlyCost,”<=”&K$186) =COUNTIFS(Head_Count,Location_Name,$B197,Role,”Finance”,AvgHourlyCost,”>=”&K$185,AvgHourlyCost,”<=”&K$186) =SUMIFS(Head_Count,Location_Name,$B197,Role,”Finance”,AvgHourlyCost,”>=”&K$185,AvgHourlyCost,”<=”&K$186)
1. Question 1 In Exercise 3, how many sites are listed as need to hire (O189:O200)? 1 point 1 2 3 4
4. Question 4 True or False Pivot tables automatically update whenever you make changes to a data source. 1 / 1 point True False Correct. To update the information…
2. Question 2 Looking at the ribbon, which tab will you find the Pivot table option? 1 / 1 point Insert Formulas Data Correct. You can find…
3. Question 3 In the list below what are the correct steps for creating a pivot table? 1 / 1 point Click on the Pivot table function Highlight your data Click on…
1. Question 1 A pivot table is most commonly used to do which of the following? 1 / 1 point Facilitate the use of multiple logical tests in evaluating a data set…
3. Question 3 You receive a large data set and have been asked to find out how many occurrences took place from May to August. Which logic statement function would…
2. Question 2 Which logic statement function allows you to combine multiple IF statements into one set of tests to run additional formulas based on the outcomes of previous tests?…
4. Question 4 Which field in the Sumif formula below is NOT a mandatory field? = SUMIF(range, criteria, [sum_range]) 1 / 1 point Criteria Range sum_range That’s correct….
1. Question 1 Which two logic statement functions allow you to use multiple logical tests in evaluating a data set where all tests must be true? 1 / 1 point If +…
