Show Menu

Excel for CAIE A-Level Cheat Sheet (DRAFT) by

Excel for CAIE A-Level

This is a draft cheat sheet. It is a work in progress and is not finished yet.


Adds the values in cells A2:10
=SUM(A­2:A10, C2:C10)
Adds the values in cells A2:10, as well as cells C2:C10
Largest in range
Smallest in range
Average in range


Count Numeric cells in A1:20
Count non empty cells in A1:20
Count how many cells equals to "­Lon­don­"
Count how many cells is at least 5
Count how many cells larger than B5's value


=IF(condition, true, else)