In Excel, the 'Trace Precedents' feature shows: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, the 'Trace Precedents' feature shows:

A. Cells that depend on the selected cell

B. The formula in a separate window

C. Arrows indicating which cells provide data to the selected formula

D. Errors in the formula

Answer: Option C

Solution (By JKSSB Mock Tests)

Trace Precedents (Formulas tab) draws arrows from cells that feed into the active cell.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1

In MS Access, what is the purpose of a 'Report'?

A. To display data in a formatted print-ready layout

B. To query data

C. To store data

D. To enter data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Reports are designed to present data in a professional, printable format. They are not for data entry (forms) or storage (tables) or querying (queries).

This question belongs to: Computer Microsoft Office

Question #2

What is the primary function of the built-in field property 'Validation Text' in an MS Access table designer screen?

A. It specifies the custom error message displayed to users when data violates a Validation Rule.

B. It sets the default value displayed inside the datasheet cell field.

C. It defines the calculation rule used to verify alphanumeric formats.

D. It functions as a placeholder pattern to guide manual typists.

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Validation Text contains the custom error message that alerts users when an invalid entry violates the data constraints specified in the Validation Rule property.

This question belongs to: Computer Microsoft Office

Question #3

In MS Access, which data type automatically generates a unique number for each new record?

A. Yes/No

B. Currency

C. Number

D. AutoNumber

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
AutoNumber is used for sequential unique IDs. Number stores numeric values, Currency for monetary data, Yes/No for boolean.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs