What is the formula that will add D4 to the product of B1 plus B2? - ProProfs Discuss Topics More Products More   + Ask Question

# What is the formula that will add D4 to the product of B1 plus B2?

A. D4 + (B1+B2)
B. =D4+(B1*B2)
C. D4+B1*B2
D. =D4+(B1 + B2)

This question is part of Excel Proficiency Quiz
Asked by Tjz, Last updated: Feb 10, 2020

### Request 0Follow Share     Answer AnonymouslyAnswer Later Copy Link   #### Christian Jackson

Christian Jackson, Content Developer, Austin

In Excel, you can type in formulas into a cell so that you don’t have to type and type the same information into each cell. There may be a pattern to your data. You can create a formula into one cell and it will apply it to the other cells that you have designated as the ones that you want involved in the cells.

When you type in an equal sign at the beginning of a formula in Excel, that means that a calculation is about to be typed in. Then you would need to type the cell where you want the answer to be placed. Usually, a set of parentheses are typed into the formula to include the rest of the formula.    "product" is the result of two values multiplied together. Therefore, the correct answer is 2, not 4. I got this wrong, incorrectly.    #### John Smith

John Smith =d4+(b1 + b2)    Search for Google images Select a recommended image
Upload from your computer Cancel  Search for Google images Select a recommended image
Upload from your computer Cancel  Search for Google images Select a recommended image
Upload from your computer Cancel   