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

Question

Share Report Error

In Excel, the 'Trace Precedents' feature shows:

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

B. Errors in the formula

C. Cells that depend on the selected cell

D. The formula in a separate window

Answer: Option A

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

What does 'Ctrl + F6' do in MS Word?

A. Switches between open document windows

B. Closes the document

C. Increases font size

D. Opens a new document

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+F6 cycles through documents.

This question belongs to: Computer Microsoft Office

Question #2

In MS Word, the 'Compare' feature is used to:

A. Check grammar

B. Measure reading level

C. Compare two versions of a document and show differences

D. Compare document with a template

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Compare (Review tab) merges and highlights changes between two documents.

This question belongs to: Computer Microsoft Office

Question #3

Which of the following mathematical formulas is evaluated correctly to find the geometric mean of cells A1 through A3 in MS Excel?

A. =PRODUCT(A1:A3)^(1/3)

B. =GMEAN(A1:A3)

C. =MEAN.GEOMETRIC(A1:A3)

D. =GEOMEAN(A1:A3)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The native, built-in function to compute the geometric mean of an array or numerical dataset range in Excel is GEOMEAN.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs