If cell A1 = 10 and B1 = 20, what will `=A1+B1` return?
30
In a spreadsheet such as Microsoft Excel, a cell reference like A1 stands for the value stored in that cell. When a formula begins with the = sign, Excel treats what follows as a calculation to evaluate rather than as literal text.
The + symbol is the arithmetic addition operator, so =A1+B1 instructs Excel to fetch the numeric contents of A1 and B1 and add them:
- A1 = 10
- B1 = 20
- =A1+B1 → 10 + 20 = 30
Hence the formula returns 30.
The distractors correspond to different operators or mistakes:
- 1020 is what you would get from text joining, using the concatenation operator (=A1&B1), which strings the characters "10" and "20" together instead of adding them.
- 200 is the product of the two values, produced by the multiplication operator (=A1*B1), not by addition.
- Error would appear only if the formula were malformed or referred to invalid data (for example a #VALUE! error when adding text). Here both cells hold valid numbers, so no error occurs.
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?
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?
If cell A1 = 10 and B1 = 20, what will `=A1+B1` return?
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:
