Calculated fields can perform calculations by using the contents of other fields in the PivotTable or PivotChart.Īn item within a PivotTable field or PivotChart field that uses a formula you create. It automatically expands to include additional rows so that the formula is immediately extended to those rows.Ī field in the result set of a query that displays the result of an expression rather than data from a database.Ī field in a PivotTable or PivotChart that uses a formula you create. In an Excel table, a calculated column uses a single formula that adjusts for each row. Borders distinguish, emphasize, or group items. This can be an Internet address (URL), a path to a folder on your hard drive, or a path to a folder on a network.Ī decorative line that can be applied to worksheet cells or objects, such as charts, pictures, or text boxes. The relative path that Excel uses for the destination address when you insert a hyperlink. The x-axis is usually the horizontal axis and contains categories. The y axis is usually the vertical axis and contains data. Excel determines the levels of summary and detail in the selected range and applies the formats accordingly.Ī line bordering the chart plot area used as a frame of reference for measurement. When you change the layout of either report, the other also changes.Ī built-in collection of cell formats (such as font size, patterns, and alignment) that you can apply to a range of data. It is created automatically when you create a new PivotChart. The PivotTable that supplies the source data to the PivotChart. Array formulas are enclosed between braces and are entered by pressing CTRL+SHIFT+ENTER. An array range shares a common formula an array constant is a group of constants used as an argument.Ī formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. Common arguments that are used within functions include numbers, text, cell references, and names. The type of argument a function uses is specific to the function. The values that a function uses to perform operations or calculations. An address can be a URL (Web address) or a UNC path (network address), and can include a specific location within a file, such as a Word bookmark or an Excel cell range.Ī folder in addition to the XLStart folder that contains workbooks or other files that you want to be opened automatically when you start Excel and templates that you want to be available when you create new workbooks. The path to an object, document, file, page, or other destination. The name on the tab of the active sheet is bold. The sheet that you're working on in a workbook. The active cell is bounded by a heavy border. The selected cell in which data is entered when you begin typing. To activate a sheet, click the tab for the sheet in the workbook. The sheet that you activate determines which tabs are displayed. To make a chart sheet or worksheet the active, or selected, sheet. Two walls and one floor are displayed within the plot area. The areas surrounding many 3-D chart types that give dimension and boundaries to the chart. A reference to a range that spans two or more worksheets in a workbook.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |