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. = (equal sign)
B. + (plus sign)
C. All of these
D. @ (at sign)
Answer: Option C
Solution (By JKSSB Mock Tests)
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.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In MS Access, which of the following is a valid relationship type?
A. Many-to-Many
B. One-to-Many
C. One-to-One
D. All of the above

Correct Answer: Option D


Explanation:
Access supports all three types of relationships: one-to-one, one-to-many, and many-to-many (via a junction table).

This question belongs to: Computer Microsoft Office
Question #2
Which feature in MS Word allows users to create standardized form letters or labels by combining a master template document with an external address list database?
A. Track Changes framework
B. Mail Merge
C. Style Separator compilation
D. Quick Parts automation

Correct Answer: Option B


Explanation:
Mail Merge is an automation tool that merges a standardized template document with an external data source (such as an Excel spreadsheet or Access table) to bulk-generate personalized mass mailings or labels.

This question belongs to: Computer Microsoft Office
Question #3
In MS Word, which view shows the document as it will appear when printed?
A. Print Layout
B. Read Mode
C. Draft
D. Web Layout

Correct Answer: Option A


Explanation:
Print Layout view displays the document with margins, page breaks, headers, footers, etc., as it will appear when printed. Read Mode is optimized for reading, Web Layout for web pages, Draft shows minimal formatting.

This question belongs to: Computer Microsoft Office