Excel Tutorial: How to Rotate Table Data 90 Degrees Quickly and Easily

Interactive Video
•
Other, Social Studies
•
KG - University
•
Hard
Wayground Content
FREE Resource
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What are the two methods mentioned for changing the orientation of a table in Excel?
Using a third-party software or Excel's transpose feature
Manually recreating the table or using Excel's sort feature
Manually recreating the table or using Excel's transpose feature
Using Excel's filter feature or a third-party software
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which Excel feature allows you to rotate a table by 90 degrees?
Conditional Formatting
Sort and Filter
Data Validation
Paste Special with Transpose
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the first step in transposing a table in Excel?
Open a new Excel sheet
Highlight the table and copy it
Save the Excel file
Delete the existing table
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
After transposing a table, where are the headings located?
On the left-hand side
On the right-hand side
In the center
At the bottom
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you revert a transposed table back to its original format?
Manually recreate the table
Use the transpose feature again
Use the sort feature
Delete the transposed table
Similar Resources on Wayground
6 questions
Using Python in Microsoft Excel

Interactive video
•
11th Grade - University
6 questions
Business Intelligence with Microsoft Power BI - with Material - Working with the Fill up and Fill Down Options

Interactive video
•
University
6 questions
Excel: Sorting and Filtering Data in Excel

Interactive video
•
KG - University
6 questions
Business Intelligence with Microsoft Power BI - with Material - Merging Data from Different Data Sources

Interactive video
•
University
8 questions
Microsoft Excel 2021365 - Beginner to Advanced - Paste Options

Interactive video
•
University
2 questions
Microsoft Excel 2021365 - Beginner to Advanced - Looking Up Information Horizontally Using HLOOKUP

Interactive video
•
University
8 questions
The Complete Excel Guide: Beginners to Advanced - Introduction to PivotTables

Interactive video
•
University
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
20 questions
Brand Labels

Quiz
•
5th - 12th Grade
15 questions
Core 4 of Customer Service - Student Edition

Quiz
•
6th - 8th Grade
15 questions
What is Bullying?- Bullying Lesson Series 6-12

Lesson
•
11th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
Discover more resources for Other
10 questions
Human-Environment Interactions Vocab Unit 1 Grade 2 Quiz

Quiz
•
2nd Grade
5 questions
Ch2.1 Land and Water

Quiz
•
3rd Grade
20 questions
Latitude and Longitude Practice

Quiz
•
6th Grade
12 questions
Understanding Economy and Government

Quiz
•
6th Grade
20 questions
Adjectives

Quiz
•
4th Grade
20 questions
SS8H3

Quiz
•
8th Grade
20 questions
Causes of the American Revolution

Quiz
•
5th Grade
20 questions
Civics and American Government Daily Grade 1 Review

Quiz
•
3rd Grade