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

Hard

Created by

Quizizz 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