Data Rotation and Transposition in Microsoft Excel
Which of the following function rotate the contents of columns to rows and rows to columns in Microsoft Excel?
مندرجہ ذیل میں سے کون سا فنکشن مائیکروسافٹ ایکسل میں کالموں اور قطاروں کے مواد کو کالموں میں گھماتا ہے؟
Answer: transpose
Explanation
The purpose of the TRANSPOSE function in Excel is to convert rows to columns,
i.e. switch the orientation of a given range from horizontal to vertical or vice versa.
The function takes just one argument:
TRANSPOSE(array)
Where array is the range of cells to transpose.
ND29-5-2023
This question appeared in
Past Papers (3 times)
Appraising, Valuation Officer Past Papers and Syllabus (1 times)
FPSC 5 Years Past Papers Subject Wise (Solved With Details) (1 times)
FPSC Past Papers (1 times)
This question appeared in
Subjects (1 times)
COMPUTER (1 times)
Related MCQs
- In a 5-class, rows and columns are equal. If rows are K, what will be the value of columns?
- Which is the utility of Excel to fill the columns/rows with a series of data?
- What are the small squares arranged in rows and columns called in Excel?
- Which Excel feature allows you to freeze rows and columns so they remain visible while scrolling?
- The software which contains rows and columns is called in MS Excel is called?
- Intersection of columns and rows in called a?
- To change the rows in columns is called?
- A matrix having m rows and n columns with m ≠ n is said to be a _____?
- The minimum number of rows and columns in MS word document is ____?
- The process of systematic arrangement of data in rows and columns is called ___________________?
