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!


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.



That’s all there is to it!

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


Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s