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

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

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
In MS PowerPoint, which option allows you to change the background style of a slide?
A. Background Styles
B. Both A and B
C. Format Background
D. Slide Design

Correct Answer: Option B


Explanation:
In PowerPoint, you can right-click and select 'Format Background' or use the 'Background Styles' dropdown under Design tab to change the background.

This question belongs to: Computer Microsoft Office
Question #2
The shortcut to display the 'Open' dialog in MS Office is:
A. Both A and B
B. Ctrl + F12
C. Ctrl + N
D. Ctrl + O

Correct Answer: Option A


Explanation:
Ctrl+O and Ctrl+F12 both open the Open dialog.

This question belongs to: Computer Microsoft Office
Question #3
Which of the following is used to apply animations to individual objects in PowerPoint?
A. Design tab
B. Animations tab
C. View tab
D. Transitions tab

Correct Answer: Option B


Explanation:
Animations tab adds movement to objects. Transitions are for slides.

This question belongs to: Computer Microsoft Office