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

Question

Share Report Error

In Excel, the 'Trace Precedents' feature shows:

A. Errors in the formula

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

C. The formula in a separate window

D. Cells that depend on the selected cell

Answer: Option B

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

Share Report

In MS PowerPoint, what is the default shortcut key sequence used to close the active presentation file window without exiting the application shell?

A. Alt + F4

B. Esc

C. Ctrl + W

D. Ctrl + Q

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + W (or Ctrl + F4) closes the active presentation file window, while keeping the main parent PowerPoint application frame open.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Word, to insert the current time, press:

A. Ctrl + Shift + ;

B. Alt + T

C. Ctrl + T

D. Alt + Shift + T

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Alt+Shift+T inserts a TIME field.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

What is the shortcut to open the 'Format Cells' dialog with Font tab in Excel?

A. Ctrl + 1

B. Alt + F

C. Ctrl + Shift + P

D. Ctrl + Shift + F

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+Shift+F opens Format Cells -> Font. Ctrl+1 opens main Format Cells.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs