Which of the following methods is a valid way to clean your data or check for errors and inconsistencies? A. Filter (drop down) B. Data Validation C. Pivot Table D. All of the above QUESTION 2 Victor is trying to figure out how many employees work at the Denver, CO office. His dataset includes all 20,000 employees spread across four ofce locations. The dataste also indicates which location each employees work from. Which formula should Victor use? A. =Sumlf B. =CountlF C. =AveragelF D. =SumlFS QUESTION 3 Regina wants to know the average performance score for entry level employees (job level 1) that work at the Hayward, CA location. Which formula should Regina use? Assume there that the dataset Regina is working with has multiplejob levels and multiple locations, and that the employees' location, job level, and performance scores are listed in separate columns. A. =Average B. =Averageif C. =AveragelFS D. None of these would help answer Regina's question. QUESTION 4 If you notice that the data coming into a HR or management system is continuosly lled in errors and inconsistencies, it is important to focus on changing how the data are collected, to reduce the number of errors that happen in the future. Tru e False QUESTION 5 Paula is working in an Excel file and calculates the average of cells B2:B16 in Cell B18. The formula is =average($B$2:$B$16). She then drags the formula to cell C18. What will the formula be in cell C18? A. None of these are correct B. =average(B$2:$C$16) C. =average($B$2:$B$16) D. =average(C$2:$C$16)