question_answer

In MS-Excel 2007, when you enter = SUM (A1:Z1) in B2, it __________.

A)  Is an invalid operation

B)  Inserts the sum of the contents of cells A1 and Z1 in B2

C)  Replaces the contents of first column elements from A1 to Z1 after adding each element with the content B2

D)  Inserts the sum of all first column cells A1 through Z1 in B2

E)  None of these