Bea is the best pie baker around. She has decided to go into business and takes a survey in her town to find out what types of pies are favorites. She decides to resard her data in a worksheet she can present to the bank when she seeks a loan for her business startup sasts. Bea is new to using Excel, however, and she would like to besame sanversant in the keyboard shortcuts for the options available in the Paste Options gallery to expedite her work. Bea wants to sapy the santents and format of a source area but transpose, or swap, the rows and salumns. What keyboard shortcut can she use to do this?
A) CTRL+S
B) CTRL+T
C) CTRL+K
D) CTRL+D

Question

Quizplus · Accepted Answer

CTRL+T is not the correct shortcut for transposing data in Excel. To transpose data, Bea should use the Paste Special feature, which can be accessed by copying the data (CTRL+C), then using ALT+E, S, E to open the Paste Special dialog and select Transpose.

Bea Is the Best Pie Baker Around