Page 302 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

Another thing worth noting is when you hover over a query with the mouse cursor, Excel will generate a Peek Data
Preview. This will show you some basic information about the query.
• Data Preview – This is a live preview of the data similar to when first setting up a query.

• Columns – This will give you a list of all the columns contained in the final results of the query along with a
count of how many columns there are. Clicking on any of them will highlight the column in the data preview.
• Last Refreshed – This will tell you when the data was last refreshed.
• Load Status – This displays whether the data is loaded to a table, pivot table, pivot chart or is a connection
only.
• Data Sources – This will show you the source of the data along with a count of the number of files if you’re it’s
a from folder query.
• View in Worksheet – Clicking on this will take you to the output table if the query is loaded to a table, pivot
table or pivot chart.
You can also access this Peek view by right clicking on the query and selecting Show the peek.

There are also some useful messages displayed in the Queries & Connections window for each query. It will show
you if the query is a connection only, if there were any errors when the query last ran, or how many rows loaded.

The Home Tab

289

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77