What is the formula that will add D4 to the product of B1 plus B2? - ProProfs Discuss
Topics
Products
Follow Us:

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

+ Answer
Request

3 Answers

Christian Jackson

Christian Jackson, Content Developer, Austin

Answered Nov 11, 2018

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.

 

John Adney

John Adney

Answered Apr 05, 2017

"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

Answered Nov 08, 2016

=d4+(b1 + b2)
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.