Efficio Interview Question

Excel test with some basic formulas but really long