If cell A1 = 10 and B1 = 20, what will `=A1+B1` return?
30
This question checks how a spreadsheet evaluates a formula that references other cells. In Excel, any entry beginning with an equals sign (=) is treated as a formula: the program looks up the referenced cells, substitutes their values, and computes a result.
Here A1 holds the number 10 and B1 holds the number 20. The formula =A1+B1 uses the + arithmetic operator, which performs numeric addition. So Excel evaluates it step by step:
- Read A1 → 10
- Read B1 → 20
- Add: 10 + 20 = 30
Therefore the formula returns 30.
Why the other results do not occur:
- Error would appear only if the formula were malformed or referenced invalid data (for example a divide-by-zero or an unknown name); =A1+B1 is perfectly valid, so no error is produced.
- 1020 is what you would get from concatenation — joining the two entries as text with the & operator (=A1&B1) — which glues "10" and "20" into "1020" rather than adding them.
- 200 is the product, obtained with the multiplication operator (=A1*B1 = 10 × 20). The plus sign adds rather than multiplies, so 200 is not the answer.
Because the operator is + and both cells contain numbers, the correct output is 30.
Similar Questions
You want to automatically advance slides with narration and animations during a presentation. Which MS PowerPoint feature should you use to achieve this?
What file extension is used to save an MS PowerPoint 2021 presentation?
Which function returns the smallest value?
If cell A1 = 10 and B1 = 20, what will `=A1+B1` return?
Which function returns the smallest value?
You want to automatically advance slides with narration and animations during a presentation. Which MS PowerPoint feature should you use to achieve this?
If cell A1 = 10 and B1 = 20, what will `=A1+B1` return?
What file extension is used to save an MS PowerPoint 2021 presentation?
Which function returns the smallest value?
You want to automatically advance slides with narration and animations during a presentation. Which MS PowerPoint feature should you use to achieve this?
Important Questions from Microsoft Office
Considering the content of the first cell of a worksheet as 10, the value of the Excel formula = $A$1/4 is:
In MS-PowerPoint, slide show options available to the presenter include all of the following, except for:
In a spreadsheet, one function inside another is called:
Which of the following alignment is applied to the below text?
[Type a quote from the document or the
summary of an interesting point. You can
position the text box anywhere in the
document. Use the Text Box Tolls tab to
change the formatting of the pull quote text
box.]
In MS Excel, the cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is:
