200k views
3 votes
Determine the “answer” to the formula according to the spreadsheet below: =SUM(A1:D1).

Determine the “answer” to the formula according to the spreadsheet below: =SUM(A1:D-example-1
User Noah Borg
by
7.8k points

2 Answers

4 votes
5
because 2 +3 equals 5

User Irit Katriel
by
8.1k points
6 votes
When you are trying to solve a formula like this one, you need to consider the whole row in the spreadsheet, not just A1 and D1.
So, A1:D1 refers to the whole row, which means that you need to add A1+B1+C1+D1 = 2 + 1 + 5 + 3 = 11.
The answer to the formula according to this spreadsheet is 11.
User Frank Van Eykelen
by
8.5k points