ability vlookup formula, hlook up, sum if, average if, and if formula logic conditions based on the criteria, the calculation of franchise royalties based on sales of goods, absenteeism and employee payroll, conditions formatting, setting chart based on the table, the settings in microsoft word presentation material point