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
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 08 - copy-paste data in the blank worksheet

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

Interactive video
•
KG - University
8 questions
Creating a Live Currency Converter in Excel

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

Interactive video
•
University
4 questions
Efficiently Deleting Blank Rows in Excel

Interactive video
•
KG - University
6 questions
The Complete Excel Guide: Beginners to Advanced - Linking Chart Titles

Interactive video
•
University
6 questions
Microsoft Excel 2021365 - Beginner to Advanced - Creating a PivotTable from Scratch

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

Interactive video
•
University
Popular Resources on Wayground
18 questions
Writing Launch Day 1

Lesson
•
3rd Grade
11 questions
Hallway & Bathroom Expectations

Quiz
•
6th - 8th Grade
11 questions
Standard Response Protocol

Quiz
•
6th - 8th Grade
40 questions
Algebra Review Topics

Quiz
•
9th - 12th Grade
4 questions
Exit Ticket 7/29

Quiz
•
8th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
19 questions
Handbook Overview

Lesson
•
9th - 12th Grade
20 questions
Subject-Verb Agreement

Quiz
•
9th Grade