Microsoft Exam 77-727 Topic 3 Question 39 Discussion

Actual exam question for Microsoft's exam

Question #: 39
Topic #: 3

SIMULATION

Project 7 of 7: Farmers Market

Overview

You are the Director of a local farmers' market. You are creating and modifying charts for a report which shows the amounts and variety of products sold during the season.

On the ''Summer Sales'' worksheet, switch the rows with the columns on the first column chart.

A1. Select the first row OR column on the ''Summer Sales'' worksheet and Copy either from the Home tab OR by pressing Ctrl+C on the keyboard.
2. Select the first cell where you want to paste the data, then click on the arrow next to Paste situated on the Home tab, then select Transpose.
3. Pick a spot with enough space to paste your data, the copied data will overwrite the already existing data that is already there.
4. Once completed, you can delete the original data if desired.

B1. Select the first row OR column on the ''Summer Sales'' worksheet and Copy either from the Home tab OR by pressing Alt+C on the keyboard.
2. Select the first cell where you want to paste the data, then click on the arrow next to Paste situated on the Home tab, then select Transpose.
3. Pick a spot with enough space to paste your data.
4. Once completed, you can delete the original data if desired.

Show Suggested Answer

Suggested Answer: A

References:

https://support.office.com/en-us/article/Transpose-data-from-rows-to-columns-or-vice-versa-in-Excel-for-Mac-9c16dd55-ed1a-4aa2-8b74-b1b9211e2ede

by Delmy at Jan 08, 2023, 04:33 PM

Limited Time Offer

25%

Off

Get Premium Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!