How to see the updated output of index?

How to see the updated output of index?

On creating a index on table, in Sql server how can you see the output of
updated index ?
Query to create an index on the table called [dbo].[Sheet1$] in SQL Server.
create index ix_project_id_PK
on [dbo].[Sheet1$] ( [Project_Key] DESC)