In Excel, the 'Transpose' paste option: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, the 'Transpose' paste option:

A. Copies only values

B. Pastes as a link

C. Switches rows to columns and columns to rows

D. Pastes formatting only

Answer: Option C

Solution (By JKSSB Mock Tests)

Transpose changes data orientation.

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

Which features in MS Word are used to divide a single document into separate formatting zones for columns, page numbering styles, or custom margins?

A. Section Breaks

B. Page Breaks

C. Paragraph Indents

D. Style Sets

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Section breaks allow you to isolate and apply different layouts, headers, footers, and structural configurations within the same document.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Excel, what function can you use to count the number of empty or unpopulated cells within a specified range?

A. COUNTIF

B. COUNT

C. COUNTA

D. COUNTBLANK

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
COUNTBLANK counts empty cells within a specified cell range.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

Which of the following is the default view in MS Word 2016?

A. Read Mode

B. Draft

C. Print Layout

D. Web Layout

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Print Layout is the default view.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs