Objective 3.1: Apply functions in formulasInsert functions into a formulaPerform logical operations by using the IF, AND, OR, and NOT functionsPerform logical operations by using nested functionsPerform statistical operations by using the SUMIFS, AVERAGEIFS, and COUNTIFS functionsObjective 3.1 practice tasksObjective 3.2: Look up data by using functionsObjective 3.2 practice tasksObjective 3.3: Apply advanced date and time functionsReference the date and time by using the NOW and TODAY functionsSerialize numbers by using date and time functionsObjective 3.3 practice tasksObjective 3.4: Perform data analysis and business intelligenceImport, transform, combine, display, and connect to dataConsolidate dataPerform what-if analysis by using Goal Seek and Scenario ManagerUse cube functions to get data out of the Excel data modelCalculate data by using financial functionsObjective 3.4 practice tasksObjective 3.5: Troubleshoot formulasTrace precedence and dependenceMonitor cells and formulas by using the Watch WindowValidate formulas by using error-checking rulesEvaluate formulasObjective 3.5 practice tasksObjective 3.6: Define named ranges and objectsName a cell or rangeName a tableManage named ranges and objectsObjective 3.6 practice tasks