The skills tested in this section of the Microsoft Office Specialist exam for Microsoft Excel 2013 relate to the application of functions and formulas. Specifically, the following objectives are associated with this set of skills:
|4.1 Utilize cell ranges and references in formulas and functions|
|4.2 Summarize data by using functions|
|4.3 Utilize conditional logic in functions|
|4.4 Format and modify text by using functions|
Simple formulas and more complex functions provide the means to interpret raw data stored in a workbook in meaningful ways. They also provide a useful structure for processing information. You can increase the consistency and reliability of information by using formulas to calculate, evaluate, ...