The ability to view different parts of a worksheet at once by dividing the screen into independent panes is being tested. The Split option creates horizontal and/or vertical split bars within the current window, so you can scroll each pane separately and keep specific rows or columns in view while you work in another area. This is handy for comparing data in distant parts of a sheet or keeping headers visible as you navigate. Freeze Panes, by contrast, locks certain rows or columns so they stay visible while you scroll, but it doesn’t create multiple independent panes in the same window. New Window opens a separate window for the same workbook, allowing you to arrange windows side by side, which is not the same as splitting a single window. View Side by Side arranges two windows for comparison but again involves separate windows rather than splitting one window into panes.

Recognizing duplicate records is about spotting entries in a table that repeat the same information. When an Excel table contains the same combination of values in one or more columns, you end up with duplicates—two or more rows that look identical or share the same key fields. This repetition is what we mean by duplicate records. Duplicates can arise from copy-paste, merging datasets, or imports, and they can skew counts, sums, and other analyses, so cleaning them up improves data quality. In Excel you can highlight duplicates with conditional formatting and remove them with the Remove Duplicates tool. If you only want unique entries, you can use the UNIQUE function (Excel 365+) or other filtering methods. The other terms—an area copied, exporting data, or charts—don’t describe repetitive data within the table: a chart is a visual representation, not the repetition of data, exporting moves data out of the workbook, and a copy area isn’t a standard concept describing repetitive SAMPLEdata.

Gridlines are the faint lines that form the grid of a worksheet, marking the boundaries between cells. These lines make it easy to see where one cell ends and another begins, helping you read data accurately and select or align cells precisely. The other features mentioned serve purposes in charts rather than the worksheet grid: a legend explains chart series, axis titles label the axes, and data labels show exact values on data points. So the gridlines are what define the distinct, readable cell structure on a worksheet.

The wording that explains what the symbols on a chart mean is called the legend. It serves as a key, listing each symbol, color, or line style used and what data or category it represents. This helps readers interpret the chart accurately rather than guessing. Without a legend, the symbols would be ambiguous. Gradient relates to color shading, motion path refers to the route of movement in animations, and a footer is the bottom part of a page, none of which describe the symbols’ meanings.