The question asks which formula correctly adds cells A1 through A5 in Excel. =SUM(A1:A5) is the correct syntax - the colon creates a range from A1 to A5 which SUM then totals. =SUM(A1+A5) would only add two cells (A1 and A5), and ADD and TOTAL are not valid Excel functions.