In Excel, the 'Paste Special' option 'Values' pastes: MCQ with Answer and Explanation

In Excel, the 'Paste Special' option 'Values' pastes:
A. Only the values, not formulas or formatting
B. Comments only
C. Formulas only
D. Formatting only
Answer: Option A
Solution (By JKExamLibrary)
Values pastes the results of formulas.

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
Which Excel feature allows you to automatically fill cells with a series (e.g., 1,2,3 or Mon,Tue,Wed)?
A. AutoFill handle
B. Data Validation
C. Goal Seek
D. Flash Fill

Correct Answer: Option A


Explanation:
Dragging the fill handle (small square at bottom-right) creates series. Flash Fill detects patterns.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
Which of the following is NOT a valid slide layout in MS PowerPoint?
A. Title and Content
B. Section Header
C. Multi-Column
D. Title Slide

Correct Answer: Option C


Explanation:
PowerPoint has built-in layouts like Title Slide, Title and Content, Section Header, Comparison, etc. There is no 'Multi-Column' standard layout, though you can create columns manually.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
To open a new document in MS Word, press:
A. Ctrl + Alt + N
B. Ctrl + O
C. Ctrl + S
D. Ctrl + N

Correct Answer: Option D


Explanation:
Ctrl+N new document.

This question belongs to: Computer Microsoft Office