Question

A spreadsheet has students as rows and subjects as columns. After taking the transpose, what do the rows and columns represent?

Options

• Students and subjects are both represented as rows

• Students and subjects are both represented as columns

• Students become columns and subjects become rows

• Students remain rows and subjects remain columns

Answer 1

Taking the transpose is like rotating the table. The original students as rows become students as columns, while subjects as columns become subjects as rows.