Which formula in Microsoft Excel will get the sum of the first 20 cells in the first column? A=SUM(A1:A 20) B =SUM( A1:T1) C=ADD(A1:A 20) D=ADD(A1-A 20) E=ADD(A1-T1)

A

The question asks for the Microsoft Excel formula that sums the first 20 cells in the first column. In Excel, the SUM function is used to add together the values in a range of cells. A: =SUM(A1:A20) - This formula correctly represents the sum of cells from A1 to A20, which are the first 20 cells of the first column.B: =SUM(A1:T1) - This formula would sum cells from A1 to T1, which are the first 20 cells in the first row, not the first column.C: ADD(A1:A20) - The term 'ADD' is not a recognized function in Excel.D: ADD(A1-A20) - Similar to option C, 'ADD' is not a function and the notation does not represent an Excel range.E: ADD(A1-T1) - This also contains the spurious 'ADD' function and the range implies summing across the first row, not the first column.Therefore, based on the knowledge of Excel formulas, option A is the correct formula to sum the first 20 cells in the first column.