Case 3-2
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 record her data in a worksheet she can present to the bank when she seeks a loan for her business startup costs.Bea is new to using Excel,however,and she would like to become conversant in the keyboard shortcuts for the options available in the Paste Options gallery to expedite her work.
-Bea wants to copy the contents and format of a source area but transpose,or swap,the rows and columns.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

The correct keyboard shortcut for transposing (swapping rows and columns) while pasting in Excel is not directly listed among the options (A, B, C, D). However, the standard method to transpose data in Excel involves copying the data, then selecting the destination, and using the Paste Special option, where one can select "Transpose". This specific action does not have a direct keyboard shortcut like CTRL+S (save), CTRL+K (insert hyperlink), or CTRL+D (fill down). The closest to a direct action for transposing via a keyboard shortcut involves using the Alt key to access the Ribbon commands, not a simple CTRL command as listed. Therefore, the question might contain a misunderstanding or be seeking a different kind of answer related to Excel's capabilities as of the last update.

Case 3-2 Bea Is the Best Pie Baker Around.She Has Decided to Decided