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

Question 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. Errors in the formula

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

Answer: Option D

Solution (By JKExamLibrary)

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

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 PowerPoint, 'Embed fonts' option is available under:

A. File -> Options -> Save

B. Design -> Fonts

C. Insert -> Text -> Font

D. View -> Slide Master

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
Embed fonts is in PowerPoint Options, Save section.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

Which Access database object contains programming code that automates complex tasks?

A. Query

B. Module

C. Report

D. Macro

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
Modules contain VBA code for advanced automation. Macros are simpler.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In Excel, what is the default number format for cells?

A. Custom

B. Number

C. General

D. Text

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
General is the default format.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs