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

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

Assessment

Interactive Video

Other, Social Studies

KG - University

Practice Problem

Hard

Created by

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

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?