Excel Formula Entry Rules
Which of the following formulas is NOT correctly entered in Excel? A) =C1+15 B) =SUM(A1:A5) C) =A1*B1 D) C1+15
Answer: C1+15
Explanation
In Excel, formulas must begin with an equals sign (=).
Options A, B, and C are all valid formulas.
Option D (C1+15) is not a valid formula because it lacks the = sign.
This question appeared in
Past Papers (4 times)
PPSC 5 Years Past Papers Subject Wise (Solved with Details) (2 times)
PPSC Past Papers (2 times)
This question appeared in
Subjects (1 times)
COMPUTER (1 times)
Related MCQs
- Which symbol is used to execute formulas in MS Excel?
- In MS Excel, You can copy data or formulas _____?
- Which of the following formulas MS-Excel 2016 will not be able to calculate? =SUM (AI: A5)*.5, =SUM (Sales)-A3, =SUM( AI: A5)/(10-10), =SUM(AI:A5)-10
- which of these keys are used in ms excel to copy formulas from the above cell?
- Which area in an excel window allows entering values and formulas?
- In MS-Excel when you are typing an equation into a cell the first thing that must be entered is
- In MS Excel window the __________ menu system is how user navigates through Excel and access the various Excel commands.
- In which product of MS Office we can use formulas?
- A man gives an exam with 12 questions. He answers each question correctly and scores 60% of the total marks. How many questions did he solve correctly?
- What is the shortcut keyboard to edit formulas in a cell?
