In Excel, the 'Watch Window' is used to: MCQ with Answer and Explanation

In Excel, the 'Watch Window' is used to:
A. Audit formulas
B. Track changes to the workbook
C. Monitor the values of cells in a separate window while working
D. View all open workbooks
Answer: Option C
Solution (By JKSSB Mock Tests)
Watch Window (Formulas tab) keeps selected cells visible.

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 field property constraint must be deployed to guarantee that an auto-incremented database table row cannot hold duplicate records?
A. Required set to 'No'
B. Validation Rule mapping
C. Indexed set to 'Yes (No Duplicates)'
D. Input Mask application

Correct Answer: Option C


Explanation:
Setting the Indexed property to 'Yes (No Duplicates)' establishes a unique constraint rule index that prevents identical values from being entered into that field.

This question belongs to: Computer Microsoft Office
Question #2
In MS Word, the feature that automatically scales down a document layout to fit text precisely onto one less physical sheet if it overflows by just a few trailing lines is:
A. Shrink One Page
B. AutoFit Window
C. Page Setup Optimizer
D. Compact Layout margins

Correct Answer: Option A


Explanation:
The 'Shrink One Page' (or Shrink to Fit) command decreases the size of text and margins slightly to fit the document's content onto one less page than it currently occupies.

This question belongs to: Computer Microsoft Office
Question #3
Which specialized tool in MS PowerPoint allows an author to record precise rehearsal durations for each slide to ensure an automated slide show runs smoothly?
A. Set Up Slide Show
B. Slide Master
C. Animation Painter
D. Rehearse Timings

Correct Answer: Option D


Explanation:
Rehearse Timings allows you to run through your presentation and log the length of time spent on each slide, saving those parameters to automate presentation delivery.

This question belongs to: Computer Microsoft Office