Chapter 5,6, and 7 Excel Test
Order of Operations
The precedence Excel follows to evaluate a mathematical expression.
Consolidation
The process of summarizing data included on multiple worksheets on one worksheet
3-D reference
The reference to a range that spans two or more worksheet
Fill Handle
The solid square in the lower-right corner of a selected cell that is dragged to copy the contents of a cell to adjacent cells.
ROUND function
Used for formulas that potentially can result in more decimal places that the applied format displays in a given cell
Cell Styles
Used to apply several formats in one step.
Sheet Tab
Used to display a worksheet
Margins
Used to increase or decrease the white space surrounding the printed worksheet or chart
Clip Art
A general-purpose graphic created by an artist using illustration software.
PivotChart report
A graphical representation of the data in a PivotTable report.
Style
A group of format specifications that are assigned to a style name (Home tab | Styles group)
Template
A master workbook that includes the basic elements for a particular type fo workbook.
Data Model
A method of incorporating data from multiple, related tables into an Excel worksheet.
3-D range
A range that spans two or more sheets in a workbook
Link
A reference to a cell or range of cells in another worksheet in the same workbook using 3-D references
Format code
A series of format symbols that defines how a cell entry assigned to a format will appear
Move Data
Delete data from a worksheet and then place that data at a different location in the workbook or into another file.
Formula Bar
Displays the active cell's contents. Located above the cells.
Name Box
Displays the cell reference of the active cell. Located at the top of the worksheet.
Slicer
Easy-to-use filtering control with buttons that enable you to drill down through large amounts of data.
Conditional Formatting
Formatting that is applied to a cell when a specified condition is met.
Destination
The upper-left cell of the range where data is to be pasted.
Filter
To limit the display of data to only specific information.
Duplicate Data
To make a copy of data and thenplace that copy at a different location in the worksheet or into a compltely different document.
Sheet reference
To reference cell s in other sheets in a workbook, you use the sheet name which serves as the sheet reference and cell reference
Drilling an entry
To speed data entry, Excel allows you to enter a number once & copy it through worksheets so that it is entered in the same cell on all the selected sheets
Business Intelligence Tools
Used to perform data analysis and create sophisticated charts and reports
Dependent workbook
Usually a consolidated workbook that depends on other open workbooks for linked data
Columns
Vertical part of the worksheet grid identified by the letters A to Z and AA to XFD.
Page Layout View
View that displays the worksheet as a printed page.
Filtering button
A button on a slicer which you use to select the item by which to filter.
Clear Filter
A button that removes a filter.
Relative Cell Reference
A cell reference that reflects the row or column it has been copied to.
Keyword
A descriptive word used to search for clip art.
Insertion Point
A blinking vertical line that indicates where the next character typed will be placed.
Field button
A button on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart.
PivotTable Fields pane
A window that lists, at the top, all of the fields—column titles—from the source data for use in the PivotTable report and at the bottom, an area in which you can arrange the fields in the PivotTable.
Custom format codes
Allow you to specify how a cell entry assigned a format will appear
PowerPivot
Allows you to analyze data from multiple sources, work with multiple data tables, and create relationships between tables
PowerView
Allows you to create and interact with multiple charts, slicers, and other data visualizations in a single worksheet
Quick Explore
Allows you to drill down through PivotTable data with a single click
Workbook
An Excel File
Spreadsheet
An application used to store and analyze the data.
FILTER area
An area in the lower portion of the PivotTable Fields pane to position fields by which you want to filter the PivotTable report, enabling you to display a subset of data in the PivotTable report.
VALUES area
An area to position fields that contain data that is summarized in a PivotTable report or PivotChart report. The data placed here is usually numeric or financial in nature and the data is summarized—summed. You can also perform other basic calculations such as finding the average, the minimum, or the maximum.
COLUMNS area
An area to position fields that you want to display as columns in the PivotTable report. Field names placed here become column titles, and the data is grouped in columns by these titles.
ROWS area
An area to position fields that you want to display as rows in the PivotTable report. Field names placed here become row titles, and the data is grouped by these row titles.
Relationship
An association between tables that share a common field.
Circular Reference
An error that occurs when a formula references the cell it is stored in.
PivotTable
An interactive Excel report that summarizes and analyzes large amounts of data.
Footer
Appears at the bottom of every printed page
Header
Appears at the top of every printed page
Adjacent Cells
Cells that are next to each other.
Pointing
Clicking a cell to place its reference in a formula.
Standard accounting format
Contains floating dollar signs in the first row of numbers and the totals row
Date
Data displayed as a calendar date.
Time
Data displayed as a time (i.e., 12:30 PM).
Page setup
Defines the appearance & format of a printed worksheet
Row
Horizontal part of the worksheet grid identified by the numbers 1 to 1,048,576.
Title
In an HTML document, the text that is displayed in the title bar.
Data
Information stored in a worksheet. Categorized as etiher label, value, or date/time.
Formula
Mathematical statement used to calculate a value. Must always begin with an equal sign.
Value
Numeric data that can be used in calculations.
Add-ins
Optional commands and features that are not immediately available; you must first install and/or active this before you can use it.
Headings
Row numbers and column letters.
Workspace file
Saves information about all the workbooks that are open
Source
Selected cells to be copied or moved.
Range
Selection of two or more cells.
Sheet
Sheets in an Excel Workbook.
Worksheet
Sheets in an Excel Workbook.
Page breaks
Show the boundaries of what will print on each page
Gridlines
Solid lines that mark off the rows and columns in a worksheet.
Label
Text stored in a cell that cannot be used in calculations.
Associated PivotTable report
The PivotTable report in a workbook that is graphically represented in a PivotChart.
Boundary
The bar seperating the column letters at the top of the worksheet.
Active Cell
The cell displayed with a bold border.
Selected Cell
The cell displayed with a bold border.
Cell Reference
The column letter and row number that identify a cell, such as B3.
Field names
The column titles from source data that form the categories of data for a PivotTable.
Refresh
The command to update a worksheet to reflect the new data.
Source data
The data for a PivotTable, formatted in columns and rows, which can be located in an Excel worksheet or an external source.
HTML
The file format for documents viewed using a browser.
Cell
The intersection of a row and column.
Source workbooks
The linked workbooks related to the dependent workbook
Layout section
The lower portion of the PivotTable Fields pane containing the four areas for layout; use this area to rearrange and reposition fields in the PivotTable.
Slicer header
The top of a slicer that indicates the category of the slicer items
Field section
The upper portion of the PivotTable Fields pane containing the fields—column titles—from your source data; use this area to add fields to and remove fields from the PivotTable.
