Class 6 Exam  >  Class 6 Questions  >  Which of the following formulas is not entere... Start Learning for Free
Which of the following formulas is not entered correctly?
  • a)
    =10+50
  • b)
    =B7*B1
  • c)
    =B7+14
  • d)
    10+50
Correct answer is option 'D'. Can you explain this answer?
Most Upvoted Answer
Which of the following formulas is not entered correctly?a)=10+50b)=B7...
The correct answer is option D: 10 50.

Explanation:
To understand why option D is not entered correctly, we need to understand how formulas are typically entered in spreadsheets.

In a spreadsheet, formulas are entered in cells to perform calculations and return results. The basic syntax for a formula is as follows:

=operator(value1, value2)

Here, the equal sign (=) signifies that the cell contains a formula, the operator specifies the type of calculation to be performed, and the values are the operands or inputs for the calculation.

In option D, the formula entered is "10 50." This is not a valid formula because it does not follow the standard syntax. It is missing an operator between the two values.

Let's break down the other options to see why they are entered correctly:

Option A: =10 50
Here, the formula is "10 50." Similar to option D, it is missing an operator and is not entered correctly.

Option B: =B7*B1
This formula multiplies the value in cell B7 with the value in cell B1. It follows the correct syntax, with the multiplication operator (*) between the two cell references.

Option C: =B7 14
This formula subtracts the value 14 from the value in cell B7. It follows the correct syntax, with the subtraction operator (-) between the cell reference and the value.

In conclusion, the formula "10 50" in option D is not entered correctly because it lacks an operator between the two values.
Free Test
Community Answer
Which of the following formulas is not entered correctly?a)=10+50b)=B7...
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.
Here in option D 10+50 there is no equal sign (=), so it is not correct.
Explore Courses for Class 6 exam

Top Courses for Class 6

Question Description
Which of the following formulas is not entered correctly?a)=10+50b)=B7*B1c)=B7+14d)10+50Correct answer is option 'D'. Can you explain this answer? for Class 6 2025 is part of Class 6 preparation. The Question and answers have been prepared according to the Class 6 exam syllabus. Information about Which of the following formulas is not entered correctly?a)=10+50b)=B7*B1c)=B7+14d)10+50Correct answer is option 'D'. Can you explain this answer? covers all topics & solutions for Class 6 2025 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for Which of the following formulas is not entered correctly?a)=10+50b)=B7*B1c)=B7+14d)10+50Correct answer is option 'D'. Can you explain this answer?.
Solutions for Which of the following formulas is not entered correctly?a)=10+50b)=B7*B1c)=B7+14d)10+50Correct answer is option 'D'. Can you explain this answer? in English & in Hindi are available as part of our courses for Class 6. Download more important topics, notes, lectures and mock test series for Class 6 Exam by signing up for free.
Here you can find the meaning of Which of the following formulas is not entered correctly?a)=10+50b)=B7*B1c)=B7+14d)10+50Correct answer is option 'D'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of Which of the following formulas is not entered correctly?a)=10+50b)=B7*B1c)=B7+14d)10+50Correct answer is option 'D'. Can you explain this answer?, a detailed solution for Which of the following formulas is not entered correctly?a)=10+50b)=B7*B1c)=B7+14d)10+50Correct answer is option 'D'. Can you explain this answer? has been provided alongside types of Which of the following formulas is not entered correctly?a)=10+50b)=B7*B1c)=B7+14d)10+50Correct answer is option 'D'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice Which of the following formulas is not entered correctly?a)=10+50b)=B7*B1c)=B7+14d)10+50Correct answer is option 'D'. Can you explain this answer? tests, examples and also practice Class 6 tests.
Explore Courses for Class 6 exam

Top Courses for Class 6

Explore Courses
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
10M+ students study on EduRev