Excel vocabulary
Key Tip
A Key Tip is a string. Its maximum width is equal to 3 characters. As seen from the image above, there are two key tips starting with the 'A' character. Pressing this character hides other key tips.
cell
A cell is the intersection between a row and a column on a spreadsheet that starts with cell A1. Below is an illustrated example of a highlighted cell in Microsoft Excel; the cell address, cell name, or cell pointer "D8" (column D, row 8) is the selected cell and the location of what is being modified.
cell reference
A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate. In one or several formulas, you can use a cell reference to refer to: Data from one cell on the worksheet
dialog box
A dialog box in Excel is a form that allows users to input information and make choices about different aspects of the current worksheet or its content - such as data, charts, or graphic images.
folder
A digital folder has the same purpose as a physical folder - to store documents. Computer folders can also store other types of files, such as applications, archives, scripts, and libraries. Folders can even store other folders, which may contain additional files and folders.
keywords
A range of data that is brought into a worksheet but that originates outside of Excel, such as in a database or text file. ... A reference to a cell or range on a sheet in another Excel workbook, or a reference to a defined name in another workbook.
shortcut menu
A shortcut menu is a menu that appears when you right-click an object. In Microsoft Forms, the following objects have
task pane
A task pane is a multipurpose window pane that appears on the right side of the window of an Office application. They're new to Office 2003, and can be mighty confusing. This sample book chapter clears away the fog.
formula bar
A toolbar at the top of the Microsoft Excel spreadsheet window that you can use to enter or copy an existing formula in to cells or charts. It is labeled with function symbol (fx). By clicking the Formula Bar, or when you type an equal (=) symbol in a cell, the Formula Bar will activate.
workbook
A workbook is the MS Excel file in which you enter and store related data. A worksheet (also known as a spreadsheet) is a collection of cells on a single "sheet" where you actually keep and manipulate the data. Each workbook can contain many worksheets.
worksheet
An Excel worksheet is a single spreadsheet that contains cells organized by rows and columns. A worksheet begins with row number one and column A. Each cell can contain a number, text or formula. A cell can also reference another cell in the same worksheet, the same workbook or a different workbook.
active cell
An active cell refers to a cell in Excel spreadsheet that is currently selected by clicking mouse pointer or keyboard keys. Remember only one cell can be active cell at a time. An active cell is bounded by a heavy border around it.
active tab
An active tab is the tab currently being used. For example, if you have multiple tabs open in your browser since you're reading this page it would be considered the active tab.
gallery
An element of the Excel window that displays the name of the selected cell, table, chart, or object. Term. Normal view (Excel) Definition. A screen view that maximizes the number of cells visible on your screen and keeps the column letters and row numbers close to the columns and rows.
hard copy
An embedded chart is a chart that is drawn on the same worksheet as the data. ... A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.
in-cell editing
An embedded chart is a chart that is drawn on the same worksheet as the data. ... A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell. Gallery.
embedded chart
An embedded chart is a chart that is placed on a worksheet as opposed to on a separate chart sheet when using a spreadsheet software package. Embedded charts play an instrumental role in viewing or printing a chart or a Pivot Chart report using its source data or other information.
relative reference
By default, a cell reference is relative. For example, when you refer to cell A2 from cell C2, you are actually referring to a cell that is two columns to the left (C minus A), and in the same row (2). A formula that contains a relative cell reference changes as you copy it from one cell to another.
Ribbon
Definition: The Ribbon is the strip of buttons and icons located above the work area that was first introduced with Excel 2007. The Ribbon replaces the menus and toolbars found in earlier versions of Excel. Above the Ribbon are a number of tabs, such as Home, Insert, and Page Layout.
theme
Excel offers themes to change the look of your workbook with the click of a button. Each theme consists of 12 colors, two fonts (Headings and Body) and effects for shapes and SmartArt. 1. On the Page Layout tab, in the Themes group, you can see that the worksheet below uses the standard Office theme. 2.
Insert mode
Excel. Double-click the cell in which you want to overtype text, and then press INSERT or INS to turn on or off the over type mode. Note: The Allow editing directly in cells check box must be selected (it is selected by default).
grid lines
Grid lines. Alternatively referred to as a column separator or row separator, Grid lines or grid lines are the light gray lines that divide each of the cells, rows, and columns in a spreadsheet. In the picture below, is an example of grid lines in a Microsoft Excel spreadsheet.
status bar
If you select several cells that contain numeric data and then look at the status bar, at the bottom of the Excel window, you can see that the status bar reports the average, count, and sum of the selected cells (see Figure 3.36). Figure 3.36. The status bar shows the sum, average, and count of the selected cells.
column heading
In Excel and other spreadsheet applications, the column header is the colored row of letters used to identify each column within the sheet, or workbook. The column header row is located above the row one.
sheet tab
In Microsoft Excel, a sheet, sheet tab, or worksheet tab is the current worksheet that is being displayed. Every Excel file is capable of having multiple worksheets, and after opening an Excel file, you will see multiple sheet tabs as shown in the picture.
tab
In Microsoft Excel, a sheet, sheet tab, or worksheet tab is the current worksheet that is being displayed. Every Excel file is capable of having multiple worksheets, and after opening an Excel file, you will see multiple sheet tabs as shown in the picture.
Name box
In Microsoft Excel, the Name Box is the box to the left of the formula bar that displays the cell that is currently selected in the spreadsheet. If a name is defined for a cell that is selected, the Name Box displays the name of the cell. You can use the Name Box to define a name for a selected cell as well.
Home tab
In Microsoft Office, the Home tab is the default tab in Microsoft Word, Microsoft Excel, Microsoft PowerPoint and other Microsoft Office products.
legend
In a chart or graph in spreadsheet programs such as Excel, the legend is most often located on the right hand side of the chart or graph and can sometimes be surrounded by a border. The legend is linked to the data being graphically displayed in the plot area of the chart. The legend is also known as a Chart's Key.
insertion point
In graphics-based programs, the insertion point is the point where the next characters typed from the keyboard will appear on the display screen. The insertion point is usually represented by a blinking vertical line. You can reposition the insertion point by pressing arrow keys or by moving the I-beam pointer.
Overtype mode
In the Word Options dialog box, click Advanced. Do one of the following: To enable the INSERT key in order to control Over type mode, click to select the Use the Insert key to control over type mode check box. To keep Over type mode always enabled, click to select the Use over type mode check box.
left-aligned
In typesetting and page layout, alignment or range is the setting of text flow or image placement relative to a page, column, table cell, or tab.
merging cells
Merged cells are a special formatting applied to cells, in the sense that they are the equivalent of a single cell that would be spread horizontally along an arbitrary amount of columns, or vertically along an arbitrary amount of rows, or both.
metadata
Metadata is data that describes other data. Meta is a prefix that in most information technology usages means "an underlying definition or description." Metadata summarizes basic information about data, which can make finding and working with particular instances of data easier.
SUM function
Microsoft Excel defines SUM as a formula that "Adds all the numbers in a range of cells". This definition clearly points that Sum function has a job to add numbers and the arguments can be supplied using combinations of both numbers and range of cells.
Microsoft Office Excel
Microsoft Excel is a spreadsheet program included in the Microsoft Office suite of applications. Spreadsheets present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions.
point size
Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.
value axis
Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.
Enhanced Screen Tip
Screen Tips are small windows that display descriptive text when you rest the pointer on a command or control. Enhanced Screen Tips are larger windows that display more descriptive text than a Screen Tip and can have a link to a Help article.
AutoCalculate area
The Auto Calculate area, located on the status bar, allows you to easily obtain a total, average or other information about the numbers in a range.
Mini toolbar
The Mini Toolbar for Microsoft Word 2010 features many options for editing the format of text. To access the Mini Toolbar, [Right-Click] a section of a Word, Excel, Outlook or PowerPoint document. Or, select an area of text and hover your mouse over the selection.
Office Button
The Office Button is located in the upper-left corner of the following 2007 Microsoft Office system programs: Word, Excel, PowerPoint, Access, and Outlook (in the composing and reading windows).
Quick Access Toolbar
The Quick Access Toolbar is a customization toolbar that contains a set of commands that are independent of the tab on the ribbon that is currently displayed. You can move the Quick Access Toolbar from one of the two possible locations, and you can add buttons that represent commands to the Quick Access Toolbar.
row heading
The row heading or row header is the gray-colored column located to the left of column 1 in the worksheet containing the numbers (1, 2, 3, etc.) used to identify each row in the worksheet.
text
To retain leading zeros, format the input range as Text before you paste or enter values. Select the column, or range where you'll be putting the values, then use CTRL+1 to bring up the Format > Cells dialog and on the Number tab select Text. Now Excel will keep your leading 0's.
category axis
When you create a chart from worksheet data that uses dates, and the dates are plotted along the horizontal (category) axis in the chart, Microsoft Office Excel automatically changes the category axis to a date (time-scale) axis. You can also manually change a category axis to a date axis.
font type
You can change the font or font size for selected cells or ranges in a worksheet. You can also change the default font and font size that are used in new workbooks. ... Select the cell, range of cells, text, or characters that you want to format.
scroll bars
a long thin section at the edge of a computer display by which material can be scrolled using a mouse.
sub menu
a menu accessed from a more general menu.
scroll arrows
scroll arrow - Computer Definition. On-screen arrow that is clicked in order to scroll the screen in the corresponding direction. The screen moves one line, or increment, with each mouse click.