Home » Microsoft » 77-727 » SIMULATION
SIMULATION
You are the owner of a small bicycle tour company summarizing trail rides that have been booked for the next six months.
On the “Summer Bookings” worksheet, remove the table functionality from the table. Retain the cell formatting and location of the data.
Correct Answer: See explanation below.
Explanation/Reference:
Explanation:
1. Click Design from the Ribbon on Table Tools.
2. In the Tools group, click on Convert to Range.
OR
1. Right-click the table then click on Table then press Convert to Range.
References: https://support.office.com/en-us/article/convert-an-excel-table-to-a-range-of-data-0b326ff1-1764-4ebe-84ea-786265d41c77?redirectSourcePath=%252fen-us%252farticle%252fRemove-a-table-without-losing-the-data-or-table-format-ADF88635-90F5-4FAA-9417-19862F38CCE8&ui=en-US&rs=en-US&ad=US