The skills tested in this section of the Microsoft Office Specialist Expert exams for Microsoft Excel 2013 relate to the creation of sophisticated formulas. Specifically, the following objectives are associated with this set of skills:
|3.1 Apply functions in formulas|
|3.2 Look up data by using functions|
|3.3 Apply advanced date and time functions|
|3.4 Create scenarios|
Most users of Excel have created formulas that include one or more of the most commonly used Excel functions, such as SUM, AVERAGE, COUNT, MAX, and MIN. However, Excel provides functions for other very specific operations.
This chapter guides you in studying methods for these other operations, such as calculating dates and times, performing statistical ...