Question

Which of the following formulas is not entered correctly?
A. =10+50
B. =B7*B1
C. =B7+14
D. 10+50​

Answer 1

We have to check the options  is not correct.

Solution:

A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.

Check the options:

A. = 10 + 50,having equal sing, then formula is correct.

B. = B7*B1,having equal sing, then formula is correct.

C. = B7 + 14,having equal sing, then formula is correct.

D. 10 + 50​,having not equal sing, then formula is correct.

Thus, the required option is "D. 10 + 50​".

Answer 2

Given:

A. =10+50

B. =B7*B1

C. =B7+14

D. 10+50​

To Find:

Which of the given formulas is not entered correctly?

Solution:

Option - D. 10+50 is not entered correctly in Excel sheets or spreadsheets.

• The Microsoft Excel sheet or Go ogle spreadsheet is a computer application. It is used to save large data in a tabular form.

• It is a file that exists of cells in rows and columns.  We can enter the data in each cell can be numerical values, text, formulas, functions, etc.

• Each cell contains one value or text. we can give different colors to each cell in sheets. A formula should always start with equal(=) sign. So, the formula that is not having an equal sign is not entered correctly.