Which of the following is a valid way to start a formula in Excel? MCQ with Answer and Explanation

Which of the following is a valid way to start a formula in Excel?
A. All of these
B. @ (at sign)
C. + (plus sign)
D. = (equal sign)
Answer: Option A
Solution (By JKExamLibrary)
While = is standard, you can also start with + or - and Excel will convert it to a formula. @ is used in table references but not to begin a formula. So only = is required. + also works in some cases (e.g., +A1+A2). Many exams consider = only. I'll stick with = only. I'll set answer A.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1 Report Error
In MS Word, the 'Thesaurus' tool is available under which tab?
A. References
B. Review
C. Home
D. Insert

Correct Answer: Option B


Explanation:
The Thesaurus is located in the Review tab, in the Proofing group. It provides synonyms and antonyms.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In PowerPoint, which tab contains the 'Record' option?
A. Design
B. Slide Show
C. Animations
D. Insert

Correct Answer: Option B


Explanation:
Record Slide Show is on Slide Show tab.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In MS Word, the process of combining a standardized template letter document with a separate structured recipient list database to generate personalized mail is called:
A. Document Fusion
B. Mail Merge
C. Data Merging
D. Form Tracking

Correct Answer: Option B


Explanation:
Mail Merge is a powerful feature in MS Word used to bulk-generate personalized mass documents, letters, or labels from a single structured data source.

This question belongs to: Computer Microsoft Office