Practice Exam Question: Excel 2010 – Convert Existing Data into Table and Apply Table Style

In Microsoft Excel 2010,
how do you convert your existing data into a table and apply a table style to it?

Hint: As with so many functions in Microsoft Office programs across the board, there is more than one way to do this. The steps I take to achieve this particular goal may differ from what you would do, but if the end result is essentially the same then you’ve done it correctly!

scroll-down

Answer :

1. With your worksheet already open and on the screen, select the data from which you wish to create your table.

2. On the Home tab, in the Styles group, select the drop down arrow associated with the Format as Table button. Select the table style of your choice.

Excel2010DataTableBefore

Excel2010DataTableAfter

That’s all there is to it!

-Katie Caplan,
Client Service Coordinator and Instructor,
Sector Learning Solutions

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s