apply conditional formulas, for example: SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, MAXIF, MAXIFS and MINIF, MINIFS

Testing a spreadsheet structure creating and applying a test plan to test spreadsheet elements, including: functions, validation rules, conditional formatting