In the cells of the spreadsheet A1, B1, C1, the values 4, 6, 6 are written respectively. In the cell D1 the formula

In the cells of the spreadsheet A1, B1, C1, the values 4, 6, 6 are written respectively. In the cell D1 the formula = SUM (A1: C1) is written. What value will cell E1 have if you write the formula = ROOT (D1) into it?

A record of the form “= SUM (A1: C1)” located in cell D1 means that it is necessary to sum the values of the fields of all cells located in the range from A1 to C1. These are the values of the fields of cells A1, B1 and C1. Thus, cell D1 will contain the number 4 + 6 + 6 = 16. Variation of the form “= ROOT (D1)” in cell E1 indicates that the cell will contain the square root of the number stored in cell D1 (that is, 16). Therefore, the cell E1 will store the number 4.
Answer: 4.