Is a set of coordinates that identifies a specific cells. It's a combination of letters and numbers. A5, for example, would point to the cell located where column A and row 5 intersect.
This feature helps to prevent incorrect data from being entered into your worksheet. This most commonly used to create drop-down lists for common terms.
are formulas that are pre-built into Excel. They are designed to help simplify potentially complex formulas in a worksheet.
if Excel finds a problem with a provided formula
A sequence inside a cell that is used to produce a value. It must begin with an equal (=) sign. This could be a mathematical equation, cell references, functions or operator. It is also known as an expression.
Refers to an Excel spreadsheet file
Refer to how your cells are aligned. Aligned vertically while other one is aligned horizontally
allows you to select specific columns and/or rows to remain visible on the worksheet, even if you are scrolling, such as header cells that label a column.
Is a point on the worksheet where you would drag a ___field in order to reorganize how a report is displayed.
Much like worksheets in a workbook, a _____allows you to open numerous files simultaneously.
is a rectangle or block housed in a worksheet. Any data that you want to enter into your worksheet must be placed
When two or more cells are combined
A collection of cells that have been identified as a group based on a variety of criteria. By using a colon (:) between cell references, Excel can determine the_______
formatted workbook or worksheet designed to help users fulfill a specific need in Excel. Examples of this include stock analysis, process map, and calendar.
Above the workbook is a section of command tabs called the, multitude of options are found behind each tab